• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Devaka Cooray
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Martijn Verburg
  • Frits Walraven
  • Himai Minh

Microsoft Excel 2007 and Java 8

 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
author & internet detective
Posts: 41407
854
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Avi,
Our AccessingFileFormats page lists some other options.
 
Avi Abrami
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Rancher
Posts: 43028
76
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 22701
129
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
I am going to test your electrical conductivity with this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic