• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Excel Reading

 
arun shivanna
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have table in excel Sheet how to read from this xls file. please reply urgent
 
Joel McNary
Bartender
Posts: 1840
Eclipse IDE Java Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Assuming that you are using Windows (and since you're using Excel...), set up an Excel ODBC pointing to your Excel file and then establish a connection through the JDBC-ODBC Bridge driver.
 
Chris Treglio
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Joel's way is probably easier, but also consider Jakarta's POI project

http://jakarta.apache.org/poi/index.html

With this you can read and write directly to the file, with no ODBC-JDBC.
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic