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).
Add-ins created with MATLAB Compiler are not compatible with versions of Microsoft Excel that do not share the same bitness:
Add-ins created with 64-bit versions MATLAB Compiler are only compatible with 64-bit versions of Microsoft Excel.
Add-ins created with 32-bit versions MATLAB Compiler are only compatible with 32-bit versions of Microsoft Excel.
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.