File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 13872
    
  10

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
about Jcertify6.0 for help!!
jni question
Reading excel file inside jar file using jxl api not working !!
Reading excel file from relative path
Basic authentication & showing EXCEL