What is the difference between MATLAB Builder for Excel and the COM functionality in MATLAB Builder for .NET?

What is the difference between MATLAB Builder for Excel and the COM functionality in MATLAB Builder for .NET?

Answer 1

[MathWorks Support Team]

MATLAB Builder for Excel is a subset of the COM functionality in MATLAB Builder for .NET, optimized for Microsoft Excel. MATLAB Builder for Excel creates wrapper code for you, so you can call your MATLAB functions as Excel macros without writing additional code. MATLAB Builder for .NET COM components are generic. With Builder for .NET, you can create COM components which can be used in any COM-compliant language.

MATLAB Excel Builder components are COM objects accessible only from Microsoft Excel through Visual Basic for Applications. MATLAB Excel Builder creates the Visual Basic wrapper code for you (in the form of the .bas file). This wrapper code (which is actually an Excel macro) reduces the complexity of calling the Builder for Excel generated component in Visual Basic. With Excel Builder, you can use this wrapper macro like any other Excel macro to call your component. To use the Builder for .NET COM component in place of Builder for Excel, you will have to write this wrapper code.

MATLAB Builder for Excel components are also optimized for handling data passed as Excel ranges.