File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes How to read Excel in Java application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "How to read Excel in Java application " Watch "How to read Excel in Java application " New topic

How to read Excel in Java application

Senthilkumar Adaickalam

Joined: Nov 08, 2004
Posts: 14

I need to read the Excel sheet and send all the data to the database. I had tried with examples from the net but couldnt able to solve it. The Excel Sheet is having around 50+ rows and having 5-10 uneven columns spread over the rows.

For ex, the rows looks like,
Company Name:--------------- Year Established:---------------
Address:--------------------------- Ownership: Public--------
City------------------------------------- State---------------------- Private-------
Country------------------------------- Website----------------- Other-------

The value of Owenership should be either public or private or other.

How do I read this XL and put the data into the database?

Thanks in Advance

Thanks and Regards,<br />Senthil
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
In this case Excel can be assumed as a DB & connect to Excel using JDBc & transfer you records ..
Yon even search goole for stuffs like POI by jakarta..

Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
Fisher Daniel
Ranch Hand

Joined: Sep 14, 2001
Posts: 582
You can get more information about what you want in Jakarta POI

Hope this help
I agree. Here's the link:
subject: How to read Excel in Java application
It's not a secret anymore!