python - 设置电子表格列值时出现 TypeError

Question

for product_row in worksheet.iter_rows(min_row=2,
                                       max_row=worksheet.max_row,
                                       min_col=1,
                                       max_col=5, values_only=True):
    test_write = worksheet.cell(product_row,5)
    test_write.value = 5

给我这个错误：

Traceback (most recent call last):
  File "C:\pythonProject\main.py", line 62, in <module>
    test_write = worksheet.cell(product_row,5)
  File "C:\pythonProject\venv\lib\site-packages\openpyxl\worksheet\worksheet.py", line 237, in cell
    if row < 1 or column < 1:
TypeError: '<' not supported between instances of 'tuple' and 'int'

但是当我有这个时：

for product_row in range(2, worksheet.max_row+1):
    test_write = worksheet.cell(product_row,5)
    test_write.value = 5

我没有收到任何错误。我究竟做错了什么？

标签： python