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 a Excel file using java programe 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 a Excel file using java programe" Watch "Reading a Excel file using java programe" New topic
Author

Reading a Excel file using java programe

Hemant Khurana
Greenhorn

Joined: Jan 11, 2007
Posts: 27
Hi all
I am trying to read a excel file from a java programe. I am using JdbcOdbcDriver to read from the excel file.
I am using the class in code as

Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

The program complies fine but when i run the programe i get the following error

java.lang.ClassNotFoundException: sun/jdbc/odbc/JdbcOdbcDriver

i have added rt.jar into my class path which contains JdbcOdbcDriver.class file in my class path.
Please help
Keith Lynn
Ranch Hand

Joined: Feb 07, 2005
Posts: 2367
Have you tried POI?
Hemant Khurana
Greenhorn

Joined: Jan 11, 2007
Posts: 27
What is POI? please elaborate.
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14074
    
  16

Search Google for "java excel api" or search the forums. There are a number of libraries available for working with Excel spreadsheets in Java.

POI is Jakarta POI - one of the libraries to work with Microsoft files (Excel, Word etc.).


Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 7 API documentation
Scala Notes - My blog about Scala
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading a Excel file using java programe
 
Similar Threads
Reading excel file inside jar file using jxl api not working !!
Basic authentication & showing EXCEL
about Jcertify6.0 for help!!
jni question
Reading excel file from relative path