xlwt创建.xls文件

最新推荐文章于 2023-09-22 10:57:50 发布

qiqi_0453

最新推荐文章于 2023-09-22 10:57:50 发布

阅读量507

点赞数

本文链接：https://blog.csdn.net/qiqi_0453/article/details/97259979

版权

# -*- coding: UTF-8 -*-

import xlwt
#打开workbook对象
wbk = xlwt.Workbook(encoding='utf-8')
#新建sheet页,使用cell_overwrite_ok=True同一单元格后写入的值会覆盖前面写入的值
sheet = wbk.add_sheet('sheet1',cell_overwrite_ok=True)

#定义样式
pattern = xlwt.Pattern()
pattern.pattern = xlwt.Pattern.SOLID_PATTERN
pattern.pattern_fore_colour = 5
#1 = White, 2 = Red, 3 = Green, 4 = Blue, 5 = Yellow, 6 = Magenta, 7 = Cyan, 16 = Maroon,
# 17 = Dark Green, 18 = Dark Blue, 19 = Dark Yellow , almost brown), 20 = Dark Magenta, 21 = Teal, 22 = Light Gray, 23 = Dark Gray

#定义字体
font = xlwt.Font()
font.name = 'Times New Roman'
font.bold = True

#初始化一种style
style = xlwt.XFStyle()
style.pattern = pattern
style.font = font

#写入数据
sheet.write(0,0,'姓名',style)
sheet.write(0,1,'年龄',style)
sheet.write(1,0,'夏目先生')
sheet.write(1,1,'23')


#保存文件
wbk.save('test.xls')