topic Re: Excel data import from Multiple tabs dynamically in QlikView

Excel data import from Multiple tabs dynamically

Anonymous — Fri, 25 Apr 2014 12:40:34 GMT

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

Re: Excel data import from Multiple tabs dynamically

maxgro — Fri, 25 Apr 2014 12:44:42 GMT

try

with an odbc connection and a loop

how to count no.of sheets in execl file

Re: Excel data import from Multiple tabs dynamically

its_anandrjs — Fri, 25 Apr 2014 12:47:03 GMT

Follow this documents

Load multiple excel files from Multiple excel sheetsinto QV

Re: Excel data import from Multiple tabs dynamically

Anonymous — Fri, 25 Apr 2014 13:55:28 GMT

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

Re: Excel data import from Multiple tabs dynamically

rustyfishbones — Fri, 25 Apr 2014 13:59:20 GMT

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

Regards

Alan

Re: Excel data import from Multiple tabs dynamically

sudeepkm — Fri, 25 Apr 2014 14:01:32 GMT

(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.

Re: Excel data import from Multiple tabs dynamically

its_anandrjs — Fri, 25 Apr 2014 14:03:40 GMT

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