I ran into the problem that I wanted to load multiple sheets form 1 workbook in just 1 load statement.
I found some scripts saying you should connect to the Excel file using the ODBC connect line, but there is another way.
This one is a bit more work, but it is easier to understand I think.
What you need to do:
First, load the file into Qlikview, to see how Qlikview sees the sheet names (mostlikely there is a dollar sign behind the name)
1) In the file you want to load , create a table with field name 'SheetNames'
2) Type every sheet name you want to load from the file, adding '$' to the end of each sheetname
3) Rename the sheet of the file to 'Index'
4) Save it.
5)Use the code below
TRACE INDEXING SHEETS;
autonumber(SheetNames) as RowNo
(biff, embedded labels, table is Index$);
max(RowNo) as maxload
TRACE SETTING LOAD VARIABLES TO DEFAULT;
TRACE LOADING SPECIFIED SHEETS;
DO WHILE var_tabload<var_indexload
(biff, embedded labels, table is [$(var_tabindex)], filters(
Remove(Row, RowCnd(CellValue, 1, StrCnd(null)))
TRACE STORING LOOP DATA INTO QVD;
STORE Loop_Temp into TempLoad.qvd (qvd);
This one worked for me, I hope you enjoy the code!