MATLAB Builder EX (for Microsoft Excel)
Description
- Introduction and Key Features
- Building and Packaging Components
- Accessing Excel Add-Ins
- Deploying Excel Add-Ins
Introduction
MATLAB Builder™ EX lets you package MATLAB® programs as Microsoft Excel® add-ins and integrate them into Excel spreadsheets. These add-ins enable you to perform analyses and simulations within Excel that include MATLAB math, graphics, and GUIs developed in MATLAB. The add-ins can be distributed royalty-free to computers that do not have MATLAB installed.
Using MATLAB Compiler™, MATLAB Builder EX encrypts your MATLAB programs and then generates Microsoft® Visual Basic® for Applications (VBA) wrappers around them so that they behave just like other Excel add-ins.
MATLAB Builder EX creates VBA macros that let you pass Excel worksheet values to a deployed MATLAB program without writing or editing VBA code. It lets you prototype in Excel, debug your MATLAB source code, build the add-in, and load and test it in the worksheet.
The VBA wrapper code can be modified in Excel, while the underlying MATLAB application is hidden from the end user. The builder also provides an API for automatic conversion between Excel and MATLAB data types.
The components created by the builder run against the MATLAB Compiler Runtime (MCR), the full set of libraries that supports all features of the MATLAB language and most related toolboxes. The MCR is provided with MATLAB Compiler. To run your add-ins, you must distribute the MCR with them. Add-ins created with MATLAB Builder EX and the MCR can be deployed royalty-free.
Key Features
- Royalty-free distribution of Excel add-ins to computers that do not have MATLAB installed
- Automatic conversion between Excel and MATLAB data types
- One-click VBA macro creation for interacting with a MATLAB application from within Excel
- Ability to prototype in Excel and debug source code in MATLAB
