Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to pull multiple sheets from one Excel File

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;

2 Replies
mazacini
Creator III
Creator III

Hi

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

for each vSheet in '2011','2012'

and then

table is $(vSheet)

Joe

Anonymous
Not applicable
Author

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

Regards,

Michael