Issues with using MATLAB with Excel add-in

I am using an Excel add-in for automatically calculating thermo properties from the University of Alabama. As such, I am also using MATLAB to run this associated Excel spreadsheet and am looking to read specific cells and output them in MATLAB. However, for those cell's containing functions related to the Add-in, I am unable to read the cell, receiving an error with 'xlsread'. Any idea what I could do instead?

Answer 1

[Walter Roberson]

Use activeX or .NET to talk to an Excel process and request the values.

A few days ago I found a fairly old post (2012) that said that if you use xlsread() of a .xls file, that the value of formulas should be what you read back. That might possibly only apply to .xls files; as far as I know it does not apply to using readtable() or related routines.

[Harris Ahmad]

Right, that sounds about right. When you say use activeX or .NET, how do you mean?

[Walter Roberson]

https://www.mathworks.com/matlabcentral/answers/94822-are-there-any-examples-that-show-how-to-use-the-activex-automation-interface-to-connect-matlab-to-ex