Excel data import from Multiple tabs dynamically

[Anonymous]

Hi Team,

Is there a way to import the excel data dynamically from all the tabs?

Each tab may/may not have the same data structure.

Is there a way qlikview identifies each tab as the separate table and creates the tables dynamically.

Kindly help.

Thanks & Regards

Jeba

[maxgro · Accepted solution]

try

with an odbc connection and a loop

how to count no.of sheets in execl file

[its_anandrjs]

Follow this documents

Load multiple excel files from Multiple excel sheetsinto QV

[Anonymous]

Hi Anand,

It seems its almost worked

Could you please help me with the below error.

Bad Zip File

[Sheet3]:

LOAD *

FROM

(ooxml, embedded labels, table is [Sheet3])

Thanks & Regards

Jeba

[rustyfishbones]

You can do this using an ODBC connection to excel. but the sheets must be the same structure

Regards

Alan

[sudeepkm]

(ooxml, embedded labels, table is [Sheet3])

I think ooxml is for xlsx files. Can you please make sure if you have the correct format file.

you can also use filename() as FileName in your load script to identify which files have been loaded.

[its_anandrjs]

Put * before  .xls

Bad Zip File

[Sheet3]:

LOAD *

FROM

  //in this line put *

(ooxml, embedded labels, table is [Sheet3])  \\ Check this line by loading a excel file and then use it

I believe you have to use for loop