17 Replies Latest reply: May 11, 2016 6:49 PM by Andreas Köhler RSS

    Loading Multiple Excel Files and Multiple Excel sheets

      Hi All,

       

      I need help in loading Multiple Excel Files and Multiple Excel sheets.

       

      I am developing an application on my local machine . I have a folder on my local machine(Not on server).

      I have few excel files with different names. Each Excel file has different sheets(Each sheet name represents each table name) and with different names(No pattern).

       

      Now I need to load all these excel files.

      Can any one help me with proper code?

       

      Please don't provide any links.. I have tried few codes but not working so please provide the code which can satisfy my requirement.

       

      Appreciate for your response.