Openpyxl 3.0.5 reads in empty rows at end of file
Hi team,
Please find attached xlsx file. When reading this in using Pandas, using following code, please note that this results in a data frame with 267 rows, while the file only has 175 rows (excluding header).
I couldn't quickly figure out how to reproduce this using openpyxl directly, so bear with me for doing this via Pandas.
import pandas # 1.2.0
pandas.set_option("display.max_rows", None, "display.max_columns", None)
df = pandas.read_excel("test.xlsx", sheet_name="Pipeline weights", engine='openpyxl')
print(df)
Wishing you all a happy year-end!