Main Content

Excel Add-Ins

Create Microsoft® Excel® add-ins from MATLAB® functions on Windows® systems

MATLAB Compiler™ enables you to package MATLAB programs into add-ins for use with Microsoft Excel. Excel add-ins allow users to interact with spreadsheet data, display MATLAB figures, open dialog boxes, and more.

To deploy Excel add-ins, you install the add-in and MATLAB Runtime on the target machine. After installation, you can:

Apps

Library CompilerPackage MATLAB programs for deployment as shared libraries and components

Functions

compiler.build.excelAddInCreate Microsoft Excel add-in (Since R2021a)
compiler.build.ExcelAddInOptionsOptions for building Excel add-ins (Since R2021a)
compiler.package.installerCreate an installer for files generated by MATLAB Compiler (Since R2020a)
compiler.package.InstallerOptionsOptions for creating MATLAB Compiler package installers (Since R2020a)

Topics

Requirements and Highlights

Create and Integrate Add-Ins

Use Custom Functions in Excel

Create Macros Using Function Wizard

Create Macros Using VBA

Manage Data Exchange

Troubleshooting