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

4 views (last 30 days)
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

Answers (1)

Lea
Lea on 20 Jun 2012
If MLGetMatrix is used in a subroutine you have to add MatlabRequest after the MlGetMatrix call.

Categories

Find more on Data Export to MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!