Exported XLSX files with more than 65536 rows are broken
Hello,
If you try to export to XLSX a report with more than 65536 lines, the resulting file is corrupt, and the true internal format is not XLSX but XLS
Explanation:
Old XLS file had an output limit of 65536 rows, so if you export a RB report to a XLS file, and it has more than 65536 rows, the resulting file can't be open by Excel and is deemed corrupt
So far, fine, although it should better not export more than the max rows and tell you it
So when the new XLSX format was introduced, it removed that limit
But when you export from RB to XlsxReport or XlsxData, and the report has more than 65536 lines, the xlsx file is also corrupt
If you try to export to XLSX a report with more than 65536 lines, the resulting file is corrupt, and the true internal format is not XLSX but XLS
Explanation:
Old XLS file had an output limit of 65536 rows, so if you export a RB report to a XLS file, and it has more than 65536 rows, the resulting file can't be open by Excel and is deemed corrupt
So far, fine, although it should better not export more than the max rows and tell you it
So when the new XLSX format was introduced, it removed that limit
But when you export from RB to XlsxReport or XlsxData, and the report has more than 65536 lines, the xlsx file is also corrupt
Comments
Please generate the report to Archive File (.raf). Send the file to support@ and I will test it.
I tested exporting 80k rows to Xlsx and did not encounter an issues. So perhaps it depends on the report content.
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com