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

3.82K viewsData
0
0 Comments

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

2 Answers

0
Product Management0 0 Comments

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.

0
jlin349 0 Comments

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
1049 Questions total questions asked
83 Solved total solved questions
2611 Answers total answer posted
12758 Total users total community members