和德天老师学习用openpyxl快速制作初中学生成绩单--（文件保存03）

成绩单您还犯愁吗？别急快速制作模板来了！

import random
import openpyxl

#建立外部文件
wb = openpyxl.Workbook()
#建立内表
ws = wb.active
#写入数据
head = ["姓名","语文","数学","英语","物理","化学","政治"]
name = ["小明","小红","小伟","小军","小李","小王","小张","小赵","小钱","小孙",]
for i in range(10):
    for j in range(7):
        if i == 0:
            ws.cell(i+1,j+1).value = head[j]
        if j == 1:
            ws.cell(i+2,1).value = name[i]
        ws.cell(i+2,j+1).value = random.randint(70,100)
#保存文件
wb.save("我的成绩单.xlsx")

更多精彩内容，请亲位留言给我哦！