topic How to create an excel file during a loop and reduce reload? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-an-excel-file-during-a-loop-and-reduce-reload/m-p/457259#M170711 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is it possible to create an excel file during a loop and reduce reload?</P><P></P><P>Could something like the STORE INTO script be used to create an excel files?</P><P></P><P>Thanks,</P><P>Tyler</P></BODY></HTML> Mon, 01 Oct 2012 16:51:51 GMT 2012-10-01T16:51:51Z How to create an excel file during a loop and reduce reload? https://community.qlik.com/t5/QlikView/How-to-create-an-excel-file-during-a-loop-and-reduce-reload/m-p/457259#M170711 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Is it possible to create an excel file during a loop and reduce reload?</P><P></P><P>Could something like the STORE INTO script be used to create an excel files?</P><P></P><P>Thanks,</P><P>Tyler</P></BODY></HTML> Mon, 01 Oct 2012 16:51:51 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-excel-file-during-a-loop-and-reduce-reload/m-p/457259#M170711 2012-10-01T16:51:51Z Re: How to create an excel file during a loop and reduce reload? https://community.qlik.com/t5/QlikView/How-to-create-an-excel-file-during-a-loop-and-reduce-reload/m-p/457260#M170712 <HTML><HEAD></HEAD><BODY><P>Hello Tyler,</P><P></P><P>You can STORE into text format (CSV) if you specify that in the STORE line:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13491106413269056" jivemacro_uid="_13491106413269056"><P>STORE Table INTO Table.txt (txt);</P></PRE><P></P><P>This file may be read on Excel, but QlikView does not support direct export to Excel. Only, QVW and PDF if you have the appropriate license.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 01 Oct 2012 16:57:06 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-excel-file-during-a-loop-and-reduce-reload/m-p/457260#M170712 Miguel_Angel_Baeyens 2012-10-01T16:57:06Z Re: How to create an excel file during a loop and reduce reload? https://community.qlik.com/t5/QlikView/How-to-create-an-excel-file-during-a-loop-and-reduce-reload/m-p/457261#M170713 <HTML><HEAD></HEAD><BODY><P>Thanks Miguel,</P><P></P><P>&nbsp; If I can get '<CODE class="jive-code">STORE Table INTO Table.csv (txt);' to work I beleive excel will recognize it without having to import.</CODE></P><P></P><P>Will update with my script after I test.</P></BODY></HTML> Mon, 01 Oct 2012 17:04:52 GMT https://community.qlik.com/t5/QlikView/How-to-create-an-excel-file-during-a-loop-and-reduce-reload/m-p/457261#M170713 2012-10-01T17:04:52Z