Supported Compilation Targets

Microsoft Excel Add-In

Using Excel® add-in and the Deployment Tool (deploytool or mcc), you create deployable add-ins and Excel functions from MATLAB code that runs in Microsoft® Excel applications. The Deployment Tool and mcc support the following function outputs:

  • No outputs

  • Figure (graphical) output

  • Scalar output

Using the MATLAB® Compiler™ Function Wizard, you create Excel macros that can be deployed as add-ins or workbooks.

MATLAB Compiler supports multidimensional matrix output(s).

Migration Considerations for 32-bit and 64-bit Microsoft Excel

Add-ins created with MATLAB Compiler are compatible with both 32–bit and 64–bit versions of Microsoft Excel. MATLAB Compiler itself is in 64–bit only.

What Are Excel Add-In Components and When Should You Create Them?

MATLAB Compiler generates two primary artifacts from your MATLAB code, using the Deployment Tool: a Microsoft Excel add-in and a COM component.

Existing MATLAB functions can be integrated into new or existing spreadsheet solutions, as add-ins, with the Function Wizard. You can also use the Function Wizard to create and test add-ins for new MATLAB functions.

COM components created with either the Deployment Tool or the Function Wizard (.bas files) can be integrated into existing Microsoft Visual Basic® applications.

MATLAB Compiler Components are ideal solutions for deploying MATLAB code to users of Microsoft Excel and large-scale enterprise financial applications written in Microsoft Visual Basic.

MATLAB Compiler Limitations

MATLAB objects are not supported as inputs or outputs for compiled or deployed functions with MATLAB Compiler for Excel add-ins.

Was this topic helpful?