Skip to main content

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Huiying
Partner - Creator III
Partner - Creator III

there is no 1M cell limitation for export to Excel on 2019 June version?

Hi

We tested today, even with mashup, we can download millions of cells with no problem. The real limitation is excel limitation. Strange thing is we randomly get 'access denied' message when downloading.

But in documentation, there is 1m cell limitation. In documentation, it also mentioned that there is warning message if data is over 1m cell. But we have never seen such warning.

Here is the documentation related to 2019June version: https://help.qlik.com/en-US/sense-developer/June2019/apis/EngineAPI/services-GenericObject-ExportDat...

Could you clarify what is the real limitation?

 

Best regards,

Susan

2 Replies
micheledenardi
Specialist II
Specialist II

This is an example of warning message:

2019-10-08 13_59_52-test - My new sheet (1) _ Sheets - Qlik Sense.png

To generate it try to export any table with >1m rows.

The real limitationis on Excel which can handle 1.048.566 rows per sheet.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Huiying
Partner - Creator III
Partner - Creator III
Author

yes, we indeed get the warning message when amount of rows exceed excel limitation. But it seems there is no limitation from QS side. At least, there is no 1M cell limitation, as stated in documentation.