--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.
--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
--Reload the file with load_workbook
Recommended Posts