topic Re: How to pick the data from excel with multiple sheet. in QlikView https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110706#M764082 <HTML><HEAD></HEAD><BODY><P>It can be discreate. </P></BODY></HTML> Fri, 20 Jul 2018 11:01:15 GMT lalitkgehlot89 2018-07-20T11:01:15Z How to pick the data from excel with multiple sheet. https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110702#M764078 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>In current scenario I have three excel file in folder with named Text, Text_2, Text_3. Each file has some Date wise Sheet. </P><P>Files in folder and Sheets in File are not fixed. I want to load the data automatically form these file.</P><P>I tried to right the logic but getting some error. Please help me to right the logic asap.</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208411_Untitled.png" style="height: 270px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110702#M764078 lalitkgehlot89 2020-11-25T16:16:04Z Re: How to pick the data from excel with multiple sheet. https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110703#M764079 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">This will load all the files under the specified folder:</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>for each File in Filepath("C:\Users\Desktop\*.xlsx")</P><P>Table1:</P><P>load</P><P>*</P><P>From "C:\Users\Desktop\*.xlsx"<SPAN style="font-size: 10pt;">;</SPAN></P><P>NEXT File</P></BODY></HTML> Fri, 20 Jul 2018 09:32:49 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110703#M764079 nishanthi_8 2018-07-20T09:32:49Z Re: How to pick the data from excel with multiple sheet. https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110704#M764080 <HTML><HEAD></HEAD><BODY><P>Hi Rajendran,</P><P>I have multiple sheets in each file. And no of sheets are also not fixed.</P><P>In this case it is not working.</P></BODY></HTML> Fri, 20 Jul 2018 09:55:31 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110704#M764080 lalitkgehlot89 2018-07-20T09:55:31Z Re: How to pick the data from excel with multiple sheet. https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110705#M764081 <HTML><HEAD></HEAD><BODY><P>So the date in excel sheets will be on continuous basis or it can be discrete ?</P></BODY></HTML> Fri, 20 Jul 2018 10:09:07 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110705#M764081 nishanthi_8 2018-07-20T10:09:07Z Re: How to pick the data from excel with multiple sheet. https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110706#M764082 <HTML><HEAD></HEAD><BODY><P>It can be discreate. </P></BODY></HTML> Fri, 20 Jul 2018 11:01:15 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110706#M764082 lalitkgehlot89 2018-07-20T11:01:15Z Re: How to pick the data from excel with multiple sheet. https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110707#M764083 <HTML><HEAD></HEAD><BODY><P>Hope the below link will help:</P><P><A href="https://community.qlik.com/thread/61585">Load multiple excel files from Multiple excel sheetsinto QV</A></P></BODY></HTML> Fri, 20 Jul 2018 14:05:10 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-data-from-excel-with-multiple-sheet/m-p/110707#M764083 trdandamudi 2018-07-20T14:05:10Z