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.
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.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
