first learn pandas: https://pandas.pydata.org/
or
openpyxl: https://openpyxl.readthedocs.io/en/stable/
pandas preferred
the rest will become clear.
Neither:
read the document with Pandas and create report.
Original excel document is not altered.
or
openpyxl: https://openpyxl.readthedocs.io/en/stable/
pandas preferred
the rest will become clear.
Quote:P.S. Side question... would it be computationally easier to 1) go through the excel document line by line and append a txt document with the 'School Name' if the criteria fit... or 2) go through the excel document line by line, deleting rows that don't fit the criteria then at the end convert the column of 'School Name' from entry A2 downwards into a txt file?
Neither:
read the document with Pandas and create report.
Original excel document is not altered.