Excel JDBC Sample

Description
The Excel File(s) Data Source allows you to take ordinary excel file(s) used in the office and expose them as data sources. This implementation has 4 major advantages over accessing Excel data through an ODBC connection.

• The Excel Spreadsheet does not have to be perfectly tabular starting at the upper left corner of the spreadsheet. Composite utilizes the same Excel files you already use in your enterprise.
• The Metadata can be applied to many Excel files of the same structure. So you can specify several directories of excel files and read them all into one ResultSet/Table. With ODBC each Excel file requires its own DSN.
• This implementation is not restricted to the MSFT Windows platform.
• To add data simply copy a new Excel document that adheres to the meta-data definition in a directory, or edit an existing document."

Download

• exceljdbc1.0.8.zip (1 MB)

Disclaimer
Disclaimer of responsibility: This software is provided as-is; free of charge.