User`s guide

5 Function Wizard
5-2
Introduction
The Function Wizard enables you to pass Microsoft Excel (Excel 200 or later)
worksheet values to a compiled MATLAB model and to return model output to
a cell or range of cells in the worksheet. The Function Wizard provides an
intuitive interface to Excel worksheets. Knowledge of Visual Basic for
Applications (VBA) programming is not required.
The Function Wizard reflects any changes that you make in the worksheets,
such as range selections. Going in the opposite direction, you can use the
Function Wizard to control the placement and output of data from MATLAB
functions to the worksheets.
The Function Wizard does not currently support the MATLAB
struct, sparse,
and
complex data types.
Installing the Function Wizard Add-in
The Function Wizard GUI is contained in an Excel add-in (mlfunction.xla)
residing in the
<matlab>\toolbox\matlabxl\matlabxl directory. You must
install this add-in before using the Function Wizard.
Follow these steps to install the add-in:
1 Select Tools->Add-Ins from the Excel main menu.
2 If the Function Wizard was previously installed, a reference to MATLAB
Function Wizard
appears in the list. Uncheck the item and click OK.
If the Function Wizard was not previously installed, click
Browse and
proceed to the
<matlab>\toolbox\matlabxl\matlabxl directory. Select
mlfunction.xla. Click OK on this dialog box and on the preceeding one.
The Function Wizard is also packaged with all deployed components. When a
component is installed onto a separate machine, the Function Wizard is placed
into the top-level directory of the installed component. In this case sse the
instructions above, substituting the installed component’s directory.
Starting the Function Wizard