Getting Started

    Preface
        What Is MATLAB Excel Builder?
        Suggested Background
        Requirements for MATLAB Excel Builder
            System Requirements
            Compiler Requirements
            Excel Requirements
            Limitations and Restrictions
            Upgrading from a Previous Release

        Related Products
        Typographical Conventions

    Overview
        Building a Deployable Application
            Elements of an Excel Builder Project
            Creating a Project
            Managing M-Files and MEX-Files
            Building a Project
            Testing the Model
            Application Deployment
            Packaging and Distributing the Component

Examples

Graphical User Interface

    Graphical User Interface Menus
        File Menu
        Project Menu
        Build Menu
        Component Menu
        Help Menu

    Project Settings
    Component Information

Programming with Excel Builder Components

    Overview
    When to Use a Formula Function or a Subroutine
    Initializing Excel Builder Libraries with Excel
    Creating an Instance of a Class
        CreateObject Function
        Visual Basic New Operator

    Calling the Methods of a Class Instance
    Processing varargin and varargout Arguments
    Handling Errors During a Method Call
    Modifying Flags
        Array Formatting Flags
        Data Conversion Flags

Usage Examples

    Magic Square Examples
        Creating the Project
        Building the Project
        Adding the Excel Builder COM Function to Excel
        Illustration 1. Output Magic Square Results to Excel
        Illustration 2. Transpose the Output
        Illustration 3. Resize the Output
        Inspecting the Visual Basic Code

    Using Multiple Files and Variable Arguments
        Creating the Project
        Building the Project
        Adding the Excel Builder COM Functions to Excel
        Illustration 4: Calling myplot
        Illustration 5: Calling mysum Four Different Ways
        Illustration 6: myprimes Macro
        Inspecting the Visual Basic Code

    Spectral Analysis Example
        Building the Component
        Integrating the Component with Visual Basic for Applications
        Creating The Visual Basic Form
        Adding The Spectral Analysis Menu Item to Excel
        Saving the Add-in
        Testing The Add-in
        Package the Add-in

Function Wizard

    Introduction
        Installing the Function Wizard Add-in
        Starting the Function Wizard
        Function Viewer
        Component Browser
        Function Properties
        Argument Properties
        Function Utilities

Function Reference

    Functions - Alphabetical List
        componentinfo
        mxltool

Producing a COM Object from MATLAB

    Capabilities
    Calling Conventions
        Producing a COM Class
        IDL Mapping
        Visual Basic Mapping
        MATLAB Compiler Output

Data Conversion

    Data Conversion Rules
        Array Formatting Flags
        Data Conversion Flags

Registration and Versioning

    Component Registration
        Self-Registering Components
        Globally Unique Identifiers

    Versioning
    Obtaining Registry Information

Utility Library

    Utility Library Classes
        Class MWUtil
        Class MWFlags
        Class MWStruct
        Class MWField
        Class MWComplex
        Class MWSparse
        Class MWArg

    Enumerations
        Enum mwArrayFormat
        Enum mwDataType
        Enum mwDateFormat

Troubleshooting

Printable Documentation (PDF)