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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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.