Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

Store in Excel

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 ,

6 Replies
Anonymous
Not applicable

Well, you can export the QV object to Excel.

Right Click on any Chart Object - > Export..

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable

On script side, I doubt...

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

Qlikview to excel export macro

mario-sarkis
Creator II
Creator II
Author

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

settu_periasamy
Master III
Master III

this one?

Store  Source into Source_new.txt (txt);

jonathandienst
Partner - Champion III
Partner - Champion III

>>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);

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein