This content has been marked as final. Show 4 replies
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.
Please send the code samples to email@example.com
Thanks a lot.
Edited by: mikereiche on Jan 10, 2012 9:47 AM
I've sent it.