Import Multiple excel sheets at once

[#1]

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 · Accepted solution]

Hi

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));

     Next

If the names never change:

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

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

     Next

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]

Loading Dynamically Multiple Excel Sheets

Loading from multiple Excel files and multiple sheets

[#4]

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.