This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes Programmer Certification (SCJP/OCPJP) and the fly likes Reading an Excel File using Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Certification » Programmer Certification (SCJP/OCPJP)
Bookmark "Reading an Excel File using Java" Watch "Reading an Excel File using Java" New topic
Author

Reading an Excel File using Java

Sathish Mandapaka
Greenhorn

Joined: Dec 15, 2005
Posts: 7
Hi people,
I wanted to know if there is any way to read data from an Excel spread sheet by using Java code and doing some function such as sending a mail depending upon the data which is read from the file.
I wish to write an application but am stuck up at how to start it up.PLease do help me in this issue.

Thanks and Regards,
Sathish Mandapaka
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
I'm not sure whether an excel sheet can be read from java code using POI API , Google for POI or check it out in apache site.

The other way is to use JDBC, consider the excel sheet as a back end and you can read it by jdbc code
[ December 15, 2005: Message edited by: Srinivasa Raghavan ]

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

Joined: May 11, 2005
Posts: 144
Excel sheets can be read using the POI utility. You can download the necessary documentation and the jar file from here
[ December 15, 2005: Message edited by: Arvind Sampath ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading an Excel File using Java
 
Similar Threads
opening excel application in browser
Inserting data into Mysql from excel files using jdbc
reading from excel files
Excel File opening
how to write and read excel file