topic Re: How to output the file in excel format? in App Development

How to output the file in excel format?

coco — Tue, 19 Oct 2021 05:45:55 GMT

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

Anku — Tue, 19 Oct 2021 06:32:10 GMT

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.