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 ?
Joined: Oct 21, 2008
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.
Joined: Mar 22, 2005
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.
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.
Joined: May 08, 2007
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.
Joined: Oct 06, 2008
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 ] Disable smilies. CR[/edit] [ November 17, 2008: Message edited by: Campbell Ritchie ]