Execute MATLAB® functions using data in Microsoft® Excel® anddisplay 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 dataand 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, executea MATLAB function using the Microsoft Excel ribbon, and importresults into Microsoft Excel. - Create Diagonal Matrix Using Microsoft Excel Context Menu
Export data in a named range of a worksheet, executea 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, executea 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, executea MATLAB function using a Microsoft Excel VBA macro, andimport results into Microsoft Excel. - Return Multiple Output Arguments from MATLAB Function
Calculate the singular value decomposition of a matrixusing 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, organizethe 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 forsix time periods in a Microsoft Excel worksheet. - Map Time and Bond Cash Flows
Determine a set of cash flow amounts and dates givena 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 FunctionWizard. - Find Custom MATLAB Function Using MATLAB Function Wizard
Write a custom MATLAB function and find it usingthe MATLAB Function Wizard.
Related Information
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list:
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)
Contact your local office