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?
You can create a Java-Function based data service, using a Java Function that exposes the excel spread-sheet. You can use jcom (comes with WLS) to access an excel spread-sheet from Java.
I have some very old examples of such implementations that have worked on various versions of LiquidData and AquaLogic Data Services. I do not have time to port them to ODSI but I can send you what I have if you provide your email address.
you can expose the Excel spreadsheet as an ODBC data source and configure an ODBC-JDBC bridge in between it. Then you can use it as a generic JDBC data source. Otherwise exporting data as CSV from Excel is a more straightforward solution to this situation.