openpyxl - 如何在循环中访问元组的值？

Question

我正在尝试制作一个计算器，该计算器将从 Excel 工作表中读取值并计算给定运算符的答案。我想不出一种方法来编写它，以便它将访问存储在元组中的值，它正在读取单元格值

代码：

def excel_math(filename):

from openpyxl import load_workbook
wb = load_workbook(filename)
ws = wb.active
for row in ws.rows:
    operator = row[0].value
    nums = row[1:]
    if operator == '+':
        subtotal = int(nums[0])
        for numcell in nums[1:]:
            subtotal += int(nums)
        print(subtotal)

标签： openpyxlpython-3.7

Answer 1

def excel_math(filename):

from openpyxl import load_workbook
wb = load_workbook(filename)
ws = wb.active
for row in ws.rows:
    operator = row[0]
    nums = row[1:]
    if operator == '+':
        subtotal = int(nums[0])
        for numcell in nums:
            subtotal += int(numcell)
        print(subtotal)

我认为这应该有效