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 ?
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 ]