excel add-凯发k8网页登录

create microsoft^® excel^® add-ins from matlab^® functions on windows^® systems

matlab compiler™ enables you to package matlab programs into add-ins for use with microsoft excel. excel add-ins allow users to interact with spreadsheet data, display matlab figures, open dialog boxes, and more.

to deploy excel add-ins, you install the add-in and matlab runtime on the target machine. after installation, you can:

invoke add-in functions directly in the form of excel custom functions. for an example, see .
integrate add-in functions into excel macros using the function wizard. macros allow you to specify input and output cells, handle multiple outputs, and set additional run-time options. for an example on using the function wizard, see .
integrate add-in functions into excel macros using custom visual basic^® for applications (vba) code. for vba programming techniques, see .

apps

library compiler

package matlab programs for deployment as shared libraries and components

functions

	create microsoft excel add-in
	options for building excel add-ins
	create an installer for files generated by matlab compiler
	options for creating matlab compiler package installers

topics

requirements and highlights

see tasks you must perform before creating excel add-ins using matlab compiler.
to deploy add-ins, register the add-in and utility libraries, then install the add-in.
overview of how matlab compiler works with excel add-ins.

create and integrate add-ins

create excel add-in from matlab
create an add-in containing a custom function and test it in an excel workbook.
to deploy add-ins, register the add-in and utility libraries, then install the add-in.

use custom functions in excel

create an excel add-in with multiple functions and call your custom functions in excel.

create macros using function wizard

use the function wizard to create a macro using matlab functions with variable-length inputs and outputs.
create macros with graphical functions
create macros that display graphical output and dialog boxes using the function wizard.
install the function wizard add-in and create macros using compiled matlab functions.

create macros using vba

use vba form controls to create a spectral analysis application with a custom user interface.
apply programming techniques for integrating your deployable excel component into a microsoft visual basic application.

manage data exchange

reference the mwcomutil library in your vba programming environment.
learn the process of converting data between matlab and microsoft com variants.
refer to the flags that control data formatting.
refer to the flags that control data conversion.

troubleshooting

view errors you may encounter using matlab compiler, probable causes for these errors, and suggested solutions.
see descriptions for deployment product terms.