topic Re: Export to EXCEL in QlikView

Export to EXCEL

German1964 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Export to EXCEL

Vegar — Tue, 08 Oct 2019 04:10:51 GMT

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.

Re: Export to EXCEL

marcus_sommer — Tue, 08 Oct 2019 12:52:20 GMT

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

Re: Export to EXCEL

Vegar — Tue, 08 Oct 2019 13:20:57 GMT

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

Re: Export to EXCEL

Brett_Bleess — Mon, 14 Oct 2019 15:04:10 GMT

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.htm

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

Re: Export to EXCEL

German1964 — Mon, 14 Oct 2019 15:13:05 GMT

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".