MATLAB Compiler™ lets you deploy MATLAB code to Microsoft Excel and large-scale enterprise financial applications written in Microsoft Visual Basic®. These add-ins can take the form of custom functions or can be integrated with Excel macros using Visual Basic for Applications (VBA).
Create an add-in containing a custom function for use within Excel and test it in an Excel workbook.
To integrate add-ins with Excel, register the DLL, install the add-in, and call methods from a spreadsheet.
Create an Excel add-in using MATLAB functions with variable-length inputs and outputs.
Create an Excel add-in containing multiple functions and implement it in Excel.
This example illustrates the creation of a comprehensive Excel add-in to perform spectral analysis.
See programming techniques for integrating your deployable Excel component into a Microsoft Visual Basic application.
Workflow to incorporate your COM component into Microsoft Excel using the Function Wizard.
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 and test your functions, create macros, and more with the Function Wizard
General information about the two major workflows for creating Microsoft Excel add-ins.
Referencing the classes in your programming environment.
Describes the process of converting data between MATLAB and Microsoft COM variants.
Describes the flags that control the formatting of data.
Describes the flags that control the conversion of data.
This appendix provides a table showing errors you may encounter using MATLAB Compiler, probable causes for these errors, and suggested solutions.