Symptoms
When try to export large xlsx file, throws error Export stopped due to excessive size. Use CSV for a complete export.
Cause
Due to system property "glide.excel.max_cell" limit
Resolution
Excel exports are intended for relatively small exports, fewer than 500,000 cells, while CSV can handle larger exports.
Whenever you export to Excel and the resultant spreadsheet has more than 500,000 cells (by default), the export process stops and you are given the Excel file at that point. In the bottom row, there will be the following message: Export stopped due to excessive size. Use CSV for a complete export:
The Excel export cell threshold is customizable by adding system property "glide.excel.max_cell" property.
Note: Increasing this threshold may cause a memory issue in your instance. The threshold is set at an appropriate level to prevent resource issues.