Regarding data exchange between excel & Matlab

2013 12 11
1 个回答
回答已采纳
更新时间：2013 12 12
2 次查看（30 天）

0 个投票

Hello, I would like to ask a question regarding data exchange between excel & Matlab. I am using the built-in GA toolbox for optimization of a certain problem. The objective function is inserted in excel as it is exported from a third party program. The variables of the objective function are optimized in GA toolbox then send these variables to the excel to calculate the newer value of the objective function and so on. My question is how can I keep sending the values between matlab & excel automatically. I mean I would like to see the value updated in excel while matlab is running. Also, is it possible to break the loop of GA toolbox to perform some mathematical operations in excel for the objective function. Thanks in advance

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

 采纳的回答

Harsheel
Harsheel 2013-12-12
编辑：Harsheel 2013-12-12

1 个投票

you can try using the Spreadsheet Link EX toolbox. Basically, you can roughly use the following steps:
  1. Send the variables of objective function from Excel to MATLAB using function MLPutMatrix
  2. Call MLEvalString (from Excel) to invoke the MATLAB function file that optimizes these variables
  3. Call MLGetMatrix (from Excel) to read in the resulting variables from MATLAB
In essence, you'd be using MLPutMatrix, MLEvalString and MLGetMatrix.
Example

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 MATLAB Functions in Microsoft Excel 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by