merged cells excel tools
Project description
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 = me.getRowFromRange(range, 0)
# 这是合并单元格的尾
end = me.getRowFromRange(range, 1)
#这是A区域的合并单元格的值
As = me.get("A",start)
注意
使用openpyxl来读取excel表格
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
merged_excel_tools-1.3.tar.gz
(1.8 kB
view hashes)
Built Distribution
Close
Hashes for merged_excel_tools-1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 24e101bd74de710d3f8ec75f1f1e8cddb225373b75aa0090a79f3231fa76f31f |
|
MD5 | 083bbcf15104411b3bce6d749db2c14b |
|
BLAKE2b-256 | edb6e5cbfe61863ed90f550d2769633437fc473993a5cf2e70c0918d60144bfa |