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
网友评论