前言
为使python生成excel文件,需使用xlwt模块来处理
模块使用步骤
导入模块
pip install xlwt
新建工作簿
writeExcelWorkbook = xlrd.workbook(encoding=“utf-8”) # utf-8格式
新建表
writeExcelTable = writeExcelWorkbook.add_sheet(“表名”)
写入表格内容
writeExcelTable.write(行值, 列值, “内容”)
保存工作簿
writeExcelWorkbook.save()
代码示例
import xlwt
wb = xlwt.Workbook(encoding="utf-8")
ws = wb.add_sheet("confirmt")
for j in range(5):
for i in range(5):
if j == 0:
ws.write(i, j, 'l')
if j == 1:
ws.write(i, j, 'o')
if j == 2:
ws.write(i, j, 's')
if j == 3:
ws.write(i, j, 'o')
if j == 4:
ws.write(i, j, 'r')
wb.save('confirm.xls')
结语
参考python官方指导手册: python-excel