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

Functions Microsoft Excel add-in for building Excel add-ins


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

Create 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

Choosing Function Deployment Workflow

General information about the two major workflows for creating Microsoft Excel add-ins.

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.


Errors and Solutions

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