Solution : https://service.sap.com/sap/support/notes/1429136 (SAP Service marketplace login required)
Summary :
SAP Note highlights the limitation of XXL_FULL_API which only supports exporting up to 65536 rows to Excel, despite Excel 2007 and newer versions supporting up to 1048576 rows. The discrepancy is addressed by updating the XXL Export to accommodate the higher row limit in newer Excel versions, while maintaining the column limit at 256. Installation of Excel 2007 or higher is required to utilize the extended row export capability. Note applies only to newer Excel versions; for Excel 2003 and earlier, refer to Lotus 1-2-3 note 700206. Implementation of correction instruction is necessary to enable these capabilities.
Key words :
solution apply relevant correction instruction, higher releases supports 1048576 rows, higher version supports 10, higher version supports 16, xxl export upto 10, higher version, xxl export, lower releases, xxl_full_api supports, prerequisites previously
Related Notes :
700206 | XXL: MAX Size Limit for Excel Export for Table and Pivot |