Openpyxl iter_rows(min_row,max_row) with loop

Question

为什么iter_rows总是说must be str, not int？我只是想把我的lst值传递给min_row和max_row。

from openpyxl import load_workbook
from itertools import islice
wb = load_workbook('xyz.xlsx')
ws1 = wb['Sheet1']
lst = ['2','2']
limit = 2
for i in islice(lst,limit):
    row = ws1.iter_rows(min_row=i,max_row=i)

我尝试过在这里找到的想法来iter_rows min_row max_row但是，我只是得到同样的错误和Worksheet object has no attribute

引用错误是

 line 509, in iter_rows
 max_row += row_offset

Answer 1

iter_rows 方法要求输入参数min_row和max_row是整数。所以试试这个：

from openpyxl import load_workbook
from itertools import islice
wb = load_workbook('xyz.xlsx')
ws1 = wb['Sheet1']
lst = [2,2]
limit = 2
for i in islice(lst,limit):
    row = ws1.iter_rows(min_row=i,max_row=i)

注意：您可以通过使用命令 help(ws1.iter_rows) 或 help(openpyxl.worksheet.worksheet.Worksheet.iter_rows) 查询其文档字符串来获取 iter_rows 方法的完整使用说明。在文档字符串中，您可以找到以下说明：

:param min_row: smallest row index (1-based index)
:type min_row: int
:param max_row: smallest row index (1-based index)
:type max_row: int