Trouble with very large spreadsheet file about plugins HOT 1 OPEN

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.

from plugins.