load_workbook read_only=True impacts number of rows
I can't figure out exactly why this happens, but with some .xlsx files opened with read_only=True, the number of rows returned is 1,048,576
I first encountered the bug using pandas.read_excel() since they have recently switched from xlrd to openpyxl for .xlsx files.
Please find attached an .xlsx file triggering the issue and the associated python code.
Setup:
virtualenv -p python3 venv
source venv/bin/activate
pip install openpyxl
python test.py