How search data in excel with openpyxl

Question

CODE

import openpyxl
wb = openpyxl.open('the path to the file')

wb.active = 1
ws = wb.active

for row in ws.iter_rows('B4:F4'):
for cell in row:
if cell.value == "Maria":
print(ws.cell(row=cell.row, column=2).value)

Mistake: for row in range(min_row, max_row + 1):

TypeError: 'str' object cannot be interpreted as an integer

Excel table

I need to search "Pavel" and print it in the console

Where is the mistake?

Answer 1

The method iter_rows in the library has changed, refer to this answer:

How we can use iter_rows() in Python openpyxl package?