python 自动办公- Excel_xlutils设置格式.zip

from xlutils.copy import copy import xlrd import xlwt tem_excel = xlrd.open_workbook('日统计.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 = True # 18*20 font.height = 360 style.font = font # 边框：细线==THIN borders = xlwt.Borders() borders.top = xlwt.Borders.THIN borders.bottom = xlwt.Borders.THIN borders.left = xlwt.Borders.THIN borders.right = xlwt.Borders.THIN style.borders = borders # 对齐 alignment = xlwt.Alignment() alignment.horz = xlwt.Alignment.HORZ_CENTER alignment.vert = xlwt.Alignment.VERT_CENTER style.alignment = alignment new_sheet.write(2, 1, 12) new_sheet.write(3, 1, 18) new_sheet.write(4, 1, 19) new_sheet.write(5, 1, 15) # new_sheet.write(2, 1, 12, style) # new_sheet.write(3, 1, 18, style) # new_sheet.write(4, 1, 19, style) # new_sheet.write(5, 1, 15, style) new_excel.save('填写.xls')