Running Matlab script from Excel

10 次查看（过去 30 天）
Dhana Raj
Dhana Raj 2011-7-5
I have a Matlab m-file that I would like to execute from Excel. How do I write the Excel VBA code to do so?
I have Spreadsheet Link EX installed and I am able to import and export values between Excel and Matlab, but I can't seem to find an easy way to run my custom m file.

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

采纳的回答

Chirag Gupta
Chirag Gupta 2011-7-5
With the spreadsheet Link EX installed, you should be call your custom MATLAB code using the Add-in.
Click on MATLAB Add-in -> Run custom code -> Enter your function name
For doing so in VBA, refer to
MLEvalString
  1 个评论
Dhana Raj
Dhana Raj 2011-7-5
Thanks. Tried this earlier, but it didn't seem to work. Works now after I fiddled around with the file paths where my script was located.

请先登录，再进行评论。

更多回答（1 个）

Kaustubha Govind
Kaustubha Govind 2011-7-5
  2 个评论
Chirag Gupta
Chirag Gupta 2011-7-5
This will not utilize the already running Spreadsheet link
Dhana Raj
Dhana Raj 2011-7-5
Thanks for the suggestion.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by