Default limitations in number of rows and columns
The default maximum number of rows and columns in the Excel export file is:
- 1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.
- 16384 columns per sheet. If the number of columns exceeds the limit, the exported file is truncated and a warning message is sent.
These limitations are documented in the Qlik Engine API documentation for your specific version of Qlik Sense.
Example: ExportData method
Note however that the user may end up with errors like the following ones without passing the above limits. This could occur due to the default file size limit described in API ExportData method page, which is 1024*1024*800 for export to an Excel file (If the exported file is larger than the maximum value, then an out-of-memory error with code 13000 is returned):
- Your exported data is ready for download. Please note that your dataset was too large and has been truncated.
- You have reached the size limitation of the export process. Please reduce the number of values to export or change the settings.
It's not so much that the XLSX file has a limitation of 1024*1024*800 bytes (always important to put units on numbers). It's that an XLSX file consists of many different text files in a .zip file. Each individual (text/xml) file in there has a limitation of 1024*1024*800 bytes. For example, every sheet has an individual file, if they get over the limit the error happens. But the data in a Sheet is compressed by referencing commonly occurring cells in another file so it's not possible to calculate this size by just looking at data in the current sheet. From the user's point of view, the 1024*1024*800 number is likely meaningless; usually, a part of the XLSX file was too large during export (likely the contents of a sheet).
Review the documentation for the Qlik Sense version in use to determine the documented excel export limitations. If you get a warning or an error about limitations, make selections to limit the data you want to export and then export again.
