Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Use ODBC for this excel loading.
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
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:_
I recommend to study the code in the link as the scenario seems the same:
can you mention the steps for this
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.