练习题:(按行求和)我需要按行来汇总求和,代码如下:
import openpyxl wb=openpyxl.load_workbook('我的工作簿.xlsx') ws=wb.worksheets[0] # for r in [row for row in ws.rows][1:]: # l = [v.value for v in r] # print([l[0], sum(l[1:])]) for row in list(ws.rows)[1:]: l=[v.value for v in row] print([l[0],sum(l[1:])])
运行结果只有最后一行的数据:
['A1032', 467]
疑问:我希望是每一行都有数据汇总显示的,还没找到原因。欢迎来交流。