写入
import xlwt
def fun3_2_2():
workbook = xlwt.Workbook(encoding= 'ascii')
worksheet = workbook.add_sheet("My new Sheet")
worksheet.write(0,0, "内容1")
worksheet.write(2,1, "内容2")
workbook.save("fun3_2_2.xls")
设置字体
def fun3_2_3():
workbook = xlwt.Workbook(encoding= 'ascii')
worksheet = workbook.add_sheet("My new Sheet")
style = xlwt.XFStyle()
font = xlwt.Font()
font.name = 'Times New Roman'
font.bold = True
font.underline = True
font.italic = True
style.font = font
worksheet.write(0,0, "内容1")
worksheet.write(2,1, "内容2",style)
workbook.save("fun3_2_3.xls")
设置列宽
def fun3_2_4():
workbook = xlwt.Workbook(encoding= 'ascii')
worksheet = workbook.add_sheet("My new Sheet")
worksheet.write(0,0, "内容1")
worksheet.write(2,1, "内容2")
worksheet.col(0).width = 256*20
workbook.save("新创建的表格.xls")
设置行高
def fun3_2_5():
workbook = xlwt.Workbook(encoding= 'ascii')
worksheet = workbook.add_sheet("My new Sheet")
worksheet.write(0,0, "内容1")
worksheet.write(2,1, "内容2")
style = xlwt.easyxf('font:height 360;')
row = worksheet.row(0)
row.set_style(style)
workbook.save("fun3_2_5.xls")
合并
def fun3_2_6():
workbook = xlwt.Workbook(encoding= 'ascii')
worksheet = workbook.add_sheet("My new Sheet")
worksheet.write(0,0, "内容1")
worksheet.write_merge(1, 2, 0, 3, 'Merge Test')
workbook.save("fun3_2_6.xls")
添加边框
def fun3_2_7():
workbook = xlwt.Workbook(encoding= 'ascii')
worksheet = workbook.add_sheet("My new Sheet")
worksheet.write(0,0, "内容1")
borders = xlwt.Borders()
borders.left = xlwt.Borders.DASHED
borders.right = xlwt.Borders.DASHED
borders.top = xlwt.Borders.DASHED
borders.bottom = xlwt.Borders.DASHED
borders.left_colour = 0x40
borders.right_colour = 0x40
borders.top_colour = 0x40
borders.bottom_colour = 0x40
style = xlwt.XFStyle()
style.borders = borders
worksheet.write(0, 0, '内容1', style)
worksheet.write(2,1, "内容2")
workbook.save("fun3_2_7.xls")
背景色设置
def fun3_2_8():
workbook = xlwt.Workbook(encoding= 'ascii')
worksheet = workbook.add_sheet("My new Sheet")
worksheet.write(0,0, "内容1")
pattern = xlwt.Pattern()
pattern.pattern = xlwt.Pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 5
style = xlwt.XFStyle()
style.pattern = pattern
worksheet.write(2,1, "内容2",style)
workbook.save("fun3_2_8.xls")
单元格子对齐
def fun3_2_9():
workbook = xlwt.Workbook(encoding= 'ascii')
worksheet = workbook.add_sheet("My new Sheet")
worksheet.write(0,0, "内容1")
style = xlwt.XFStyle()
al = xlwt.Alignment()
al.horz = 0x02
al.vert = 0x01
style.alignment = al
worksheet.write(2,1, "内容2",style)
workbook.save("fun3_2_9.xls")