• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading an Excel File using Java

 
Sathish Mandapaka
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Arvind Sampath
Ranch Hand
Posts: 144
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic