Main Content

Excel Add-Ins

Create Microsoft® Excel® add-ins from MATLAB® functions

You can use MATLAB code in Microsoft Excel by creating Excel add-ins. These add-ins can take the form of custom functions or can be integrated with Excel macros using Visual Basic for Applications (VBA).

Topics

Create Add-Ins

Create Excel Add-In

Learn how to create an Excel add-in.

Create Custom Functions

Create Add-In Containing a Custom Function for Use Within Excel

Try an example on how to create an add-in containing a custom function for use within Excel and test it in an Excel workbook.

Create Macros from MATLAB Functions

Creating Excel add-ins from your MATLAB code

Integrate Excel Add-Ins with Excel Macros using VBA

Integrate Components using Visual Basic Application

Useful programming techniques for integrating your deployable COM component into a Microsoft Visual Basic® Application

Build and Integrate Spectral Analysis Functions

This example illustrates the creation of a comprehensive Excel add-in to perform spectral analysis.

Distribute Visual Basic Application

Distribute your COM component, add-in, and VBA application to end-users

Function Wizard

Execute Functions and Create Macros

Workflow to incorporate your COM component into Microsoft Excel using the Function Wizard.

End-to-End Deployment of MATLAB Function

The option to build and package MATLAB code from within the Function Wizard for Excel add-ins will be removed in a future release.

Execute Add-In and Graphical Function

Execute and test your functions, create macros, and more with the Function Wizard

Managing Data Exchange

Reference Utility Classes

Referencing the classes in your programming environment

Data Conversion Rules

Describes the process of converting data between MATLAB and Microsoft COM variants

Array Formatting Flags

Describes the flags that control the formatting of data

Data Conversion Flags

Describes the flags that control the conversion of data

Troubleshooting

Errors and Solutions

This appendix provides a table showing errors you may encounter using MATLAB Compiler™, probable causes for these errors, and suggested solutions.