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

    Load excel data from different sheet

    Mindaugas Bacius

      Hei,

       

      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,    
               @2  
          FROM  
          [$(File)]  
          (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!