• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading a Excel file using java programe

 
Hemant Khurana
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2409
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you tried POI?
 
Hemant Khurana
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is POI? please elaborate.
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15481
43
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic