Open an Excel add-in from MATLAB

Hello

I am able to use actxserver to open an excel workbook and make it visible. I then put data into excel using xlswrite into cell A1. I want excel to perform calculations using an add-in. The value always shows #NAME. I believe this is because the add-in is not loaded so how can I do this from MATLAB?

I tried

    xlafile = 'theaddinlocationandname.xla'
and I tried
    invoke(Excel.Workbooks,'Open','theaddinlocationandname.xla')

"xlafile= 'theaddinlocationandname.xla'" displays when I do not surpress the output and "Interface.000208DA_0000_0000_C000_000000000046" shows for the invoke one.

When I click on the cell where the value should be, this shows 'addinlocationandname.xla'!functionname("input",A1)

To get the add in to run, I have to go to the "data" tab, "edit links", and hit "open source".

Answer 1

[Sindhu Yerragunta]

Hi Collin,

Hope the following link helps,

https://www.mathworks.com/matlabcentral/answers/92269-why-can-i-not-call-add-in-macros-when-using-excel-as-a-com-automation-server-from-matlab-7-4-r2007a?s_tid=answers_rc1-1_p1_MLT

-Sindhu