Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Microsoft Excel 2007 and Java 8

 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Prior to Java 8 it was possible to perform SQL queries on a Microsoft Excel file using the ODBC driver provided by Microsoft and the JDBC ODBC bridge driver which was part of the JDK.
Since the JDBC ODBC bridge driver is not part of JDK 8, how can I achieve the same functionality?
In other words I want to search for data in an Excel file in a similar way to querying it using SQL.

Thanks,
Avi.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Jeanne.
As far as I can tell, the only relevant link on that page is HXTT.
However a $2651 (USD) Enterprise license price tag is not terrribly inviting.
By the way, I would suggest that someone update that page, especially the link to the JavaWorld article that was written 13 years ago and isn't relevant for Java 8.

Cheers,
Avi.
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I updated the wiki page. As to your question, I suggest you use the Apache POI library instead, which IMO is the best way to handle such files.
 
Rob Spoor
Sheriff
Pie
Posts: 20751
68
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think what Avi wants is to use JDBC to talk to Excel files, and that's not possible with POI. However, it's not hard to implement the querying using POI, you just have to do it yourself.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic