topic Re: excel files with different sheet names in QlikView https://community.qlik.com/t5/QlikView/excel-files-with-different-sheet-names/m-p/1043090#M935508 <HTML><HEAD></HEAD><BODY><P>Check this and see if this helps</P><P></P><P><STRONG>for Each file in 'A' , 'B'</STRONG></P><P></P><P><STRONG>Table$(file):</STRONG></P><P><STRONG>LOAD *</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG>Community_205639.xlsx</STRONG></P><P><STRONG>(ooxml, embedded labels, table is $(file));</STRONG></P><P></P><P><STRONG>NEXT</STRONG></P></BODY></HTML> Tue, 16 Feb 2016 11:04:44 GMT sunny_talwar 2016-02-16T11:04:44Z excel files with different sheet names https://community.qlik.com/t5/QlikView/excel-files-with-different-sheet-names/m-p/1043088#M935506 <HTML><HEAD></HEAD><BODY><P>Hi how to load multiple excel files with different sheet names</P></BODY></HTML> Tue, 16 Feb 2016 10:54:52 GMT https://community.qlik.com/t5/QlikView/excel-files-with-different-sheet-names/m-p/1043088#M935506 nareshthavidishetty 2016-02-16T10:54:52Z Re: excel files with different sheet names https://community.qlik.com/t5/QlikView/excel-files-with-different-sheet-names/m-p/1043089#M935507 <HTML><HEAD></HEAD><BODY><P>check this article:</P><P><A href="https://community.qlik.com/docs/DOC-7860">Loading Multiple Excel Sheets Dynamically along with file name and sheet name</A></P></BODY></HTML> Tue, 16 Feb 2016 10:56:43 GMT https://community.qlik.com/t5/QlikView/excel-files-with-different-sheet-names/m-p/1043089#M935507 avinashelite 2016-02-16T10:56:43Z Re: excel files with different sheet names https://community.qlik.com/t5/QlikView/excel-files-with-different-sheet-names/m-p/1043090#M935508 <HTML><HEAD></HEAD><BODY><P>Check this and see if this helps</P><P></P><P><STRONG>for Each file in 'A' , 'B'</STRONG></P><P></P><P><STRONG>Table$(file):</STRONG></P><P><STRONG>LOAD *</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG>Community_205639.xlsx</STRONG></P><P><STRONG>(ooxml, embedded labels, table is $(file));</STRONG></P><P></P><P><STRONG>NEXT</STRONG></P></BODY></HTML> Tue, 16 Feb 2016 11:04:44 GMT https://community.qlik.com/t5/QlikView/excel-files-with-different-sheet-names/m-p/1043090#M935508 sunny_talwar 2016-02-16T11:04:44Z Re: excel files with different sheet names https://community.qlik.com/t5/QlikView/excel-files-with-different-sheet-names/m-p/1043091#M935509 <HTML><HEAD></HEAD><BODY><P>Hi Avinash i already tried that but wont work</P></BODY></HTML> Tue, 16 Feb 2016 11:07:00 GMT https://community.qlik.com/t5/QlikView/excel-files-with-different-sheet-names/m-p/1043091#M935509 nareshthavidishetty 2016-02-16T11:07:00Z