pip install xlwt

import xlwt

from datetime import datetime

#样式

style0 = xlwt.easyxf('font:color-index red,bold on',num_format_str='0.00') #字体和数字样式

style1 = xlwt.easyxf(num_format_str='YYYY-MM-DD') #日期样式

#新建excel和sheet

wb = xlwt.Workbook()

sheet1 = wb.add_sheet('sheet1',cell_overwrite_ok=True) # cell_overwrite_ok允许修改单元格

#写入数据

sheet1.write(0,0,1234.5678,style0)

sheet1.write(1,0,datetime.now(),style1)

sheet1.write(2,0,1)

sheet1.write(2,1,2)

sheet1.write(2,2,xlwt.Formula("A3+B3"))

# 新建sheet2

sheet2 = wb.add_sheet('sheet2')

sheet2.write(0,0,1000000)

sheet1.write(0,0,99999999,style0)

#保存

wb.save('test.xls')