Export data from Excel to database using JAVA

[renu richard]

Hi,

I am a beginner in JAVA world. I want to develop a tool using JAVA which exports the data from Excel sheet to database. Can anyone help me by giving advice on where should i start with? and what all i can use in JAVA to make this tool ?

[Brian Lang]

Do a search for 'Java Excel' in Google or your favorite search engine. You'll find several results to get you started. Choose a database, one that you will likely connect to via JDBC, and off you go.

[Ulf Dittmer]

A library like Apache POI or jExcelApi can help with reading the file. Then you can use JDBC to transfer the data to a DB.

[renu richard]

Hi ULF,
Where can i find Apache POI.jar file. Many Thanks!!
Actually i am trying to read the data from the XML and putting it in spreadsheet. For which i need POI.jar.

[kranthi chamarthi]

Doing a little search in google will take you to this web page Apache Poi where you can find the download link. As per your requirement you should parse the XML document using XML parsers(SAX or DOM) and then using the apache POI api, enter the data into Excel.

[renu richard]

Hi,

I downloaded poi-bin-3.2-FINAL-20081019.zip file and set it in my classpath.

But, then when i run my java program XMLtoExcel.java, i am getting the below error.
Run in Eclipse:

Error occurred during initialization of VM
java/lang/NoClassDefFoundError: java/lang/Object

Compile through command prompt :

javac XMLToExcel.java
Note: XMLToExcel.java uses or overrides a deprecated API.
Note: Recompile with -Xlint eprecation for details.

[ November 17, 2008: Message edited by: renu richard ]
[edit]Disable smilies. CR[/edit]
[ November 17, 2008: Message edited by: Campbell Ritchie ]