Analytics - increase maximum Excel export file size
Excel export from an analysis currently maxes out at 65002 rows, maybe because it's exporting in an early Excel format. Can this be changed to allow the current maximum of 1,048,576 rows?
(I know that .csv export allows more rows.)
Kathleen Cobcroft
shared this idea
Hello,
When exporting to Data files, it is possible to export up to 10,000,000 rows (for example csv, or excel but without any formatting).
When exporting to Formatted files, it is possible to export up to 2,000,000 cells (for example excel with formatting). For example - 490,000 rows with 4 columns.
See -
https://knowledge.exlibrisgroup.com/Alma/Product_Documentation/010Alma_Online_Help_(English)/080Analytics/010Introduction/The_Basics_of_Working_with_Analytics
Best Regards,
Hadas Granot
Analytics product team
-
Stacey van Groll
commented
Hi Kathleen,
This is a defect, rather than an enhancement, per OLH that 1 million rows is supported.
It was meant to be fixed in June per my case:
"June 2022 Analytics SF: 06047995
The number of rows that were possible to export in formatted Excel format was limited. This was expanded to 1,000,000 rows."I reported back to my case after the release that the behaviour remained the same. It was checked and advised that the application found to be incomplete.
The fix is now scheduled again for August.