简单使用xlwt
import xlwt
workbook = xlwt.Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('sheet1')
worksheet.write(0, 0, 'hello')
style = xlwt.XFStyle()
workbook.save('students.xls')
向单元格添加一个公式:
import xlwt
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('My Sheet')
worksheet.write(0, 0, 5)
worksheet.write(0, 1, 2)
worksheet.write(1, 0, xlwt.Formula('A1*B1'))
worksheet.write(1, 1, xlwt.Formula('SUM(A1,B1)'))
workbook.save('Excel_Workbook.xls')
输入一个日期到单元格:
import xlwt
import datetime
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('My Sheet')
style = xlwt.XFStyle()
style.num_format_str = 'M/D/YY'
worksheet.write(0, 0, datetime.datetime.now()