Tool for importing Excel spreadsheets?

I like JExcelApi very much, it is simple and powerful.

Up vote 1 down vote favorite 1 share g+ share fb share tw.

I need to import some Excel spreadsheets into Java objects. I will use POI to do the task (an old version of it unfortunately). However I wonder if there is some high-level framework to do the same task but declaratively.

I'm thinking in Castor and XML. The mapping Excel-Class will be stored in a resource (e.g. An XML file). Yes, I'm a lazy bones.

But I don't like having lots of hard-coded POI statements when the user decides to change the input format. Thanks java excel apache-poi castor link|improve this question edited May 19 '09 at 14:41Michael Myers?43.2k1198167 asked May 19 '09 at 14:40Lluis Martinez348214 79% accept rate.

It seems equivalent to Apache POI poi.apache.org Actually POI is an architectural constraint, that's why I need something over it. – Lluis Martinez May 19 '09 at 21:42.

There are open source libraries that allow you to treat a spreadsheet like a database and access it via JDBC. Googling for "excel jdbc driver" should help you get started.

There's always the JDBC-ODBC bridge shipped with the JVM import java.lang. *; public class jdbcodbc { public static void main(String args) { // Attempt to load database driver try { // Load Sun's jdbc-odbc driver Class. ForName("sun.jdbc.odbc.

JdbcOdbcDriver").newInstance(); } catch (ClassNotFoundException cnfe) // driver not found { System.err. Println ("Unable to load database driver"); System.err. Println ("Details : " + cnfe); System.

Exit(0); } catch (InstantiationException ex) { System.err. Println ("Unable to load database driver"); System.err. Println ("Details : " + ex); System.

Exit(0); } } } Documentation from Sun website, JDBC-ODBC bridge Example jdbc url potentially usable from Hibernate, for example: jdbc:odbc:mydb;UID=me;PWD=secret.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.