python生成excel表格:
1.在编译器中导入操作excel的包 ----> xlwt (操作写入excel) (在虚拟坏境运行 pip install xlwt 或在编译环境搜xlwt安装)
2.运行如下代码:
1:生成一个excel表格:
import xlwt
workbook = xlwt.Workbook(encoding='utf-8')
worksheet = workbook.add_sheet('My Worksheet')
worksheet.write(0, 0, label='this')
worksheet.write(1, 0, label='this is test')
workbook.save('Excel_test.xls')
![在这里插入图片描述](https://img-blog.csdnimg.cn/20191201144636644.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1lhbmdfSGFvXw==,size_16,color_FFFFFF,t_70)
2. 生成一个样式表格:
import xlwt
workbook = xlwt.Workbook(encoding='ascii')
worksheet = workbook.add_sheet('My Worksheet')
style = xlwt.XFStyle()
font = xlwt.Font()
font.bold = True
font.underline = True
font.italic = True
style.font = font
worksheet.write(0, 0, 'Unformatted value')
worksheet.write(1, 0, 'Formatted value', style)
workbook.save('formatting.xls')