Why does MATLAB hang after using MLPutVar in Excel Link or Spreadsheet Link EX 3.0 (R2007b) ?

2 次查看（过去 30 天）
MathWorks Support Team
In VBA, I create a variable referencing my Excel Worksheet and I use MLPutVar function to export my data to the MATLAB Workspace.
After that, MATLAB hangs and Excel Link does not work anymore. I need to kill the MATLAB process in the task manager.

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

采纳的回答

MathWorks Support Team
The MLPUTMATRIX function has to be used when creating or overwriting a matrix in the MATLAB workspace with data from a Microsoft Excel worksheet. The values to be copied are specified by their location in the worksheet either using a worksheet cell address or range name
The function MLPUTVAR is used for exporting Microsoft Excel VBA variable only, such as a double created in VBA.

更多回答（0 个）

类别

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

标签

产品


版本

R2007b

Community Treasure Hunt

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

Start Hunting!

Translated by