topic Re: Load all the sheets from an excel file in QlikView

Load all the sheets from an excel file

0li5a3a — Wed, 25 Nov 2020 16:16:04 GMT

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 !

Re: Load all the sheets from an excel file

marcus_sommer — Tue, 23 Jan 2018 13:59:59 GMT

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

- Marcus

Re: Load all the sheets from an excel file

vinieme12 — Tue, 23 Jan 2018 14:00:40 GMT

Use OLEDB to get Excel sheet names

Re: Looping through Excel Sheets and Columns

Re: Load all the sheets from an excel file

0li5a3a — Tue, 23 Jan 2018 14:10:39 GMT

Hi ,

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

regards,

Re: Load all the sheets from an excel file

0li5a3a — Tue, 23 Jan 2018 14:20:46 GMT

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?

Re: Load all the sheets from an excel file

marcus_sommer — Tue, 23 Jan 2018 14:22:45 GMT

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

Re: Load all the sheets from an excel file

marcus_sommer — Tue, 23 Jan 2018 14:25:25 GMT

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

- Marcus