topic Re: If an excel file contains multiple sheets with different data\table . how to create a qvd for each sheet present in that excel file? in QlikView https://community.qlik.com/t5/QlikView/If-an-excel-file-contains-multiple-sheets-with-different-data/m-p/703139#M1075505 <HTML><HEAD></HEAD><BODY><P>or here for odbc</P><P><A href="https://community.qlik.com/message/165200">how to count no.of sheets in execl file</A></P></BODY></HTML> Sat, 02 Aug 2014 13:35:19 GMT maxgro 2014-08-02T13:35:19Z If an excel file contains multiple sheets with different data\table . how to create a qvd for each sheet present in that excel file? https://community.qlik.com/t5/QlikView/If-an-excel-file-contains-multiple-sheets-with-different-data/m-p/703137#M1075501 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #141823; background: white; font-size: 10.5pt; font-family: 'Helvetica','sans-serif';">If an excel file contains multiple sheets with different data\table . how to create a qvd for each sheet present in that excel file?</SPAN></P></BODY></HTML> Sat, 02 Aug 2014 13:19:59 GMT https://community.qlik.com/t5/QlikView/If-an-excel-file-contains-multiple-sheets-with-different-data/m-p/703137#M1075501 2014-08-02T13:19:59Z Re: If an excel file contains multiple sheets with different data\table . how to create a qvd for each sheet present in that excel file? https://community.qlik.com/t5/QlikView/If-an-excel-file-contains-multiple-sheets-with-different-data/m-p/703138#M1075503 <HTML><HEAD></HEAD><BODY><P>set s='Sheet1','Sheet2','Sheet3';</P><P>for each i in $(s);</P><P>&nbsp; $(i):</P><P>&nbsp;&nbsp;&nbsp;&nbsp; LOAD&nbsp;&nbsp; *</P><P>&nbsp;&nbsp;&nbsp;&nbsp; FROM [Book1.xlsx] (ooxml, embedded labels, Table is [$(i)]);</P><P>&nbsp;&nbsp;&nbsp;&nbsp; store $(i) into $(i).qvd (qvd);</P><P>&nbsp;&nbsp;&nbsp;&nbsp; DROP Table $(i);</P><P>next</P></BODY></HTML> Sat, 02 Aug 2014 13:33:45 GMT https://community.qlik.com/t5/QlikView/If-an-excel-file-contains-multiple-sheets-with-different-data/m-p/703138#M1075503 maxgro 2014-08-02T13:33:45Z Re: If an excel file contains multiple sheets with different data\table . how to create a qvd for each sheet present in that excel file? https://community.qlik.com/t5/QlikView/If-an-excel-file-contains-multiple-sheets-with-different-data/m-p/703139#M1075505 <HTML><HEAD></HEAD><BODY><P>or here for odbc</P><P><A href="https://community.qlik.com/message/165200">how to count no.of sheets in execl file</A></P></BODY></HTML> Sat, 02 Aug 2014 13:35:19 GMT https://community.qlik.com/t5/QlikView/If-an-excel-file-contains-multiple-sheets-with-different-data/m-p/703139#M1075505 maxgro 2014-08-02T13:35:19Z