| Excel Link |
  |
What the Functions Do
With Excel Link, Microsoft Excel becomes an easy-to-use data-storage and application-development front end for MATLAB, which is a powerful computational and graphical processor.
Excel Link provides functions to manage the link and to manipulate data. You never have to leave the Excel environment. You can invoke functions as worksheet cell formulas or in macros.
See the Function Reference chapter for details on each function.
Link Management Functions
Excel Link provides four link management functions to initialize, start, and stop Excel Link and MATLAB.
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.
Use MLAutoStart to toggle automatic startup. If you install and configure Excel Link according to the default instructions, Excel Link and MATLAB automatically start every time you start Excel. If you choose manual startup, use matlabinit to initialize Excel Link and start MATLAB.
Use MLClose to stop MATLAB without stopping Excel, and use MLOpen or matlabinit to restart MATLAB in the same Excel session.
Data Management Functions
Excel Link provides seven data management functions to copy data between Excel and MATLAB and to execute MATLAB commands from Excel:
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 (Visual Basic for Applications) 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.
Use MLAppendMatrix, MLPutMatrix, and MLPutVar to copy data from Excel to MATLAB.
Use MLEvalString to execute MATLAB commands from Excel.
Use MLDeleteMatrix to delete a MATLAB variable.
Use MLGetMatrix and MLGetVar to copy data from MATLAB to Excel.
Note:
MLGetMatrix argument syntax differs from the other data management
functions. See the Function Reference chapter for details.
|
| | Installing and Operating Excel Link | | Tips and Reminders | |