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
Answers
Questions
206 viewsData
0

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
0

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
0

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

Pareto – 80/20 Rule 2 Answers | 0 Votes
Setting a cell to a fixed value 1 Answer | 0 Votes
Sum formula facing SIZE issue 2 Answers | 0 Votes
Model becomes slow 3 Answers | 0 Votes