4 Replies Latest reply: Jan 10, 2012 11:48 AM by Mikereiche-Oracle RSS

    Reading Excel file that contains multiple tabs

    RA
      Hi,

      In the ODSI workshop, I am trying to create a data service using Excel files as data source. First of all, there is no such option. Converting Excel files to .CSV could be an option. But my Excel files has multiple tabs and only the active sheet gets converted to .csv. Please give me inputs on the following:

      - Is there a way to used Excel files directly?
      - if not, then, how to get .CSV from .XLS with information from all the tabs?

      Thanks.