思路来源:python-excel循环写入
import xlwt
book = xlwt.Workbook() #创建Excel
sheet = book.add_sheet('sheet1') #创建sheet页
data = [
["1","小花",99,100,98.5],
["2","小王",90,30.5,95],
["3","小明",67.5,49.6,88]
]
title = ['编号','姓名','语文成绩','数学成绩','英语成绩','总分','平均分'] #把表头名称放入list里面
#循环把表头写入
row = 0
for t in title:
sheet.write(0,row,t)
row+=1
row