用1个案例，让你快速掌握Python+Excel自动化办公

# -*- coding: utf-8 -*-
# 代码放在公众号里面，也就是视频下方。Excel文件比较简单，大家可以自行创建~
# 导入工具库
import openpyxl

# 把这个excel文件，导入python
workbook = openpyxl.load_workbook('语文分数.xlsx')

sheet1 = workbook['Sheet1']

zs = sheet1['C2'].value  # 63
ls = sheet1['C3'].value  # 78
ww = sheet1['C4'].value  # 98

# sum = zs + ls + ww # 求和
# 注释的快捷键：ctrl+/
sum = sum((zs, ls, ww)) # 求和
avg = (zs + ls + ww) / 3
# 平均分的Python函数，是什么？写在评论区。

sheet1['D4'] = sum
sheet1['E4'] = avg

workbook.save('语文分数.xlsx')