python
from xlwt import Workbookbook = Workbook()sheet1 = book.add_sheet('Sheet 1') #添加一个sheetbook.add_sheet('Sheet 2')sheet1.write(0,0,'A1') #通过sheet添加cell值sheet1.write(0,1,'B1')row1 = sheet1.row(1)row1.write(0,'A2') #还可以通过row属性添加cell值row1.write(1,'B2')sheet1.col(0).width = 10000sheet2 = book.get_sheet(1)sheet2.row(0).write(0,'Sheet 2 A1') #又一种添加sheet2.row(0).write(1,'Sheet 2 B1')sheet2.flush_row_data()sheet2.write(1,0,'Sheet 2 A3')sheet2.col(0).width = 5000sheet2.col(0).hidden = Truebook.save('simple.xls')转载于:https://www.cnblogs.com/zhaopAC/p/7398215.html
相关资源：python爬虫20个案例