What options are available in 2018 to read data from Excel files on Mac? On Windows?
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.
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.
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.