Python's Excel operations

XLRD,XLWT and xlutils are high-efficiency tools for working with Excel documents (*.xls) in Python. Wherein, XLRD can only read XLS,XLWT only new XLS (can not be modified), Xlutils can xlrd. Book to Xlwt.workbook, allowing you to modify the data based on the existing XLS and create a new XLS to implement the modification.

Import xlwt# Write Excel
BOOK=XLWT. Workbook () #创建一个工作簿
Sheet=book.add_sheet (' haha ') #创建一个表名
Sheet.write (2,3, ' Peng Jia ')
Book.save (' Wawa.xls ') #保存一个excel文件

Python's Excel operations