topic Re: how to load all execl sheets in QlikView https://community.qlik.com/t5/QlikView/how-to-load-all-execl-sheets/m-p/245487#M707379 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>have a look to this link <A href="http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html">http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html</A></P><P></P><P>it may help</P><P></P><P>Regards</P><P>Gilles</P></BODY></HTML> Tue, 22 Nov 2011 11:21:50 GMT 2011-11-22T11:21:50Z how to load all execl sheets https://community.qlik.com/t5/QlikView/how-to-load-all-execl-sheets/m-p/245484#M707376 <HTML><HEAD></HEAD><BODY><P>hi all</P><P>i have execl 10 execl files..but senario is all execl name is A but sheet name is diffrent</P><P>so how to fetch the all execl file at a time</P><P>thanks &amp;regards </P><P>rohit</P></BODY></HTML> Tue, 22 Nov 2011 06:36:46 GMT https://community.qlik.com/t5/QlikView/how-to-load-all-execl-sheets/m-p/245484#M707376 rohit214 2011-11-22T06:36:46Z how to load all execl sheets https://community.qlik.com/t5/QlikView/how-to-load-all-execl-sheets/m-p/245485#M707377 <HTML><HEAD></HEAD><BODY><P>try something like this</P><P></P><P>load *</P><P>FROM \A*.xls (biff, embedded labels);</P></BODY></HTML> Tue, 22 Nov 2011 06:48:38 GMT https://community.qlik.com/t5/QlikView/how-to-load-all-execl-sheets/m-p/245485#M707377 2011-11-22T06:48:38Z how to load all execl sheets https://community.qlik.com/t5/QlikView/how-to-load-all-execl-sheets/m-p/245486#M707378 <HTML><HEAD></HEAD><BODY><P>hi Prasath,</P><P>that is i know</P><P>but in execl file sheet name is diffrent</P><P>like Sheet1,Sheet11....etc</P><P></P><P>thanks&nbsp; </P><P>rohit</P></BODY></HTML> Tue, 22 Nov 2011 06:51:55 GMT https://community.qlik.com/t5/QlikView/how-to-load-all-execl-sheets/m-p/245486#M707378 rohit214 2011-11-22T06:51:55Z Re: how to load all execl sheets https://community.qlik.com/t5/QlikView/how-to-load-all-execl-sheets/m-p/245487#M707379 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>have a look to this link <A href="http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html">http://qlikviewnotes.blogspot.com/2008/09/loading-multiple-excel-sheets.html</A></P><P></P><P>it may help</P><P></P><P>Regards</P><P>Gilles</P></BODY></HTML> Tue, 22 Nov 2011 11:21:50 GMT https://community.qlik.com/t5/QlikView/how-to-load-all-execl-sheets/m-p/245487#M707379 2011-11-22T11:21:50Z