Use third party API bundles like jexcelApi. http://jexcelapi.sourceforge.net/. ---create an XML file to define the structure of your excel file like how many columns, column names, corresponding database table/class column/variable name, Create a Java class that can retrieve information from that xml file. You can use XPATH and DOM for the purpose. check http://www.ibm.com/developerworks/library/x-javaxpathapi.html for […]

Read more of this post