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



      '' AS SourceFile






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