import xlwt
import xlrd
workbook=xlwt.Workbook(“成绩单”)
sheet=workbook.add_sheet(“01班成绩表”)
headers=[‘姓名’,‘语文’,‘数学’,‘英语’]
student_score=[
(‘李思聪’,56,99,96),
(‘李健林’,98,100,93),
(‘马风’,94,95,95),
(‘张小某’,90,98,92),
(‘陈开歌’,95,91,96),
]
for cols,header in enumerate(headers):
sheet.write(0,cols,header)
for row,scores in enumerate(student_score):
for cols,score in enumerate(scores):
sheet.write(row+1,cols,score)
workbook.save(“成绩表.xls”)