aspose 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
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: 14338
    
  22

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 8 API documentation
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading a Excel file using java programe