merged cells excel tools
Project description
merged_excel_tools
读取合并单元格的工具类
这是用来读取特定格式(合并单元格)的Excel表格的工具类,格式如下
install
使用pip
pip install merged_excel_tools
使用方法
from merged_excel_tools import *
worksheet,ranges=getMergedList("example.xlsx")
for range in ranges:
# 这是合并单元格的首
start = getRowFromRange(range, 0)
# 这是合并单元格的尾
end = getRowFromRange(range, 1)
注意
使用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.1.tar.gz
(1.7 kB
view hashes)
Built Distribution
Close
Hashes for merged_excel_tools-1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ab0be2159e7cf0ab76ece6dc91f2d08ceb93249f271c6866e4d6888c1c829007 |
|
MD5 | aceb05dab4f0378ced0933994e472029 |
|
BLAKE2b-256 | 32df9639cd7059594f1a31ec8a13fa77652b6a47434d198d07fd300f7b5b5ed1 |