Export to EXCEL

[German1964]

Why qlikview exports to CSV when the number of rows is very high? And it doesn't export it directly to XLS file?

[Vegar]

Because of Excel limitation, you cannot export above 65 536 rows by 256 columns to Excel xls worksheet. That's why the export is  converted into .CSV format.

[marcus_sommer]

If I remember correctly since any of the newer QV 12 releases the export could be done as xlsx. I'm not quite sure what needs to be done for it but I assume it needs a different configuration in the settings.ini (and there is also a setting to set a limit until it's exported as Excel).

- Marcus

[Vegar]

You're right @marcus_sommer you can change to xlsx.

@German1964 : check out this support article on how to change. QlikView November 2017 Export to XLSX

[Brett_Bleess]

Marcus and Vegar are spot on, but here is a Help link to explain limits:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Send_to_Excel.h...

I think the actual limiter is based upon a setting discussed in the following article:

Export to Excel Article

Hopefully this covers all the bases on your question, but I realized the setting I mentioned is not in the article, so here that is:

RowLimitForCsvInsteadOfXls

The issue here is I am not sure if this applies to xlsx as well or not...  The default value for this setting is 65500.  You can try adding the setting to the Settings.ini file to see what it does, best I have for you.  It needs to be added within the [Settings 7] area of the file...

Regards,
Brett

[German1964 · Accepted solution]

Thank you all.
I solved the export problem to Excel.
It was a list separator setting, it had "semicolon" and I changed it to "comma".