Find and Execute MATLAB Function Using MATLAB Function Wizard - MATLAB & Simulink - MathWorks India

Find and ExecuteMATLABFunction UsingMATLABFunction Wizard

This example shows how to find and execute thetriufunction using the MATLAB^®Function Wizard for Spreadsheet Link™. You can use the Function Wizard to find any MATLAB function.

First, open the MATLAB Function Wizard fromMicrosoft^®Excel^®. From theHometab, select the MATLAB group optionMATLAB Function Wizard. Locate thetriuMATLAB function, choose the function signature, and then execute it.

$MATLAB Function Wizard contains the selected matlab\elmat category, triu function, triu(x) signature, and the triu function help.$

Alternatively, you can execute the function in aMicrosoft Excelworksheet cell by using functionmatlabfcnormatlabsub.

List Folders and Function Categories

All folders or categories in the current search path appear in theSelect a categoryfield of the MATLAB Function Wizard. Click an entry to select it. Each entry in the list appears as a folder path and a description read from theContents.mfile in that folder. If noContents.mfile is found, the category list displays contains this message:

finance\finsupport-(No table of contents file)

Refresh and Select Category

ClickUpdateto refresh the category list. For details about the search path, seepath.

TheSelect a functionfield displays a list of available functions for that category. Click the function name you want to execute. For help with the selected function, view theFunction Helpfield.

Select Function Signature and Enter Formula

TheSelect a function signaturefield displays available signatures for that function. Click a function signature to select it. The Function Arguments dialog box appears.

Function Arguments dialog box shows the selected triu function and its function help. The dialog box contains fields for entering the input and output arguments.

Specify the worksheet cell that contains the input argumentX. By default, the output of the selected function appears in the current worksheet cell using the functionmatlabfcn.