topic Re: Loading all sheets from an Excel file in App Development https://community.qlik.com/t5/App-Development/Loading-all-sheets-from-an-Excel-file/m-p/1247185#M24930 <HTML><HEAD></HEAD><BODY><P>Are you using Sense?</P></BODY></HTML> Mon, 12 Dec 2016 16:42:53 GMT Clever_Anjos 2016-12-12T16:42:53Z Loading all sheets from an Excel file https://community.qlik.com/t5/App-Development/Loading-all-sheets-from-an-Excel-file/m-p/1247184#M24929 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I need to load every sheet from this excel file. Each sheet is a week of the month, this specific file <STRONG>attached</STRONG> is only the data from October (each month has a specific file with the same layout).</P><P></P><P>I wanna know if there is some way that make the data load process automatic, I mean no need of a lot of script for each week(sheet), also there is the possibility that the sheet names change for a specific month.</P><P></P><P>Using the command SQLtables and a for-loop maybe this can help me, but I did not get a positive result yet.</P><P></P><P>Someone have this solution or a better idea? Or is not possible to do that?</P></BODY></HTML> Mon, 12 Dec 2016 16:37:33 GMT https://community.qlik.com/t5/App-Development/Loading-all-sheets-from-an-Excel-file/m-p/1247184#M24929 caiogil1 2016-12-12T16:37:33Z Re: Loading all sheets from an Excel file https://community.qlik.com/t5/App-Development/Loading-all-sheets-from-an-Excel-file/m-p/1247185#M24930 <HTML><HEAD></HEAD><BODY><P>Are you using Sense?</P></BODY></HTML> Mon, 12 Dec 2016 16:42:53 GMT https://community.qlik.com/t5/App-Development/Loading-all-sheets-from-an-Excel-file/m-p/1247185#M24930 Clever_Anjos 2016-12-12T16:42:53Z Re: Loading all sheets from an Excel file https://community.qlik.com/t5/App-Development/Loading-all-sheets-from-an-Excel-file/m-p/1247186#M24931 <HTML><HEAD></HEAD><BODY><P>Yes, I forgot to mention it. Qlik Sense 3.1 SR2</P></BODY></HTML> Mon, 12 Dec 2016 17:31:08 GMT https://community.qlik.com/t5/App-Development/Loading-all-sheets-from-an-Excel-file/m-p/1247186#M24931 caiogil1 2016-12-12T17:31:08Z