aspose file tools*
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 Java 8 in Action this week in the Java 8 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
Author

How to read Excel in Java application

Senthilkumar Adaickalam
Greenhorn

Joined: Nov 08, 2004
Posts: 14
Hi,

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
Senthil


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
Hi,
You can get more information about what you want in Jakarta POI

Hope this help
daniel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to read Excel in Java application
 
Similar Threads
Reading Data from Excel Sheets
Strange behavior of getrow(n) method of Sheet interface in jxl api
read data from excel sheet and put it into the postgresql database
Generate Excel file
Reading data from Excel Sheets