Metadata-Version: 2.1
Name: merged-excel-tools
Version: 1.2
Summary: merged cells excel tools
Home-page: https://github.com/zhangtao103239/read_merged_tools
Author: zhangtao103239
Author-email: zhangtao103239@163.com
License: UNKNOWN
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Description-Content-Type: text/markdown
Requires-Dist: openpyxl

# merged_excel_tools
读取合并单元格的工具类

这是用来读取特定格式(合并单元格)的Excel表格的工具类，格式如下
![table.png](https://s1.ax1x.com/2018/08/13/Pg8gH0.png)

## install
使用pip
```python
pip install merged_excel_tools
```
## 使用方法
```python
from merged_excel_tools import merged_excel
me = merged_excel("example.xlsx")
ranges=me.getMergedList()
for range in ranges:
    # 这是合并单元格的首
    start = me.getRowFromRange(range, 0)
    # 这是合并单元格的尾
    end = me.getRowFromRange(range, 1)
    #这是A区域的合并单元格的值
    As = me.get("A",start)
```

### 注意
使用openpyxl来读取excel表格


