2 Replies Latest reply: Aug 24, 2012 6:31 AM by Michael Solomovich RSS

    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
      [C:\Users\_Test.xlsx]
      (
      ooxml, embedded labels, table is Sheet$(loop));

      NEXT;