11 Replies Latest reply: Jan 5, 2015 6:38 AM by Jesus Pita Merino RSS

    Load data from multiple sheets of excel file(dynamic sheet count)

    chinna katiki

      Dear Gurus,

       

      Here is my requirement.

       

      We get a excel file generated from  BW source. Data populates in multiple sheets with the same structure(same columns in all sheets).

      But Number of sheets will get varied every day.

       

      So I have to identify the number of sheets and load all the sheets data using for loop.

       

      Is there any other way apart from ODBC  connection?

       

      Thanks for your help in advance.

       

      BR,

      Chinna.