Discussion board where members can get started with Qlik Sense.
Okay so I need to get multiple sheets from one excel file in one load statement. The one that was working and now doesn't is the
(ooxml, embedded labels, table is ' ') and ive tried @1 and @2.
use concatenate statement to append all sheets in the same table using a LOAD statement for each sheet.
LET vStartSheetNumber = 1;
LET vEndSheetNumber = 50;
LET vExcelFileName = 'Data';
FOR index = vStartSheetNumber TO vEndSheetNumber
(ooxml, embedded labels, header is 10 lines, table is [Sheet $(index)]);
of course your sheets should be named as "Sheet 1", "Sheet 2", "Sheet 3" and so on...
i hope this helps.
See this post , this does not require sheet names to be in a specific format
QlikView Addict: Looping Through Excel Sheets
Unfortunately I cannot change the name of my sheets and they are not labeled with numbers