Documents for QlikView related information.
The script below loads the data into qlikview file for multiple sheets in a single load by using the Loop statements.
LET vStartSheetNumber = 1;
LET vEndSheetNumber = 50;
LET vExcelFileName = 'Data';
// Generate Empty table
'' AS Data.Field1,
'' AS Data.Field2
FOR index = vStartSheetNumber TO vEndSheetNumber
(ooxml, embedded labels, header is 10 lines, table is [Page $(index)]);
Note : in my excel file the sheet names are in the patter of Page 1, Page 2, ..... Page n.
Hope this helps others.
This was very useful and it worked for my application as well.
plz share qvw and excel file
I do not have sample excel and Qvw file, put some values in excel file and use the script.
I use a similar approach when loading QVD's saved with MMM-YY suffixes
Works fine, thank you!
thank u jagan mohan
Its very useful!! Thank You
Thanks in advance for your sharing and it works well. I would like to ask a question is that is it possible to load multiple sheets if the sheet names are different. for exp, Sheet1 = 01012015, Sheet2 = 02012015, Sheet3= 03012015. Hope to understand this.
Thanks in advance,
what if my sheet name is COHORT 2011 , following sheet names are COHORT 2012, COHORT 2013 ?
Your pattern is [Page $(index)] - so in my case, i cant just put [COHORT $(index)] - it will give me COHORT 1, COHORT 2 , and continue on.
I have to stick with COHORT 2011 - as per request by client.