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.
jlin Answered question October 4, 2018
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.
jlin Answered question October 4, 2018