编程生成一个Excel文件,在代码中向Excel找那个填入课程名,学分及分数,计算GPA之后填入Excel
from openpyxl import *
book = Workbook()
sheet = book.active
rows = (
('课程名', '数学', 'Python'),
('分数', 99, 90),
('学分', 4, 2),
('GPA', 0.0)
)
for row in rows:
sheet.append(row)
book.save(&