Based on openpyxl and xlwings to facilitate Excel processing
Project description
Excel Tidy
在工作中遇到的一些需要处理的情况,编写为库,方便后续操作
openpyxl
前缀的函数为基于openpyxl
编写
xlwings
同上
注意xlwings
不支持linux
,在linux
上运行可能报错
使用方法
git clone https://github.com/cmacckk/exceltidy.git
安装依赖
pip install -r requirements.txt
openpyxl
获取list[list, list, ...]
openpyxl.workbook.Workbook
openpyxl.worksheet.worksheet.Worksheet
worksheet_datas, workbook, worksheet = openpyxl_get_datas_workbook_worksheet(filename="./test.xlsx")
# 通过工作表获取数据
datas = openpyxl_get_datas(worksheet)
# 替换工作表数据
openpyxl_replace_worksheet_data(origin_worksheet, to_be_replaced_worksheet)
# 保存及关闭工作薄
workbook.save('./result.xlsx')
workbook.close()
xlwings
获取App
xw.Book
xw.Sheet
sheet_name
为None
时读取返回第一个工作表
app, workbook, worksheet = xlwings_get_app_workbook_worksheet('./test.xlsx')
#
_, _, to_be_replaced_worksheet = xlwings_get_app_workbook_worksheet('./test2.xlsx', sheet_name='sort')
# 替换工作表数据
xlwings_replace_worksheet_data(origin_worksheet, to_be_replaced_worksheet)
# 排序
xlwings_sort(worksheet, "A4:L11", "L4:L11", 'descending')
# 保存及关闭工作薄、App
workbook.save()
workbook.close()
app.quit()
openpyxl_parse_multi_title_to_single
及openpyxl_parser_merged_cell
使用方法详见代码函数
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
exceltidy-0.0.3.tar.gz
(17.4 kB
view hashes)
Built Distribution
exceltidy-0.0.3-py3-none-any.whl
(18.2 kB
view hashes)
Close
Hashes for exceltidy-0.0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5f31242f134bccc0267666fc5b51a35890abfb429fba844ea7a4545fd1c0b85a |
|
MD5 | 1c4c012dc0bd4aa5b0ce916a77edbee2 |
|
BLAKE2b-256 | a91685bca783dfe38d01fae6302d114320dc65c39f9470681511004efebb136c |