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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
coco
Contributor II
Contributor II

How to output the file in excel format?

If I want to output the file in CSV format,I will write  

Store  $(vNUM)  into [lib://FIReport_Data/JL_DATA/NP_OUT/$(vNUM).csv](txt);

BUT  If I want to output the file in excel(xlsx) format,how to write  ? Is that right below?

Store  $(vNUM)  into [lib://FIReport_Data/JL_DATA/NP_OUT/$(vNUM).xlsx];

1 Reply
Anku
Creator
Creator

When it comes to in memory tables, the best is to store them in QVD or CSV. Qlik Nprinting may help you to store data into Excel.

There is another way, you can create a table inside QlikSense with the required fields and then export it.