MATLAB® Compiler™ Excel® Add-In User's Guide

Create Excel Add-Ins
	Create Excel Add-In
Getting Started
	How MATLAB Compiler Excel Integration Works
		MATLAB Compiler Excel Add-In Limitations
		Next Steps
	MATLAB Compiler for Microsoft Excel Add-In Prerequisites
		Products, Compilers, and IDE Installation
		Macro Execution Security Levels in Microsoft Excel
		Deployment Target Architectures and Compatibility
		Dependency and Non-Compilable Code Considerations
		Your Role in the Deployment Process
	Choose Function Deployment Workflow
		Is Your Function Ready for Deployment?
		Other Examples
	Create Excel Add-In from MATLAB
		Prerequisites
		Create Function in MATLAB
		Create Excel Add-In Using Library Compiler App
		Package the Application
		Create Excel Add-in Using compiler.build.excelAddIn
		Test the Add-In in Excel
	Distribute Add-Ins and Integrate Into Microsoft Excel
		Integration Process Overview
		Key Tasks for Microsoft Excel End User
		Files To Distribute To End Users
		Add-In and COM Component Registration
		Add-In Installation and Distribution
Customizing a Compiler Project
	Customize an Application
		Customize the Installer
		Determine Data Type of Command-Line Input (For Packaging Standalone Applications Only)
		Manage Required Files in Compiler Project
		Sample Driver File Creation
		Specify Files to Install with Application
		Additional Runtime Settings
	Manage Support Packages
		Using a Compiler App
		Using the Command Line
The Function Wizard
	Execute Functions and Create Macros
		What Can the Function Wizard Do for Me?
		Installation of the Function Wizard
		Function Wizard Start-Up
		Workflow Selection for MATLAB Functions Ready for Deployment
		Defining Functions Ready to Execute
		Function Execution
		Macro Creation
		Macro Execution
		Microsoft Visual Basic Code Access (Optional Advanced Task)
		For More Information
	End-to-End Deployment of MATLAB Function
		What Can the Function Wizard Do for Me?
		Example File Copying
		mymagic Testing
		Installation of the Function Wizard
		Function Wizard Start-Up
		Workflow Selection for Prototyping and Debugging MATLAB Functions
		New MATLAB Function Definition
		MATLAB Function Prototyping and Debugging
		Function Execution from MATLAB
		Microsoft Excel Add-In and Macro Creation Using the Function Wizard
		Function Execution from the Deployed Component
		Macro Execution
		Microsoft Excel Add-In and Macro Packaging using the Function Wizard
		Microsoft Visual Basic Code Access (Optional Advanced Task)
		For More Information
MATLAB Code Deployment
	How Does MATLAB Deploy Functions?
	Dependency Analysis Using MATLAB Compiler
		Function Dependency
		Data File Dependency
		Exclude Files From Package
	MEX-Files, DLLs, or Shared Libraries
	Deployable Archive
		Additional Details
	Write Deployable MATLAB Code
		Packaged Applications Do Not Process MATLAB Files at Run Time
		Do Not Rely on Changing Directory or Path to Control the Execution of MATLAB Files
		Use isdeployed Functions To Execute Deployment-Specific Code Paths
		Gradually Refactor Applications That Depend on Noncompilable Functions
		Do Not Create or Use Nonconstant Static State Variables
		Get Proper Licenses for Toolbox Functionality You Want to Deploy
	Calling Shared Libraries in Deployed Applications
	MATLAB Data Files in Compiled Applications
		Explicitly Including MATLAB Data files Using the %#function Pragma
		Load and Save Functions
Microsoft Excel Add-In Creation, Function Execution, and Deployment
	The Library Compiler and the Command Line Interface
		Using Graphical Interface
		Using Command Line Interface
	Create Macros from MATLAB Functions with Multiple Arguments
		Prerequisites
		Procedure
		Inspect the Microsoft Visual Basic Code (Optional)
	Execute Add-In and Graphical Function
		Execute an Add-In to Validate Nongraphical Function Output
		Execute a Graphical Function
		Create Dialog Box and Error Message Macros
