topic Re: How to pull multiple sheets from one Excel File in QlikView

How to pull multiple sheets from one Excel File

Thu, 23 Aug 2012 14:31:03 GMT

Hello,

How do you pull in multiple sheets from one excel file when the sheet's are renamed? I know if you have the Sheet's named Sheet1, Sheet 2, etc then you can do something like this. What if you rename the sheets to 2012, 2011, etc? What is the easiest way to import all sheets?

for loop=1 to 5
LOAD

Date,
First,
Last

(ooxml, embedded labels, table is Sheet$(loop));

NEXT;

Re: How to pull multiple sheets from one Excel File

mazacini — Thu, 23 Aug 2012 17:58:16 GMT

What if you named each sheet in your "for" statement:

for each vSheet in '2011','2012'

and then

table is $(vSheet)

Joe

Re: How to pull multiple sheets from one Excel File

Anonymous — Fri, 24 Aug 2012 10:31:08 GMT

Here is an example I uiploaded recently here answering a similar question. Except, there were multiple files with different number of sheets.

Regards,

Michael