1测试例子
#coding=utf-8
import xlwt
# 创建一个workbook 设置编码
workbook = xlwt.Workbook(encoding = 'utf-8')
# 创建一个worksheet
worksheet = workbook.add_sheet('code Worksheet ')
# 写入excel
# 参数对应 行, 列, 值
worksheet.write(0,0, label = '列1 ')
worksheet.write(0,1, label = '列2 ')
worksheet.write(0,2, label = '列3 ')
worksheet.write(1,0, label = 'this is code1')
worksheet.write(1,1, label = 'this is code2')
worksheet.write(1,2, label = 'this is code3')
# 保存
workbook.save('C:\\Users\\Administrator\\Desktop\\2021-06-08\\Excel_test.xls')
2生成文件样式
![](https://img-blog.csdnimg.cn/20210816224430821.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1Y2tzY3poZA==,size_16,color_FFFFFF,t_70)
![](https://img-blog.csdnimg.cn/20210816224405340.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1Y2tzY3poZA==,size_16,color_FFFFFF,t_70)