topic Re: Loading Multiple transformed Excel Sheets in QlikView https://community.qlik.com/t5/QlikView/Loading-Multiple-transformed-Excel-Sheets/m-p/895626#M990836 <HTML><HEAD></HEAD><BODY><P>Perhaps this document helps: <A href="https://community.qlik.com/docs/DOC-7860">Loading Multiple Excel Sheets Dynamically along with file name and sheet name</A>‌</P><P>If not try searching for some discussion about loading multiple sheets from multiple excel files: <A href="/t5/forums/searchpage/tab/message?q=excel sheets multiple">https://community.qlik.com/search.jspa?q=excel+sheets+multiple</A></P></BODY></HTML> Fri, 17 Jul 2015 07:59:22 GMT Gysbert_Wassenaar 2015-07-17T07:59:22Z Loading Multiple transformed Excel Sheets https://community.qlik.com/t5/QlikView/Loading-Multiple-transformed-Excel-Sheets/m-p/895625#M990835 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I have a client who runs his company from monthly excel documents. Each document contains a sheet for each day of the month. Each sheet contains the same layout with data in different locations on each sheet.</P><P>I have managed to transform the data as required although this is a rather time consuming process as there are 30 or 31 sheets per document by 12 documents.</P><P></P><P>Is there a was to apply the same transformation to each sheet and load all sheets within a document.</P><P></P><P>Thank you for any help offered.</P></BODY></HTML> Fri, 17 Jul 2015 07:47:26 GMT https://community.qlik.com/t5/QlikView/Loading-Multiple-transformed-Excel-Sheets/m-p/895625#M990835 2015-07-17T07:47:26Z Re: Loading Multiple transformed Excel Sheets https://community.qlik.com/t5/QlikView/Loading-Multiple-transformed-Excel-Sheets/m-p/895626#M990836 <HTML><HEAD></HEAD><BODY><P>Perhaps this document helps: <A href="https://community.qlik.com/docs/DOC-7860">Loading Multiple Excel Sheets Dynamically along with file name and sheet name</A>‌</P><P>If not try searching for some discussion about loading multiple sheets from multiple excel files: <A href="/t5/forums/searchpage/tab/message?q=excel sheets multiple">https://community.qlik.com/search.jspa?q=excel+sheets+multiple</A></P></BODY></HTML> Fri, 17 Jul 2015 07:59:22 GMT https://community.qlik.com/t5/QlikView/Loading-Multiple-transformed-Excel-Sheets/m-p/895626#M990836 Gysbert_Wassenaar 2015-07-17T07:59:22Z