Why do I receive a "Run-time error '9': Subscript out of range" error when passing a matrix to MATLAB using Excel Link?

Question

MathWorks Support Team 2009-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/102767-why-do-i-receive-a-run-time-error-9-subscript-out-of-range-error-when-passing-a-matrix-to-matla

I created a matrix in VBA and attempted to pass it into MATLAB in the following way:

 Sub MatlabTest()
 matlabinit
 Dim TestArray(2, 2) As Double
 TestArray(0, 1) = 1
 TestArray(0, 0) = 1
 TestArray(1, 0) = 1
 TestArray(1, 1) = 1
 mlputvar "MLTestArray", TestArray
 End Sub

However, this caused the following error:

 Run-time error '9':
 Subscript out of range

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

Answer 1

MathWorks Support Team 2009-6-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/102767-why-do-i-receive-a-run-time-error-9-subscript-out-of-range-error-when-passing-a-matrix-to-matla#answer_112112

VBA variables must be 1-indexed in order to be successfully passed to MATLAB via Excel Link. For example:

 Dim mldata(1 To 2, 1 To 2) As Double
 mldata(1, 1) = 2
 mldata(1, 2) = 5
 mldata(2, 1) = 6
 mldata(2, 2) = 9
 'Put variable into MATLAB
 MLPutVar "y", mldata