XlsxWriter操作Excel

python操作excel的模块是XlsxWriter,可以操作多个工作表的文字、数字、公式、图表。

简单例子:

#!/usr/bin/env python
import xlsxwriter
workbook=xlsxwriter.Workbook('d:\demo.xls')
worksheet=workbook.add_worksheet()
worksheet.write(2,0,32)
worksheet.write(3,0,35.5)
worksheet.write(4,0,'=sum(A3:A4)')
workbook.close()

posted @ 2015-12-23 16:55  sunshineyue  阅读(601)  评论(0)    收藏  举报