Main Content

# MATLAB Functions in Microsoft Excel

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

After you have data in a 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

 `matlabfcn` Evaluate MATLAB command given Microsoft Excel data `matlabsub` Evaluate MATLAB command given Microsoft Excel data and designate output location `MLEvalString` Evaluate MATLAB command in MATLAB `MLShowMatlabErrors` Return 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.

## Support Get trial now