https://community.qlik.com/t5/QlikView/Load-files-with-multiple-worksheets-based-on-time/m-p/1739378#M721225 <P>Hello everyone,&nbsp;</P><P>I have Excel files that contain several worksheet(Zone south, Zone north,...) and files names are in the format of REAL_1007 (10 August).&nbsp;<BR /><BR /></P><P>How can I load them please ?&nbsp;<BR />thank you</P> Wed, 25 Nov 2020 16:16:04 GMT KaisGarci 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Load-files-with-multiple-worksheets-based-on-time/m-p/1739378#M721225 <P>Hello everyone,&nbsp;</P><P>I have Excel files that contain several worksheet(Zone south, Zone north,...) and files names are in the format of REAL_1007 (10 August).&nbsp;<BR /><BR /></P><P>How can I load them please ?&nbsp;<BR />thank you</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Load-files-with-multiple-worksheets-based-on-time/m-p/1739378#M721225 KaisGarci 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Load-files-with-multiple-worksheets-based-on-time/m-p/1739796#M721226 <P><SPAN>Hi Kais,</SPAN></P><P><SPAN>As per my understand you need to use For each loop in your script. Below links will help you to understand more.</SPAN></P><P><SPAN>"Loading data from multiple xls-files from folder with sub-folders"</SPAN></P><P><SPAN><A href="https://community.qlik.com/t5/QlikView-Documents/Loading-data-from-multiple-xls-files-from-folder-with-subfolder/ta-p/1481859" target="_blank">https://community.qlik.com/t5/QlikView-Documents/Loading-data-from-multiple-xls-files-from-folder-with-subfolder/ta-p/1481859</A></SPAN></P><P>&nbsp;</P><P><SPAN><A href="https://community.qlik.com/t5/New-to-QlikView/Create-Filename-list-table-from-folders-and-subfolders/m-p/837026" target="_blank">https://community.qlik.com/t5/New-to-QlikView/Create-Filename-list-table-from-folders-and-subfolders/m-p/837026</A></SPAN></P><P><SPAN><A href="https://community.qlik.com/t5/QlikView-App-Development/loop-through-to-load-all-files-from-a-folder-and-its-subfolders/td-p/439773" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/loop-through-to-load-all-files-from-a-folder-and-its-subfolders/td-p/439773</A></SPAN></P><P>&nbsp;</P> Mon, 31 Aug 2020 09:37:04 GMT https://community.qlik.com/t5/QlikView/Load-files-with-multiple-worksheets-based-on-time/m-p/1739796#M721226 ramasaisaksoft 2020-08-31T09:37:04Z https://community.qlik.com/t5/QlikView/Load-files-with-multiple-worksheets-based-on-time/m-p/1742453#M721227 <P>Here is a Design Blog post along the same lines:</P><P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543</A></P><P>Regards,<BR />Brett</P> Wed, 09 Sep 2020 14:22:40 GMT https://community.qlik.com/t5/QlikView/Load-files-with-multiple-worksheets-based-on-time/m-p/1742453#M721227 Brett_Bleess 2020-09-09T14:22:40Z