| pip · PyPI | .xls | .xlsx | 读取 | 消耗时间(10MB) | 写入 | 修改 | 保存 | 样式调整 | 插入图片 | 库 | 引用 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| xlrd | √ | √ | √ | 12.38s | × | × | × | × | × | pip install xlrd | import xlrd |
| xlwt | √ | × | × | - | √ | √ | √ | √ | √ | pip install xlwt | import xlwt |
| xlutils | √ | × | × | - | √ | √ | √ | × | × | pip install xlutils | import xlutils |
| xlwings | √ | √ | √ | 7.06s | √ | √ | √ | √ | √ | pip install xlwings | import xlwings |
| XlsxWriter | √ | √ | × | - | √ | × | √ | √ | √ | pip install XlsxWriter | import xlsxwriter |
| openpyxl | × | √ | √ | 27.93s | √ | √ | √ | √ | √ | pip install openpyxl | import openpyxl |
| pandas | √ | √ | √ | 17.55s | √ | × | √ | × | × | pip install pandas | import pandas |
Pandas数据读取与输出
pandas.to_excel pd写数据到excel(tcy)
openpyxl
如何用Python操作Excel自动化办公？一个案例教会你openpyxl——样式和条件格式
openpyxl操作excel 删除行
