Loading Multiple Excel Sheets Dynamically

[Rajasekharreddy]

Hi Team,

i have 3 excel files 

data

data1

data2

in each excel file 4 spread sheets 

 note : in manual  load into data   Qlikview  12 qvds

in my  requirement in future multiple sheets getting that's reason i want  load data  into  dynamiclly   

in   3 excel files different filed names 

below attachment's

Thanks ,

Rajasekhar Reddy 

[johnca]

Maybe something like this, and remove the table designation;

Load * from [Data*.xlsx] 

(ooxml, embedded labels);

[krishna_2644]

https://community.qlik.com/t5/New-to-Qlik-Sense/Load-multiple-sheets-from-Excel-Files/td-p/1595476 

[Rajasekharreddy]

its  not  working  already i implement above logic its not working

[Rajasekharreddy]

its  not  working  already i implement above logics its not working

[johnca]

Raj, what does it say in the log file as to why it isn't working?

[Rajasekharreddy]

Hi Johncaqc,

while reload the  data i  getting  sheet  one data only 

i want  load  4 sheets data  and 

note  3 * 4 = 12

in  sheets  data into single Qvd 

[johnca]

This should help you. It requires an ODBC connection in order to read the sheet names.

https://community.qlik.com/t5/QlikView-Documents/Loading-Multiple-Excel-Sheets-Dynamically-along-wit...

[Harvey]

Did you have a fix on this issue? Challenging a relative issue yet no response from anyone and couldn't see this point taking a gander at in google. My Gift Card Site

[Thiago_Justen_]

Hi there,

Hope it helps you:

LIB CONNECT TO  'Excel Files';

Tabelas:
SQLtables;
DISCONNECT;

Abas:
Load
	PurgeChar(TABLE_NAME,'$') As NomeAba
Resident Tabelas 
	Where 
    	Not WildMatch(TABLE_NAME,'*print_area*')
;

Drop Table Tabelas;

For Each vAba in FieldValueList('NomeAba')
	
    Let vAba = PurgeChar('$(vAba)',Chr(39));

    [Tabela_$(vAba)]:
    LOAD
        *
    FROM [lib://Your_DataFolder/Your_File.xlsx]
    (ooxml, embedded labels, table is [$(vAba)]);

    Store [Tabela_$(vAba)] into [Lib://Your_DataFolder/Tabela_$(vAba).qvd](qvd);
    Drop Table [Tabela_$(vAba)];

Next

It is a piece of code from a personal project, so make any edit as well as you need to.

By the way, you'll need to configure an ODBC connection in order to use SQLTables.

Take a look: Excel ODBC drivers 

Regards!