Open an Excel add-in from MATLAB

2 次查看（过去 30 天）
Collin Poesch
Collin Poesch 2018-6-12
编辑： Sindhu Yerragunta 2018-6-21
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".

请先登录，再回答此问题。

采纳的回答

Sindhu Yerragunta
Sindhu Yerragunta 2018-6-21
编辑：Sindhu Yerragunta 2018-6-21

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2017a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by