Microsoft Excel Add-In Integration
	Integrate Components Using Visual Basic Application
		When to Use Formula Functions or Subroutines
		Initialize MATLAB Compiler Libraries with Microsoft Excel
		Create an Instance of a Class
		Call the Methods of a Class Instance
		Program with Variable Arguments
		Modify Flags
		Handle Errors During a Method Call
	Build and Integrate Spectral Analysis Functions
		Overview
		Build Excel Add-In
		Implement VBA code
		Test the Add-In
	For More Information
Distribution to End Users
	Assign Multiple MATLAB Functions to Excel Class
		Create Add-In In MATLAB
		Deploy Add-In to Microsoft Excel
	Improve Data Access Using the MATLAB Runtime User Data Interface and COM Components
		Overview
	MATLAB Runtime Component Cache and Deployable Archive Embedding
		Overriding Default Behavior
		For More Information
	MATLAB Runtime Options for Excel Add-Ins
		What MATLAB Runtime Options are Supported by MATLAB Compiler?
		How Do I Specify MATLAB Runtime Options?
	For More Information
Functions
	compiler.build.excelAddIn
	compiler.build.ExcelAddInOptions
	componentinfo
	deploytool
	libraryCompiler
	mcc
Utility Library for Microsoft COM Components
	Reference Utility Classes
	Class MWUtil
		Sub MWInitApplication(pApp As Object)
		Sub MWInitApplicationWithMCROptions(pApp As Object, [mcrOptionList])
		Function IsMCRJVMEnabled() As Boolean
		Function IsMCRInitialized() As Boolean
		Sub MWPack(pVarArg, [Var0], [Var1], ... ,[Var31])
		Sub MWUnpack(VarArg, [nStartAt As Long], [bAutoResize As Boolean = False], [pVar0], [pVar1], ..., [pVar31])
		Sub MWDate2VariantDate(pVar)
	Class MWFlags
		Property ArrayFormatFlags As MWArrayFormatFlags
		Property DataConversionFlags As MWDataConversionFlags
		Sub Clone(ppFlags As MWFlags)
	Class MWStruct
		Sub Initialize([varDims], [varFieldNames])
		Property Item([i0], [i1], ..., [i31]) As MWField
		Property NumberOfFields As Long
		Property NumberOfDims As Long
		Property Dims As Variant
		Property FieldNames As Variant
		Sub Clone(ppStruct As MWStruct)
	Class MWField
		Property Name As String
		Property Value As Variant
		Property MWFlags As MWFlags
		Sub Clone(ppField As MWField)
	Class MWComplex
		Property Real As Variant
		Property Imag As Variant
		Property MWFlags As MWFlags
		Sub Clone(ppComplex As MWComplex)
	Class MWSparse
		Property NumRows As Long
		Property NumColumns As Long
		Property RowIndex As Variant
		Property ColumnIndex As Variant
		Property Array As Variant
		Property MWFlags As MWFlags
		Sub Clone(ppSparse As MWSparse)
	Class MWArg
		Property Value As Variant
		Property MWFlags As MWFlags
		Sub Clone(ppArg As MWArg)
	Enum mwArrayFormat
	Enum mwDataType
	Enum mwDateFormat
Apps
	Library Compiler
Data Conversion
	Data Conversion Rules
	Array Formatting Flags
	Data Conversion Flags
		CoerceNumericToType
		InputDateFormat
		OutputAsDate As Boolean
		DateBias As Long
Troubleshooting
	Errors and Solutions
		Excel Add-Ins Errors and Suggested Solutions
		Required Locations to Develop and Use Components
		Microsoft Excel Errors and Suggested Solutions
		Function Wizard Problems
	Deployment Product Terms