How to convert my Matlab code into an Excel add-in?

Question

Ji Li 2018-8-16

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415161-how-to-convert-my-matlab-code-into-an-excel-add-in

评论： Ji Li 2018-8-16

I would like to use Matlab to run a model simulation, all the calculations are done in Matlab, but inputs are from Excel file and the outputs are also returned to this excel file. How can I realize this process?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Paul Shoemaker 2018-8-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/415161-how-to-convert-my-matlab-code-into-an-excel-add-in#answer_333037

Ji Li,

I'm not sure about doing an add-in, but have you considered using the Matlab command "xlsread" to read an Excel spreadsheet, which then feeds your Matlab simulation, and then using the Matlab command "xlswrite" to write results back to an Excel spreadsheet?

The workflow is different than what you described, but may be suitable for your needs.

Paul Shoemaker http://www.matlabinvesting.com

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ji Li 2018-8-16

Thank you! This can be a way to get the result. But I hope to call Matlab commands directly in Excel, all the calculations are done behind the scene. I don’t even need to open Matlab.

请先登录，再进行评论。