Trouble with very large spreadsheet file

[4er4er4er]

The attached script test5.txt, based on a user's example, produces a 123MB file MOD45.xlsx. When I try to open the file, I get this message,

and when I click "yes" I eventually get a message about "unreadable content" in /xl/worksheets/sheet6.xml:

The user reports that "read table" aborted with a related message,

Error writing table Pedidos1 with table handler amplxl:
Could not extract sheet xl/worksheets/sheet5.xml

but I did not see that. Anyhow it appears that the size of the spreadsheet file may be the cause of the problem, because I did not encounter errors with similar but smaller examples.

[nfbvs]

The error message reported by the user does not seem to be related with the issue. This message appears when a given table is mentioned in the relations table but the corresponding sheet does not exist, so the .xlsx file was somehow damaged.

For the spreadsheet dimensions there is no standard, so each vendor has its own implementation. For example:

• MS Excel has a limit of 1,048,576 rows by 16,384 columns;
• LibreOffice Calc has a limit of 1,048,576 rows and 1,024 columns;
• Google Sheets has a limit of 18,278 columns and 5,000,000 cells for the hole workbook. You can add any number of rows as long as the number of cells is not exceeded.

Table Ventas1 generated by test5.txt has 2,016,002 rows, so Excel complains (Excel usually just says something was repaired but does not specify the reason).

As an alternative the user could try the default tab table handler or in the future amplcsv as they are faster than amplxl and could scale enough for what the user needs.