topic Store in Excel in QlikView

Store in Excel

mario-sarkis — Mon, 16 Nov 2015 13:15:44 GMT

Hey ALL,

I there is a way to store a table into an excel file instead of qvd ?

if yes can i write it in the script.

Thank you ,

Re: Store in Excel

Anonymous — Mon, 16 Nov 2015 13:18:39 GMT

Well, you can export the QV object to Excel.

Right Click on any Chart Object - > Export..

Re: Store in Excel

jonathandienst — Mon, 16 Nov 2015 13:19:00 GMT

During the load script, you can export to a CSV file that will open automatically in Excel. There is no direct way to export XLS or XLSX files from the load script.

Re: Store in Excel

Anonymous — Mon, 16 Nov 2015 13:20:34 GMT

On script side, I doubt...

To export into Excel, you can use MAcro as well..

Qlikview to excel export macro

Re: Store in Excel

mario-sarkis — Mon, 16 Nov 2015 13:21:07 GMT

Hi Jonathan Can You GIve an Exemple how i export it to a CSV file ?

Re: Store in Excel

settu_periasamy — Mon, 16 Nov 2015 13:28:09 GMT

this one?

Store Source into Source_new.txt (txt);

Re: Store in Excel

jonathandienst — Mon, 16 Nov 2015 13:29:49 GMT

>>Hi Jonathan Can You GIve an Exemple how i export it to a CSV file?

See settu_periasamy answer above. But change the extension:

Store Source into Source.csv (txt);