import xlwtwb = xlwt.Workbook()ws = wb.add_sheet('A Test Sheet') # 增加sheet# style2 = xlwt.easyxf('pattern: pattern solid, fore_colour ice_blue')# style3 = xlwt.easyxf('pattern: pattern solid, fore_colour light_yellow')ws.write(0, 0, '11111111', style=xlwt.easyxf('pattern: pattern solid, fore_colour red')) # 0 行 0 列ws.write(1, 1, '22222222', style=xlwt.easyxf('pattern: pattern solid, fore_colour ice_blue')) # 1行 1列ws.write(2, 2, '333333333', style=xlwt.easyxf('pattern: pattern solid, fore_colour yellow'))ws.write(3, 3, '44444444444', style=xlwt.easyxf('pattern: pattern solid, fore_colour pink'))# ws.write(行,列,data, style=xlwt.easyxf('pattern: pattern solid, fore_colour pink'))wb.save('example.xls') # 保存xls
参考 :/xiao-apple36/p/9603499.html