Discussion Board for collaboration related to QlikView App Development.
i have 3 excel files
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
Maybe something like this, and remove the table designation;
Load * from [Data*.xlsx]
(ooxml, embedded labels);
its not working already i implement above logic its not working
its not working already i implement above logics its not working
Raj, what does it say in the log file as to why it isn't working?
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
This should help you. It requires an ODBC connection in order to read the sheet names.
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
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