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()
浙公网安备 33010602011771号