import xlwt
创建excel,新增sheet
book = xlwt.Workbook(encoding='utf-8')
sheet = book.add_sheet('sheet1')
设置列宽
table.col(3).width = 15000
初始化样式
style = xlwt.XFStyle()
设置字体在单元格的位置
alignment = xlwt.Alignment()
alignment.horz = xlwt.Alignment.HORZ_CENTER
alignment.vert = xlwt.Alignment.VERT_CENTER
style.alignment = alignment
为样式创建字体
font = xlwt.Font()
font.name = u'微软雅黑'
font.color = 'black'
font.height= 220 #字体大小,220(11*20)11号字体
style.font = font
给单元格加框线
border = xlwt.Borders()
border.left = xlwt.Borders.THIN #左
border.top=xlwt.Borders.THIN #上
border.right=xlwt.Borders.THIN #右
border.bottom=xlwt.Borders.THIN #下
border.left_colour = 0x40 #设置框线颜色,黑色
border.right_colour = 0x40
border.top_colour = 0x40
border.bottom_colour = 0x40
style.borders = border
写入excel
sheet.write(row,col,value,style)
book.save('F:\\excel.xls')