Export to Excel - limitation in number of rows

[fosuzuki]

Hi all,

In Sense Desktop, I tried to export 2M rows in one single column, and it truncated to exactly 1M rows. When exporting two columns, it dropped to 500k rows. With three columns, 333.333 rows.

Can someone please confirm if it limits the export to 1M cells?

If so, is there any way to increase this limit?

Does Qlik Sense Server also has this limitation?

Regards,

Fernando

[#2]

The ExcelFormat (xlsx) has some limitations see Excel specifications and limits - Excel

Let us know how you do. Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards

Daniel Zanders

QlikSupport

[fosuzuki]

Hi Daniel, thank you for your response.

I'm sorry but I didn't find any useful information in the link you sent. Why didn't Sense export the limit of 1,048,576 in all three cases (with one, two and three columns)?

This is my test script:

load recno() AS Rec,

  'A' AS X,

     'B' AS Y

autogenerate(2000000);

Then, I created a table, added the columns and exported the data.

[fosuzuki]

Bumping up...

[#5]

Hi Fernando, we will check this with our Product Team to get an answer that explains this.

[fosuzuki]

Hi Daniel Zanders!

Any news on this? Sorry the insistence, but this was reported by a prospect, and I'd like to give him a proper answer.

[#7]

We got a Feedback and have to say that the Export Function is not designed for bigger amount of data. In this cases it is better to use the store function in the script or the API Functions.

Let us know how you do. Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards

Daniel Zanders

QlikSupport

[#8]

Will this be the Qlik position going forward into the future. That exporting of data will always be limited to some defined limit. This is something we need to be aware of for our consumer/clients of the Qlik platform continuing forward.

[fosuzuki · Accepted solution]

Thanks Daniel.

I also opened a support case and got a confirmation that the Excel export limitation is to 1M cells, not rows.

My suggestion is to include this information in the documentation and also in the "Finished export" message window. Business users can get confused when exporting as the output is truncated at an apparently random limit.

[scw]

This is no longer true. Please refer to the updated documentation in Qlik help. New limit is the limit imposed by excel-

i.e. 1048566 rows per sheet and 16384 columns per sheet.

Exporting data from a visualization ‒ Qlik Sense