Java

Reading Excel File using JAVA

Please support our Java advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Feb 2006

Posts: 18

Reputation: techkar is an unknown quantity at this point

Solved Threads: 1

techkar

Offline

Newbie Poster

Reading Excel File using JAVA

Oct 17th, 2006

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

techkar

•

Join Date: Feb 2006

Posts: 2,460

Reputation: masijade has much to be proud of

Solved Threads: 262

masijade

Online

Nearly a Posting Maven

Re: Reading Excel File using JAVA

Oct 17th, 2006

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

POI

JExcel

JDBC-ODBC Bridge

Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan

•

Join Date: Aug 2005

Posts: 5,273

Reputation: iamthwee is a splendid one to behold

Solved Threads: 378

iamthwee

Offline

Posting Expert

Re: Reading Excel File using JAVA

Oct 17th, 2006

•

Originally Posted by 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

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.

*Voted best profile in the world*