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.2.tar.gz
(1.8 kB
view hashes)
Built Distribution
Close
Hashes for merged_excel_tools-1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6bd9fa1629c2e6f8e4acc762cec7e974fd20819ed2c6c587b88705e7c11befe0 |
|
MD5 | 946f0253d0bef0514003a40b72f78fb2 |
|
BLAKE2b-256 | 20512d441f0b50655da2e572b56243ff7c2f08a65c64e70589dd6b716e25eb2f |