topic Re: Loading Multiple Excel Sheets Dynamically in QlikView

Loading Multiple Excel Sheets Dynamically

Rajasekharreddy — Mon, 24 Jan 2022 15:17:01 GMT

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

Re: Loading Multiple Excel Sheets Dynamically

johnca — Tue, 25 Jan 2022 15:16:02 GMT

Maybe something like this, and remove the table designation;

Load * from [Data*.xlsx]

(ooxml, embedded labels);

Re: Loading Multiple Excel Sheets Dynamically

Qrishna — Wed, 26 Jan 2022 02:57:05 GMT

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

Re: Loading Multiple Excel Sheets Dynamically

Rajasekharreddy — Thu, 27 Jan 2022 06:05:07 GMT

its not working already i implement above logic its not working

Re: Loading Multiple Excel Sheets Dynamically

Rajasekharreddy — Thu, 27 Jan 2022 06:06:24 GMT

its not working already i implement above logics its not working

Re: Loading Multiple Excel Sheets Dynamically

johnca — Thu, 27 Jan 2022 17:41:03 GMT

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

Re: Loading Multiple Excel Sheets Dynamically

Rajasekharreddy — Fri, 28 Jan 2022 13:58:18 GMT

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

Re: Loading Multiple Excel Sheets Dynamically

johnca — Fri, 28 Jan 2022 15:43:37 GMT

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-with-file-name/ta-p/1481095

Re: Loading Multiple Excel Sheets Dynamically

Harvey — Wed, 02 Feb 2022 04:03:58 GMT

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

Re: Loading Multiple Excel Sheets Dynamically

Thiago_Justen_ — Mon, 28 Mar 2022 07:07:16 GMT

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!