What options are available in 2018 to read data from Excel files on Mac? On Windows?

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
804 viewsData

What vendors/options are there for integrating Excel files as Data Sources to read/push data from Quantrix? The closest JDBC driver solutions I’ve found still seem overkill; certainly the price is considering I only need a client runtime. It seems like Java8 dropped JDBC support for Excel; for Java apps the new way seems to be Apache POI, but Quantrix doesn’t seem to support it.

Answered question

You are correct that Java dropped ODBC support which eliminated our direct to Excel DataLink capability. This is something we are thinking about for our new Data Import feature coming out in the new year. I will be sure to add your vote to that request in our database.

Answered question

Oh, and converting and maintaining the Excel file as a CSV is not an option. I would like the Excel file to preserve formatting, multiple sheets, etc.

Answered question

Latest Questions