topic Re: How to pick data from multiple excel sheet automatically. in QlikView https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65305#M773628 <HTML><HEAD></HEAD><BODY><P>ok, Please get the both QVW and excel data file.</P><P>Please help me out to write the logic.</P></BODY></HTML> Mon, 21 May 2018 15:19:36 GMT lalitkgehlot89 2018-05-21T15:19:36Z How to pick data from multiple excel sheet automatically. https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65301#M773624 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In Attached sample data file I want to pick all the data from all sheet of the excel.</P><P>But my no of sheet is not defined. It could be increased in future. but data format will be the same on all sheet.</P><P>Please let me know how to pic all the data with sheet name as column in data.</P><P></P><P></P><P>Thanks,</P><P>Lalit Kumar</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65301#M773624 lalitkgehlot89 2020-11-25T16:16:04Z Re: How to pick data from multiple excel sheet automatically. https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65302#M773625 <HTML><HEAD></HEAD><BODY><P><A href="https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html" title="https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html">https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html</A></P></BODY></HTML> Mon, 21 May 2018 12:25:08 GMT https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65302#M773625 m_woolf 2018-05-21T12:25:08Z Re: How to pick data from multiple excel sheet automatically. https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65303#M773626 <HTML><HEAD></HEAD><BODY><P>Hi MW,</P><P>It is not working. Please check in attached QVW.</P></BODY></HTML> Mon, 21 May 2018 14:46:43 GMT https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65303#M773626 lalitkgehlot89 2018-05-21T14:46:43Z Re: How to pick data from multiple excel sheet automatically. https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65304#M773627 <HTML><HEAD></HEAD><BODY><P>The qvw won't do any good without the excel workbook to load.</P></BODY></HTML> Mon, 21 May 2018 14:50:59 GMT https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65304#M773627 m_woolf 2018-05-21T14:50:59Z Re: How to pick data from multiple excel sheet automatically. https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65305#M773628 <HTML><HEAD></HEAD><BODY><P>ok, Please get the both QVW and excel data file.</P><P>Please help me out to write the logic.</P></BODY></HTML> Mon, 21 May 2018 15:19:36 GMT https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65305#M773628 lalitkgehlot89 2018-05-21T15:19:36Z Re: How to pick data from multiple excel sheet automatically. https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65306#M773629 <HTML><HEAD></HEAD><BODY><P>This worked for me.</P></BODY></HTML> Tue, 22 May 2018 10:37:54 GMT https://community.qlik.com/t5/QlikView/How-to-pick-data-from-multiple-excel-sheet-automatically/m-p/65306#M773629 m_woolf 2018-05-22T10:37:54Z