wood burning stoves
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
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: http://aspose.com/file-tools
subject: How to read Excel in Java application
It's not a secret anymore!