matlabfcn (Excel Link)

Evaluate MATLAB command given Excel data

Syntax

Worksheet:
matlabfcn(command, inputs)

command
MATLAB command to evaluate. The MATLAB command must be written as "command" (in double quotes) .

inputs
Variable length input argument list passed to MATLAB command. Argument list may contain a range of worksheet cells that contain input data.

Worksheet:	`matlabfcn(command, inputs)`
`command`	MATLAB command to evaluate. The MATLAB command must be written as `"command"` (in double quotes) .
`inputs`	Variable length input argument list passed to MATLAB command. Argument list may contain a range of worksheet cells that contain input data.

Description

Passes the command to MATLAB for evaluation given the function input data. The function returns a single value or string depending upon the MATLAB output. The result is returned to the calling worksheet cell. This function is intended for use as an Excel worksheet function.

Examples

```
matlabfcn("sum", B1:B10) 
```

sums the data in the spreadsheet cells B1 through B10 returning the output to the active worksheet cell or VBA output variable.

```
matlabfcn("plot", B1:B10, "x")
```

plots the data in worksheet cells B1 through B10 using x as the marker type.

See Also

matlabsub

Functions - Alphabetical List matlabinit