Write contents of MATLAB matrix to Microsoft Excel worksheet
= MLGetMatrix(var_name,edat)
MLGetMatrix var_name, edat
out = MLGetMatrix(var_name,edat)
= MLGetMatrix(
writes
the contents of MATLAB® matrix var_name
,edat
)var_name
in
the Excel® worksheet, beginning in the upper-left cell specified
by edat
. Use this syntax when working
directly in a worksheet.
MLGetMatrix
writes
the contents of MATLAB matrix var_name
, edat
var_name
in
the Excel worksheet, beginning in the upper-left cell specified
by edat
. Use this syntax in a VBA macro.
lets
you catch errors when executing out
= MLGetMatrix(var_name
,edat
)MLGetMatrix
in
a VBA macro. If MLGetMatrix
fails, then out
is
a string containing error code. Otherwise, out
is 0
.
|
Name of MATLAB matrix to access.
|
|
Worksheet location where the function writes the contents of
|
|
|
If data exists in the specified worksheet cells, it is overwritten.
If the dimensions of the MATLAB matrix are larger than that of the specified cells, the data overflows into additional rows and columns.
edat
must not include the cell
that contains the MLGetMatrix
function. In other
words, be careful not to overwrite the function itself. Also make
sure there is enough room in the worksheet to write the matrix contents.
If there is insufficient room, the function generates a fatal error.
MLGetMatrix
function does not automatically
adjust cell addresses. If edat
is an explicit cell
address, edit it to correct the address when you do either of the
following:
Insert or delete rows or columns.
Move or copy the function to another cell.
If worksheet calculation mode is automatic, MLGetMatrix
executes
when you enter the formula in a cell. If worksheet calculation mode
is manual, enter the MLGetMatrix
function in a
cell, and then press F9 to execute it. However,
pressing F9 in this situation may also execute
other worksheet functions again and generate unpredictable results.
If you use MLGetMatrix
in a macro
subroutine, enter MatlabRequest
on the line after
the MLGetMatrix
. MatlabRequest
initializes
internal Spreadsheet Link™ variables and enables MLGetMatrix
to
function in a subroutine. Do not include MatlabRequest
in
a macro function unless the function is called from a subroutine.
To work with VBA code in Excel with Spreadsheet Link, you must enable Spreadsheet Link as a reference in the Microsoft® Visual Basic® Editor. For details, see Installation.