The only way to get iter_rows back to the beginning with openpyxl is to reload the file with load_workbook.

What I tried to do

--There is a ʻopenpyxl library that can read and write EXCEL with python --ʻIter_rows method can read EXCEL line by line (similar to DB cursor) --If you add a line with ws.append () and then try to process it again from the beginning, the iterator stays at the end and does not return to the beginning.

Thoughts

--There seems to be no method to return this iterator to the beginning --In the old version, there was an argument like "row_offset", but it does not exist in the latest version 3.0.5. --Source code: https://foss.heptapod.net/openpyxl/openpyxl/-/blob/branch/3.0/openpyxl/worksheet/worksheet.py#L405

Correspondence

--Reload the file with load_workbook

environment

• Python 3.6.9
• openpyxl 3.0.5