Running MATLAB from Excel - Matlab Builder Ex or Matlab Spredsheet link EX?

4 次查看（过去 30 天）
Thomas
Thomas 2011-11-14
评论： Walter Roberson 2016-1-22
I have a number of calculations to be performed by a MATLAB M file and have all my data in an Excel sheet.
The m file is not very complex (around 200-300 lines of code)
The computation needs to be performed from Excel itself. (i.e. we do not want the data to be imported to MATLAB). We need excel to run the computation and then update the same excel files with the output.Have a button in the Excel file that start the computation using MATLAB in the background.
I have read a little about both the MATLAB Builder EX and the Spreadsheet link EX. Which one would be better for the situation described?
Also what are the licensing issues with both?

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

采纳的回答

Sarah Wait Zaranek
Sarah Wait Zaranek 2011-11-14
It basically breaks down to if you want the end user who is running the model within Excel to have MATLAB or not.
Spreadsheet Link EX requires the end user to have MATLAB - moves the data to MATLAB, does the calculation and then brings it back (and any figure you may want) into Excel.
MATLAB Builder EX makes a standalone component that you can use inside of Excel. Note, this does require the end user to have a copy of the MATLAB compiler runtime (MCR)- which is freely distributable if you buy the MATLAB Builder EX. Note the Builder also requires you to have the MATLAB Compiler.
  2 个评论
Thomas
Thomas 2011-11-15
Thanks Sara, we have licenses for the Compiler, builder and Spreadsheet link EX. However I was taken aback to find that MATLAB Builder EX and Spreadsheet link are not supported on the MAC OSX platform where a majority of our development takes place..
I guess I have to develop this one on Windows..
Walter Roberson
Walter Roberson 2016-1-22
Microsoft only supplies the ActiveX interface for their MS Windows version of Excel. (ActiveX is not common outside of MS Windows but it does exist.)

请先登录，再进行评论。

更多回答（1 个）

Chetan Rawal
Chetan Rawal 2016-1-22
Start here for an answer to your MATLAB-Excel integration questions: http://www.mathworks.com/discovery/matlab-excel.html

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by