File reading significantly slower in openpyxl than in Excel
The original file contains a single sheet with a table containing 330000 lines and 23 columns.
I have attached a version that is scraped from any personal information and trimmed and compressed to fall within the <10mb limit.
The following code takes 66s to run (compared to 7s to open in Excel)
import openpyxl
import timeit
print(
timeit.timeit(
lambda: list(
openpyxl.load_workbook(
"slow-excel-file-trimmed.xlsx", data_only=True, read_only=True
)["Sheet 1"].rows
),
number=1,
),
)