Load all sheets at a time

[Anonymous]

Dear all,

I have a excel sheet ABC.xlsx which contains 5 sheets : Sheet1,Seet2,Sheet3,Sheet4,Sheet5

I want to load all these 5 sheets at a time in qlikview

please tell me how to do it?

Thanks

[its_anandrjs]

Use ODBC for this excel loading.

[Clever_Anjos]

Basically you can´t to it at one time but you can

For i = 1 to 5

load * from excel.xlsx(table is Sheet$(i)

next

[its_anandrjs]

Check this For loop for loading the data from all sheet.

FOR index = 0 to NoOfRows('SheetNames')-1  // Loops for each sheet in the Excel file.

LET sheetName = PurgeChar(PurgeChar(Peek('TABLE_NAME', index, 'SheetNames'), Chr(39)), Chr(36));

TableName:

Load * ,

  FileBaseName()as FIle,

  FileDir() as Dir,

  FileName() as File_Name,

  '$(sheetName)' as Sheet_name

From $(file)(ooxml, embedded labels, table is [$(sheetName)]);

NEXT index

DROP TABLE SheetNames;

NEXT

Check this thread as well:_

Load all Excel files and all sheets in a folder

[MindaugasBacius]

I recommend to study the code in the link as the scenario seems the same:

Load Multiple excel sheets using For loop

[Anonymous]

can you mention the steps for this

[its_anandrjs · Accepted solution]

Check this attached thread please you can do this with out ODBC also. For ODBC connection go to the ODBC connection manager and find out the connector to install the excel ODBC.

Load all Excel files and all sheets in a folder