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 Functions in Microsoft Excel

Execute MATLAB® functions using data in Microsoft® Excel® and display results in spreadsheets

After you have data in an Microsoft Excel spreadsheet, you can execute MATLAB functions using various methods. For example, you can use the Microsoft Excel ribbon, context menu, worksheet cells, or VBA macros. To find MATLAB functions in a visual way, use the MATLAB Function Wizard. For differences among these methods, see Executing Spreadsheet Link Functions.

Functions

matlabfcnEvaluate MATLAB command given Microsoft Excel data
matlabsubEvaluate MATLAB command given Microsoft Excel data and designate output location
MLEvalStringEvaluate MATLAB command in MATLAB
MLShowMatlabErrorsReturn standard Spreadsheet Link errors or full MATLAB errors

Topics

Execute MATLAB Functions in Microsoft Excel

Executing Spreadsheet Link Functions

Learn about different Spreadsheet Link™ function types, execution methods, and how to specify arguments to execute MATLAB functions.

Create Diagonal Matrix Using Microsoft Excel Ribbon

Export data in a named range of a worksheet, execute a MATLAB function using the Microsoft Excel ribbon, and import results into Microsoft Excel.

Create Diagonal Matrix Using Microsoft Excel Context Menu

Export data in a named range of a worksheet, execute a MATLAB function using the Microsoft Excel context menu, and import results into Microsoft Excel.

Create Diagonal Matrix Using Worksheet Cells

Export data in a named range of a worksheet, execute a MATLAB function using Microsoft Excel worksheet cells, and import results into Microsoft Excel.

Create Diagonal Matrix Using VBA Macro

Export data in a named range of a worksheet, execute a MATLAB function using a Microsoft Excel VBA macro, and import results into Microsoft Excel.

Return Multiple Output Arguments from MATLAB Function

Calculate the singular value decomposition of a matrix using a Microsoft Excel VBA macro.

Execute MATLAB Functions Using Real Data

Model Data Using Regression and Curve Fitting

Build a mathematical model of a data set, organize the data, and display it using a Microsoft Excel worksheet.

Interpolate Thermodynamic Data

Interpolate, organize, and display data using a Microsoft Excel worksheet.

Price Stock Options Using Binomial Model

Price options and build a binomial tree in a Microsoft Excel worksheet.

Plot Efficient Frontier of Financial Portfolios

Analyze three portfolios using rates of return for six time periods in a Microsoft Excel worksheet.

Map Time and Bond Cash Flows

Determine a set of cash flow amounts and dates given a portfolio of five bonds in a Microsoft Excel worksheet.

Execute MATLAB Functions Using MATLAB Function Wizard

Find and Execute MATLAB Function Using MATLAB Function Wizard

Find a MATLAB function, select a function signature, specify arguments, and execute the function using the MATLAB Function Wizard.

Find Custom MATLAB Function Using MATLAB Function Wizard

Write a custom MATLAB function and find it using the MATLAB Function Wizard.

Was this topic helpful?