topic . 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/695768#M1085512 <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> Tue, 17 Jun 2014 16:35:08 GMT 2014-06-17T16:35:08Z . 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/695768#M1085512 <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> Tue, 17 Jun 2014 16:35:08 GMT https://community.qlik.com/t5/QlikView/If-an-excel-file-contains-multiple-sheets-with-different-data/m-p/695768#M1085512 2014-06-17T16:35:08Z 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/695769#M1085515 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: courier new;">something like this</SPAN></P><P><SPAN style="font-family: courier new;">where workbook.xls is your file</SPAN></P><P><SPAN style="font-family: courier new;"><BR /></SPAN></P><P><SPAN style="font-family: courier new;">CONNECT TO [Provider=Microsoft.Jet.OLEDB.4.0;Data Source=workbook.<SPAN class="blsp-spelling-error">xls</SPAN>;Extended Properties="Excel 8.0;"];</SPAN></P><P><SPAN style="font-family: courier new;">tables: </SPAN></P><P><SPAN style="font-family: courier new;"><SPAN class="blsp-spelling-error">SQLtables</SPAN>; </SPAN></P><P><SPAN style="font-family: courier new;"><BR /></SPAN></P><P><SPAN style="font-family: courier new;">FOR i = 0 to <SPAN class="blsp-spelling-error">NoOfRows</SPAN>('tables')-1<BR />LET <SPAN class="blsp-spelling-error">sheetName</SPAN> = <SPAN class="blsp-spelling-error">purgeChar</SPAN>(peek('TABLE_NAME', i, 'tables'), <SPAN class="blsp-spelling-error">chr</SPAN>(39));<BR />Sales:<BR />LOAD *<BR />FROM workbook.<SPAN class="blsp-spelling-error">xls</SPAN> (biff, embedded labels, table is [$(<SPAN class="blsp-spelling-error">sheetName</SPAN>)]);<BR />NEXT <BR /></SPAN></P></BODY></HTML> Tue, 17 Jun 2014 16:40:29 GMT https://community.qlik.com/t5/QlikView/If-an-excel-file-contains-multiple-sheets-with-different-data/m-p/695769#M1085515 Clever_Anjos 2014-06-17T16:40:29Z