Openpyxl 学习笔记 数据分析并在最后一列添加数据

import openpyxl
inputxlsx = input('输入文件名，带后缀')
wb = openpyxl.load_workbook(inputxlsx)
ws = wb.active
#定位数据区
rngs = ws.iter_rows(min_row=2,min_col=2)
for row in rngs:
    sm = sum([c.value for c in row][:-1])
    if sm>=300:
        #最后一列添加数据
        row[-1].value = '优秀'
wb.save(inputxlsx)