| Excel Link |
  |
Tips and Reminders
These tips and reminders help you use Excel Link efficiently.
Excel Link functions perform an action, while Microsoft Excel functions return a value. Keep this distinction in mind as you use Excel Link. Excel operations and function keys may behave differently with Excel Link functions.
Syntax
- Excel Link function names are not case sensitive; that is,
MLPutMatrix and mlputmatrix are the same.
- MATLAB function names and variable names are case sensitive; that is,
BONDS, Bonds, and bonds are three different MATLAB variables. Standard MATLAB function names are always lower case; for example, plot(f).
- Begin worksheet formulas with + or =. For example,
- In worksheet formulas, enclose function arguments in parentheses. In macros, leave a space between the function name and the first argument; do not use parentheses.
- You can directly or indirectly specify a variable-name argument in most Excel Link functions.
- To specify a variable name directly, enclose it in double quotes; for example,
MLDeleteMatrix("Bonds").
- A variable-name argument without quotes is an indirect reference. The function evaluates the contents of the argument to get the variable name. The argument must be a worksheet cell address or range name.
- A data-location argument must be a worksheet cell address or range name. Do not enclose a data-location argument in quotes (except in
MLGetMatrix, which has unique argument conventions).
- A data-location argument can include a worksheet number; for example,
Sheet3!B1:C7 or Sheet2!OUTPUT.
| | What the Functions Do | | Worksheets | |