0

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

3
Contributors
2
Replies
3
Views
10 Years
Discussion Span
Last Post by iamthwee
0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.