Throw warning upon reaching Excel row limit
Closed this issue · 0 comments
MaxAlex commented
If you make an Excel file containing more than 1048576 rows and then open it in Excel, Excel will show a warning about "corrupted data" and "fix" the file, namely by only showing the first 1048576 rows. Information in later rows is hidden, and if the user saves the "fixed" version, that information is lost. Currently, openpyxl writes these not-technically-compatible large files silently; I think issuing a warning would help prevent confusion. Thanks!
("Why are you making these monstrously large spreadsheets?" you ask; I confess I don't have a really good answer, but I'm probably not the only one.)