topic Re: Import Multiple excel sheets at once in QlikView

Import Multiple excel sheets at once

Wed, 10 Sep 2014 08:51:24 GMT

Hi Friends,

Is this possible to import multiple sheets from an excel file at once? If yes then please share the steps or logic for that.

Regards

Bhawna

jonathandienst — Wed, 10 Sep 2014 09:37:29 GMT

If you mean using a wildcard like *, then no. You need to loop over the sheets. You can use a For loop, like:

For i = 1 To 10

LOAD * From Mysheet.xlsx (ooxml, sheet is Sheet$i));

If the names never change:

For Each vSheet In 'Detail', ''Summary', 'Last Year'

LOAD * From Mysheet.xlsx (ooxml, sheet is $(vSheet));

Or if the names are more complicated, you can use an ODBC connection to get the list of sheet names and loop over this list.

HTH

Jonathan

maxgro — Wed, 10 Sep 2014 09:49:05 GMT

Wed, 10 Sep 2014 09:49:45 GMT

Thanks Jonathan,

with little changes

replace sheet is with Table is and Sheet$i with Sheet$(i)

after making changes the script runs fine and load all the sheet at once.