Excel Link    

Function Reference

This chapter provides detailed descriptions of all Excel Link functions. It first groups the functions by task, then alphabetically.

Functions - By Category

Link Management Functions
matlabinit
 Initialize Excel Link and start MATLAB process.
MLAutoStart
 Automatically start MATLAB process.
MLClose
 Terminate MATLAB process.
MLOpen
 Start MATLAB process.

You can invoke any link management function except matlabinit as a worksheet cell formula or in a macro. You invoke matlabinit from the Excel Tools Macro menu or in a macro subroutine.

Data Management Functions
matlabfcn
 Evaluate MATLAB command given Excel data.
matlabsub
 Evaluate MATLAB command given Excel data and designate output location.
MLAppendMatrix
 Create or append MATLAB matrix with data from Excel worksheet.
MLDeleteMatrix
 Delete MATLAB matrix.
MLEvalString
 Evaluate command in MATLAB.
MLGetMatrix
 Write contents of MATLAB matrix in Excel worksheet.
MLGetVar
 Write contents of MATLAB matrix in Excel VBA variable.
MLPutMatrix
 Create or overwrite MATLAB matrix with data from Excel worksheet.
MLPutVar
 Create or overwrite MATLAB matrix with data from Excel VBA variable.

You can invoke any data management function except MLGetVar and MLPutVar as a worksheet cell formula or in a macro. You can invoke MLGetVar and MLPutVar only in a macro.


  Example 5: Bond Cash Flow and Time Mapping Functions - Alphabetical List