Python 复制Excel与设置格式

Python写入Excel携带格式

from xlutils.copy import copy
import xlrd
import xlwt

#携带格式打开一个文件
tem_excel = xlrd.open_workbook('日统计.xls', formatting_info=True)
#获取索引0的sheet 要不要无所谓
# tem_sheet = tem_excel.sheet_by_index(0)
#复制excel
new_excel = copy(tem_excel)
#获取sheet
new_sheet = new_excel.get_sheet(0)

#预定一个格式
style = xlwt.XFStyle()

#字体
font = xlwt.Font()
font.name = '微软雅黑'
font.bold = True
#字体大小*20
font.height = 360
style.font = font

#边框
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')