This is machine translation

Mouseover text to see original. Click the button below to return to the English version of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materials including this page, select Japan from the country navigator on the bottom of this page.

Translate This Page

MathWorks Machine Translation

The automated translation of this page is provided by a general purpose third party translator tool.

MathWorks does not warrant, and disclaims all liability for, the accuracy, suitability, or fitness for purpose of the translation.

Find and Execute MATLAB Function Using MATLAB Function
Wizard

This example shows how to find and execute
the triu function 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 from Microsoft®
Excel®.
From the Home tab, select the MATLAB group
option MATLAB Function Wizard. Locate the triu MATLAB function,
choose the function signature, and then execute it.

Alternatively, you can execute the function in a Microsoft
Excel worksheet
cell by using Spreadsheet
Link function matlabfcn or matlabsub.

List Folders and Function Categories

All folders or categories in the current search path appear
in the Select a category field 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 the Contents.m file
in that folder. If no Contents.m file is found,
the category list displays contains this message:

finance\finsupport -(No
table of contents file)

Refresh and Select Category

Click Update to refresh the category
list. For details about the search path, see path.

The Select a function field displays
a list of available functions for that category. Click the function
name you want to execute. For help with the selected function, view
the Function Help field.

Select Function Signature and Enter Formula

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

Specify the worksheet cell that contains the input argument X.
By default, the output of the selected function appears in the current
worksheet cell using the Spreadsheet
Link function matlabfcn.