Load all the sheets from an excel file

[0li5a3a]

Hi All,

I have the attached excel which contains more sheets, in future I want to add more sheets and load them to qlikview.

All the sheets got the same column (Id, Address, Customer Id) but the sheets names are differit ( ASDADADSA, BASDADBSA, EDEHDABD,ETC..)

I want to import all the sheets authomaticale, it is this possible in QV?

Thanks in advance !

[marcus_sommer]

Take a look on this: Loading Multiple Excel Sheets Dynamically along with file name and sheet name

- Marcus

[vinieme12 · Accepted solution]

Use OLEDB to get Excel sheet names

Re: Looping through Excel Sheets and Columns

[0li5a3a]

Hi ,

Thanks for replay, I tried this example  but  is not any way to load the files without the ODBC connection?

regards,

c

[0li5a3a]

I have this error when I try to load the files, and is related to the ODBC. is there any settings which I need to do?

[marcus_sommer]

As far as you know all sheetnames or at least could fetch them (including all possible sheetnames and skipping all not exists sheets with an error-handling) you could use a loop through a list or a field. Otherwise you will need the ODBC approach or further external logics like reading and storing all sheets through an excel-macro

- Marcus

[marcus_sommer]

Is an excel-odbc-driver installed? I think this will be a good starting point for it: The Great ODBC Confusion.

- Marcus