Reading Excel File using JAVA

[techkar]

Hi experts,

here in my project ,there is a situation like, to read an Excel file and store in a database using java.
I have an excel file as 10 columns and this is a daily report by our sales team. So the requirement is to read that excel file and store in a database using java.please suggest me an idea.

Thanks

[masijade]

Google the following one at a time and pick the solution you wish to use:

POI

JExcel

JDBC-ODBC Bridge

[iamthwee]

Hi experts,

here in my project ,there is a situation like, to read an Excel file and store in a database using java. I have an excel file as 10 columns and this is a daily report by our sales team. So the requirement is to read that excel file and store in a database using java.please suggest me an idea.

Thanks

As long as you don't have to WRITE anything to excel the easiest thing to do would be to convert your excel file to a comma separated file.

>file>save as > save type > choose .csv

Once you've done that you can use the comma in you file to tell the difference between each column.