MATLAB Builder for Excel User’s Guide

MATLAB

Builder for Excel® (also called Excel Builder) is an extension to MATLAB Compiler. You use Excel Builder to package MATLAB functions so that Microsoft Excel users can access them from Excel.

Excel Builder converts MATLAB M-functions to methods of a class that you define. From this class, Excel Builder creates

components. Excel Builder components are COM objects that are accessible from Microsoft Excel through Visual Basic for Applications

(VBA).

COM is an acronym for Component Object Model, which is a Microsoft binary standard for object interoperability. COM components use a common integration architecture that provides a consistent model across multiple applications. All Microsoft Office XP applications support COM add-ins.
Each COM object exposes a

class to the Visual Basic programming environment. The class contains a set of functions called methods. These methods correspond to the original MATLAB functions included in the component’s project. The COM components created by Excel Builder contain one or more classes, and each class provides an interface to the M-functions that you add to the class at build time. The COM component provides a set of methods that wrap the M-code along with a DLL file.