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 Execute 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

Execute 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.

Related Information

How to Execute a Custom MATLAB Function in Excel