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).
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
Creating Excel add-ins from your MATLAB code
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
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
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.