This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Java in General 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
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
Rajasekar Elango
Ranch Hand

Joined: Sep 13, 2004
Posts: 105
You could do it using jdbc..



you should create data source for excel driver named readxl before running this program


SCJP 1.4
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41150
    
  45
There are libraries that can read Excel files (Jakarta POI and jExcelAPI), and for sending mail you'd use the JavaMail API.

The ODBC route suggested in the previous post only works on Windows.


Ping & DNS - my free Android networking tools app
Srinivasa Raghavan
Ranch Hand

Joined: Sep 28, 2004
Posts: 1228
No cross post


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

Joined: Oct 11, 2005
Posts: 44
Look at the URL below;

Reading data from Excel documents at runtime
http://www.java-tips.org/content/view/413/29/
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Reading an Excel file using Java
 
Similar Threads
reading from excel files
Inserting data into Mysql from excel files using jdbc
opening excel application in browser
how to write and read excel file
Excel File opening