练习：填入任意数字，宋体，左，上对齐,将表格中已有文字改为隶书,使表格中大于10的数字显示为红色

向日统计填入以下指定格式，1星级填入任意数字，宋体，左，上对齐；2星级将表格中已有文字改为隶书；# 3星级使表格中大于10的数字显示为红色

from xlutils.copy import copyimport xlrdimport xlwt
tem_excel = xlrd.open_workbook(‘D:/日统计.xls’, formatting_info=True)tem_sheet = tem_excel.sheet_by_index(0)
new_excel = copy(tem_excel)new_sheet = new_excel.get_sheet(0)
style = xlwt.XFStyle() # 初始化样式
font = xlwt.Font() # 设置字体font.name = '宋体’font.bold = Truefont.height = 360style.font = font # 将设置好的字体样式保存到新建的初始化样式中
borders = xlwt.Borders() # 设置边框borders.top = xlwt.Borders.THINborders.bottom = xlwt.Borders.THINborders.left = xlwt.Borders.THINborders.right = xlwt.Borders.THINstyle.borders = borders # 将设置好的边框样式保存到初始化样式中
alignment = xlwt.Alignment() # 设置对齐方式alignment.horz = xlwt.Alignment.HORZ_LEFTalignment.vert = xlwt.Alignment.VERT_TOPstyle.alignment = alignment # 将设置好的对齐方式保存到初始化样式中
style_red = xlwt.XFStyle()
font_red = xlwt.Font()font_red.name = '宋体’font_red.bold = Truefont_red.height = 360font_red.colour_index = 2style_red.font = font_red
borders_red = xlwt.Borders()borders_red.top = xlwt.Borders.THINborders_red.bottom = xlwt.Borders.THINborders_red.left = xlwt.Borders.THINborders_red.right = xlwt.Borders.THINstyle_red.borders = borders_red
alignment_red = xlwt.Alignment()alignment_red.horz = xlwt.Alignment.HORZ_LEFTalignment_red.vert = xlwt.Alignment.VERT_TOPstyle_red.alignment = alignment_red
style_lishu18 = xlwt.XFStyle()
font_lishu18 = xlwt.Font()font_lishu18.name = '隶书’font_lishu18.bold = Truefont_lishu18.height = 360style_lishu18.font = font_lishu18
borders_lishu18 = xlwt.Borders()borders_lishu18.top = xlwt.Borders.THINborders_lishu18.bottom = xlwt.Borders.THINborders_lishu18.left = xlwt.Borders.THINborders_lishu18.right = xlwt.Borders.THINstyle_lishu18.borders = borders_lishu18
alignment_lishu18 = xlwt.Alignment()alignment_lishu18.horz = xlwt.Alignment.HORZ_CENTERalignment_lishu18.vert = xlwt.Alignment.VERT_CENTERstyle_lishu18.alignment = alignment_lishu18
style_lishu22 = xlwt.XFStyle()
font_lishu22 = xlwt.Font()font_lishu22.name = '隶书’font_lishu22.bold = Truefont_lishu22.height = 440style_lishu22.font = font_lishu22
borders_lishu22 = xlwt.Borders()borders_lishu22.top = xlwt.Borders.THINborders_lishu22.bottom = xlwt.Borders.THINborders_lishu22.left = xlwt.Borders.THINborders_lishu22.right = xlwt.Borders.THINstyle_lishu22.borders = borders_lishu22
alignment_lishu22 = xlwt.Alignment()alignment_lishu22.horz = xlwt.Alignment.HORZ_CENTERalignment_lishu22.vert = xlwt.Alignment.VERT_CENTERstyle_lishu22.alignment = alignment_lishu22
zhangsan_num = int(input(‘请输入张三粮配入库量：’))lisi_num = int(input(‘请输入李四粮食入库量：’))wangwu_num = int(input(‘请输入王五小麦入库量：’))zhaoliu_num = int(input(‘请输入赵六麦子专营入库量：’))

stylex = lambda x: style_red if x > 10 else style # 解释lambda函数：https://www.cnblogs.com/mengxiaoleng/p/11549221.html

new_sheet.write(0, 0, tem_sheet.cell_value(0, 0), style_lishu22) # 用建好的隶书样式来修改数据new_sheet.write(1, 0, tem_sheet.cell_value(1, 0), style_lishu18)new_sheet.write(1, 1, tem_sheet.cell_value(1, 1), style_lishu18)new_sheet.write(2, 0, tem_sheet.cell_value(2, 0), style_lishu18)new_sheet.write(3, 0, tem_sheet.cell_value(3, 0), style_lishu18)new_sheet.write(4, 0, tem_sheet.cell_value(4, 0), style_lishu18)new_sheet.write(5, 0, tem_sheet.cell_value(5, 0), style_lishu18)

new_sheet.write(2, 1, zhangsan_num, stylex(zhangsan_num))new_sheet.write(3, 1, lisi_num, stylex(lisi_num))new_sheet.write(4, 1, wangwu_num, stylex(wangwu_num))new_sheet.write(5, 1, zhaoliu_num, stylex(zhaoliu_num))

new_excel.save(‘D:/填写.xls’)