3 Replies Latest reply: Dec 7, 2017 12:16 AM by Arulmozhi Ayyappan RSS

    Dynamically Loading Multiple Excel files and sheet in subfolder

    Arulmozhi Ayyappan

      Hi folks.

       

       

      I have the following requiremnts, Please help me resolve this issue.

       

      We have multiple excel files in different folders, I would like to load all the files and sheets in single load dynamically without the ODBC connection

       

      I m working on the4 below mentioned code:

       

      but the code loads only the path, I would like to retrive the data from it. So that I can use it in multiple application

       

      Set vConcatenate = ;

      FileList:

      LOAD

      '' AS SourceFile

       

       

      AUTOGENERATE 0;

       

       

      sub ScanFolder(Root)

                for each FileExtension in 'xlsx'

                          for each FoundFile in filelist( Root & '\*.' & FileExtension)

                         

                                    LOAD '$(FoundFile)' as SourceFile

       

       

             AUTOGENERATE 1;

                                  

                                    Set vConcatenate = Concatenate;

                                   

                         

                          next FoundFile

                next FileExtension

                for each SubDirectory in dirlist( Root & '\*' )

                          call ScanFolder(SubDirectory)

                next SubDirectory

               

      End Sub

       

       

      CALL ScanFolder ('C:\Funds\Fund_1');