XLSJDBC is a readonly jdbc driver to access xls files from java, just as it where another ordinary SQL database.
To be able to use this library you must obtain two other libraries as well.
The first is the org.relique.jdbc.csv package who contains a parser for SQL statement. Most parts of this project are anyway based on the development of the CVSJDBC driver. You can download this driver package from sourceforge.
http://csvjdbc.sourceforge.net/ is the place to look for.
Second you need a library who can read the XLS files. For this we use the jakarta poi package. We only have tested it with release 2.5 of POI. Available at http://jakarta.apache.org/poi/
The xlsjdbc driver is found here: http://sourceforge.net/project/showfiles.php?group_id=50004
Once you got those packages you can use the driver.
Actually the "only" thing you can do is a select * from xlsfile statement.
There are no other sql statements or options supported, not even a simple where clausle. You see, there is plenty room for improvements.
Retrieving date fields can cause problems, when the date is entered
For Switzerland we use this:
Other XLS JDBC solutions
There exists another opensource project who allows access to XLS files via JDBC.
With xlsql you can use the full select syntax and even have write access to xls files.
But it requires a rather large setup before you can use it.
The project ist hosted at sourceforge.
http://sourceforge.net/projects/xlsjdbc/ is the main project link.
For news you can subscribe to freshmeat
|(C) 2001 - 2004 email@example.com www.aarboard.ch|