Working with Excel Files in Python

image.png

1、xlrd xlwt

只支持 xls 格式

image.png image.png

pip install xlrd
pip install xlwt

https://xlrd.readthedocs.io/en/latest/
https://xlwt.readthedocs.io/en/latest/

2、xlutils

pip install xlutils

https://xlutils.readthedocs.io/en/latest/

3、xlwings

pip install xlwings

https://docs.xlwings.org/en/latest/

4、openpyxl

pip install openpyxl

https://openpyxl.readthedocs.io/en/stable/

5、xlswriter

pip install XlsxWriter

https://xlsxwriter.readthedocs.io/

6、pandas

pip install pandas

https://pandas.pydata.org/docs/

参考：https://blog.csdn.net/lm_love_hxl/article/details/130733070