Search
Code Directory
 ASP
 ASP.NET
 C/C++
 CFML
 CGI/PERL
 Delphi
 Development
 Flash
 HTML
 Java
 JavaScript
 Pascal
 PHP
 Python
 SQL
 Tools
 Visual Basic & VB.NET
 XML
New Code
HTMLPad 2018 15.5
WeBuilder 2018 15.5
SentiMask SDK Trial 2.0.0
Track Order For Magento 2 1.0.0
Calendar 365 For Dynamics CRM 4.0
Scimbo 1.2
Odoo Furnito Theme 1.0
.Net Assemblies/WSDL Import Utility for Delphi 6.0.4.0
Devart Excel Add-in for Zendesk 1.7
Excel Add-in for Marketo 1.7
GetOrgChart 2.5.3
AnyGantt JS Gantt Charts 8.6.0
AnyChart JS Charts and Dashboards 8.6.0
Multi Vendor Ecommerce Script & Apps 4.0
Magento 2 Inventory Management Extension 1.0
Top Code
MCU 8051 IDE 1.4.7
Guest Book V. 2 V2
XML Products Showcase Slider 1.0
Azizi search engine script PHP 4.1.10
jQuery Slider Ken Burns 1.0
Flash T-Shirt Designer 3.0
Myanmar Unicode Conversion Help 1.0
ActivePerl 5.8.4.810/5.6.1.638
Calendar 365 For Dynamics CRM 4.0
Image Reconstruction Demo (GUI) 1.0
Porter Stemming Algorithm 1.I
STDF file reader 1.0
The Karma Language 1.0
Email Grabber
jQuery Accordion Photo Gallery 1.0
Top Rated
VisualNEO Web 2018.12.15
Paste phpSoftPro 1.4.1
Extreme Injector 3.7
Deals and Discounts Website Script 1.0.2
ADO.NET Provider for ExactTarget 1.0
Solid File System OS edition 5.1
Classified Ad Lister 1.0
Aglowsoft SQL Query Tools 8.2
Invoice Manager by PHPJabbers 3.0
ICPennyBid Penny Auction Script 4.0
PHP Review Script 1.0
ATN Resume Finder 2.0
ATN Site Builder 3.0
Availability Booking Calendar PHP 1.0
PHP GZ Blog Script 1.1
MATLAB-Excel Single Interface 1.0
File ID: 82018






MATLAB-Excel Single Interface 1.0
Download MATLAB-Excel Single Interface 1.0http://www.heavyscripts.com/item.php?item=89Report Error Link
License: Freeware
File Size: 30.7 KB
Downloads: 10
Submit Rating:
MATLAB-Excel Single Interface 1.0 Description
Description: MATLAB-Excel Single Interface (MESI)

(Thanks to Russell Goyder, the original creator of this example.)

WHAT IS IT?
===========

MESI provides the VBA subroutine "RunInMATLAB", which allows you to call your M-code from Excel using Excel Link and .NET/COM Builder without changing your VBA code.

WHY DOES IT EXIST?
==================

A typical usage scenario for the above tools is the following. A developer is building an Excel worksheet that performs calculations in MATLAB, and during development, Excel Link is used. The developer has an installation of MATLAB and Excel Link provides an easy way to manage the interaction between the tools, stepping back and forth between the VBA and MATLAB debuggers, for example.

But the eventual goal is to deploy the worksheet, compiling the M-files into a COM dll using .NET Builder (formerly COM Builder). The way in which M-files are called from VBA using these two products is different, so different interface code must be written. MESI is an attempt to place this interface code in a single place, minimizing the changes needed on the VBA side as the application evolves.

WHAT IS IN IT?
==============

The package consists of three parts:

1. MATLABInfrastructure.bas
This is the VBA interface code. You must drag this into your VBA project.

2. matlabgateway.m
This is an M-file called by subroutines in the MATLABInfrastructure code.

3. filelist.m
This file is only used when compiling your M-files. It is not strictly necessary, but provides a way of avoiding the need to add each M-file in your .NET Builder project.

USAGE
=====

Use the demo worksheet, M-files and .NET Builder project as a guide.

STEP 0 - Install Excel Link (see the product documentation for details).

STEP 1 - In Excel, hit Alt-F11 to open the Visual Basic Editor and drag MATLABInfrastructure.bas into it.

STEP 2 - Define a named range consisting of a single cell called "UseExcelLink" and enter TRUE into that cell

