4 Replies Latest reply: Sep 6, 2016 1:41 AM by Gysbert Wassenaar RSS

    Load excel data from different sheet

    Mindaugas Bacius



      I manage to load information from all excel files in folder by using this script:

      SUB DoDir(Root)  
      FOR each File in filelist( Root & '\*.xls')  
          LOAD @1,    
          (biff, no labels, table is Sheet1$);  
      NEXT File  
      FOR each Dir in Dirlist (Root&'\*')  
           CALL DoDir(Dir)  
      NEXT Dir  
      END SUB   
      CALL DoDir('C:\Users\Mindaugasb\Desktop\Orders\2016')  


      Now how should I change the script to load information from different sheets in the files?


      Thank you!