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

[Huiying]

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

[micheledenardi]

This is an example of warning message:

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.

[Huiying]

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.