how to get the current row index with Openpyxl
It's fairly old topic, but I would like to share easy solution for obtaining row number while iterating over rows with ws.iter_rows()
method. I'm taking first object from row tuple which is a cell so it also has information about it's row and column.
for row in ws.iter_rows(min_row=1, max_row=ws.max_rows):
print('Row number:', str(row[0].row))