MATLAB Excel Builder

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

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


 Preface