Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

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

MATLAB Commands in Microsoft Excel

Execute MATLAB® commands for Microsoft® Excel® data and show results in spreadsheets

Functions

matlabfcn Evaluate MATLAB command given Microsoft Excel data
matlabsub Evaluate MATLAB command given Microsoft Excel data and designate output location
MLEvalString Evaluate command in MATLAB
MLShowMatlabErrors Return standard Spreadsheet Link errors or full MATLAB errors using MLEvalString

Topics

Work with MATLAB Functions in Microsoft Excel

Discover the ways to use Spreadsheet Link™ functions in the Microsoft Excel ribbon, worksheet, or macro.

Work with the MATLAB Function Wizard

The MATLAB Function Wizard for the Spreadsheet Link software lets you browse MATLAB folders and run functions from the Excel interface.

Run a MATLAB Function with Multiple Output Arguments

This example shows how to execute a MATLAB function that returns multiple output arguments in Microsoft Excel using a Microsoft Visual Basic® macro.

Model Data Using Regression and Curve Fitting

Builds a mathematical model of a data set and uses a Microsoft Excel worksheet to organize and display the data

Interpolate Data

Uses a Microsoft Excel worksheet to organize and display input data and the interpolated output data

Price Stock Options Using the Binomial Model

Uses the Spreadsheet Link and Financial Toolbox™ software, to price options with the binomial model

Compute Efficient Frontier of Financial Portfolios

Uses the Spreadsheet Link and Financial Toolbox software to analyze three portfolios, using rates of return for six time periods

Map Time and Bond Cash Flows

Uses the Spreadsheet Link and Financial Toolbox software to compute a set of cash flow amounts and dates, given a portfolio of five bonds

Microsoft Excel and MATLAB Interaction

How the Spreadsheet Link, MATLAB, and Microsoft Excel software all work together

Was this topic helpful?