MLGetMatrix does not return something into xls although flag says "command sucessful"

조회 수: 2 (최근 30일)
I am trying to use MLGetMatrix from the Spreadsheet Link EX toolbox. I can see the out variable in the workspace but it does not return somehing into xls although the test flag is set to 0 indicating that the command succeeded:
Sub testmlxls()
MLEvalString "clear all"
MLShowMatlabErrors "yes"
MLPutMatrix "in", Range("B1")
MLPutMatrix "in2", Range("B2")
MLEvalString ("out = in + in2")
test = MLGetMatrix("out", "test!B3") Cells(3, 2).Address
End Sub
Anyone can help? Thanks

답변 (1개)

Lea
Lea 2012년 6월 20일
If MLGetMatrix is used in a subroutine you have to add MatlabRequest after the MlGetMatrix call.

카테고리

Help CenterFile 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