STEP 3 - Add, say, a button to your worksheet (View -> Toolbars -> Control Toolbox) and in its callback function (double click on it in design mode) insert a call to your M-code using RunInMATLAB, called as follows:

Call RunInMATLAB( "commandName" ) runs the M-file "commandName" in MATLAB. No input or output arguments are used.

Call RunInMATLAB( "commandName", Array("inputRange1", "inputRange2") ) performs the same call, but this time the data in the named ranges inputRange1 and inputRange2 are used as inputs.

Call RunInMATLAB( "commandName", Array("inputRange1", "inputRange2"), _
Array("outputRange1", "outputRange2") ) allows the M-file to return output arguments to Excel. The names ranges outputRange1 and outputRange2 must cover only a single cell and specify the top-left of the range into which the
output matrix is inserted.

-----------------------------------------------------------------------
| You should now be up and running with Excel Link. To deploy, read on. |
-----------------------------------------------------------------------

STEP 4 - Change the value in the UseExcelLink cell to FALSE.

STEP 5 - Build your COM dll (see the .NET Builder documentation for details). You need only add two M-files to the project - matlabgateway.m and filelist.m. filelist.m must contain a list of the M-files in your codebase.

STEP 6 - add two further configuration parameters to your worksheet - set up the single-cell named ranges "COMComponentName" and "COMClassName" and type in the corresponding strings that you chose in your .NET Builder project.

-----------------------------------------------------------------------
| You should now be able to call your deployed code. |
-----------------------------------------------------------------------

LIMITATIONS
===========

1. I am a VBA novice - the quality of the code is probably very poor and does not contain very much exception handling at all.

2. Only one COM class is allowed.

3. The interface is limited to the description above in STEP 3.

4. If you have output arguments but no input arguments, you need to supply dummy input arguments

License: Freeware

Related: followscall, quotcommandnamequot, Input, output, runinmatlab, Insert, Double, Click, Design, arguments, usedcall, inputscall, arrayquotoutputrange quot, quotoutputrange quot, return, inputrange, arrayquotinputrange quot, quotinputrange quot, ranges

O/S:BSD, Linux, Solaris, Mac OS X

File Size: 30.7 KB

Downloads: 10



More Similar Code

This is a video demonstration tutorial
to be as an introduction to use MATLAB Excel Builder.

The attached file contains three m-file programs and
video file to show you how to make these programs active
into excel by using MATLAB excel builder.



This is a demo of MATLAB Excel Builder. This demo explains how one can compile MATLAB code into an Excel based COM component using MATLAB Excel Builder. This demo compiles a MATLAB code that depicts Univariate Interpolation into an Excel based COM...



This is a demo for MATLAB Excel Builder. This demo explains how one can compile MATLAB code into an Excel based COM component using MATLAB Excel Builder and use the same in Excel VBA. This demo compiles a MATLAB code that does basic matrix...



This is a MATLAB Excel Builder demo. This demo shows how you can compile a MATLAB code into an Excel based COM component and use the same in an Excel Visal Basic environment. The example used in this demo is the simulation of a bouncing ball using...



These 2 files fix the MATLAB Web Services interface in R14SP2 to allow communication with the Anritsu Siganture High Performance Signal Analyzer. Instructions for use are included in the archive.



QuIRK is an interactive Matlab command line interface for constructing systems of rigid bodies and joint constraints, solving the equations of motion of those systems when subject to various force expressions, displaying and animating solved...



SQQ & STOCKQUOTEQUERY pull stock prices for a given ticker symbol
from the YAHOO web server using the MATLAB Java URL interface.

STOCKQUOTEQUERY has the main code. SQQ calls STOCKQUOTEQUERY and allows for either interactive...



This graphical tool displays an editable binary representation of the two floating point formats used in MATLAB, namely single and double.

For the selected number three displays are available:
* The value as formated by the MATLAB...



The functions in this toolbox create SigmaPlot graphs from within MATLAB using MATLAB's ActiveX interface. These can be used to replace the PLOT, BAR, POLAR and SURF functions.

The toolbox also includes a function that takes any MATLAB...



DCF is based on ACE,it provides a optional Name-Service for locating service, a single interface for both client and server. Anyone can embed DCF in a program to implement communication easily.

User Review for MATLAB-Excel Single Interface
- required fields
     

Please enter text on the image