目录
openpyxl库的简介
openpyxl是一个用于读取/编写Excel 2010 xlsx/xlsm/xltx/xltm文件的Python库。它是由于缺乏从Python中读取/编写Office Open XML格式的现有库而诞生的。所有这些都归功于PHPExcel团队,因为openpyxl最初是基于PHPExcel的。
官方文档:https://openpyxl.readthedocs.io/en/stable/
openpyxl库的安装
pip install openpyxl
openpyxl库的使用方法
1. from openpyxl import Workbook 2. wb = Workbook() 3. 4. # grab the active worksheet 5. ws = wb.active 6. 7. # Data can be assigned directly to cells 8. ws['A1'] = 42 9. 10. # Rows can also be appended 11. ws.append([1, 2, 3]) 12. 13. # Python types will automatically be converted 14. import datetime 15. ws['A2'] = datetime.datetime.now() 16. 17. # Save the file 18. wb.save("sample.xlsx")