merged_excel_tools
读取合并单元格的工具类
这是用来读取特定格式(合并单元格)的Excel表格的工具类，格式如下
install
使用pip
pip install merged_excel_tools
使用方法
from merged_excel_tools import merged_excel
me = merged_excel("example.xlsx")
ranges=me.getMergedList()
for range in ranges:
# 这是合并单元格的首
start = range.min_row
# 这是合并单元格的尾
end = range.max_row
#这是A区域的合并单元格的值
As = me.getValue("A",start)
注意
使用openpyxl来读取excel表格
1 maintainer
Metadata
1 maintainer
Release files for merged-excel-tools 1.4
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| merged_excel_tools-1.4-py3-none-any.whl | Python 3 | none | any | Details |
Release files / merged_excel_tools-1.4-py3-none-any.whl
| Download URL | merged_excel_tools-1.4-py3-none-any.whl |
|---|---|
| Size | 2.1 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
d37785cc93605f56d058920e78ef7eda9673793d58eefec6fd09e88c35e9ed66
|
|
BLAKE2b-256 checksum How to use checksums |
1d220784e3d7a48fc3763d61b86f29d57a439de12ec7bb7a4c271490eb9ea6d6
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.11.0 pkginfo/1.4.2 requests/2.18.4 setuptools/39.1.0 requests-toolbelt/0.8.0 tqdm/4.24.0 CPython/3.6.5
|
