MATLAB-Excel Single Interface Matlab script

SPONSORED LINKS

    Specification

  • Version:
  • File size: 0 KB
  • File name: MATLAB-Excel-Single-Interface.zip
  • Last update:
  • Platform: Windows / Linux / Mac OS / BSD / Solaris
  • Language: Matlab
  • Price:Freeware
  • Company: Russell Goyder (View more)

MATLAB-Excel Single Interface script description:




Publisher review:
MATLAB-Excel Single Interface allows M-code to be called using Excel Link and .NET(COM) Builder without making any changes in VBA 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.

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.

The package consists of three parts:1. MATLABInfrastructure.basThis is the VBA interface code. You must drag this into your VBA project.2. matlabgateway.mThis is an M-file called by subroutines in the MATLABInfrastructure code.3. filelist.mThis 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.

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 cellSTEP 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.

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. Requirements: · MATLAB Release: R2006a · Excel Link · MATLAB Builder for .NET
MATLAB-Excel Single Interface is a Matlab script for Development Tools scripts design by Russell Goyder. It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.

Operating system:
Windows / Linux / Mac OS / BSD / Solaris

Latest script and internet news

The new Firefox 37 comes with improved HTTP / 2 and superior HMTL5 compatibility with YouTube

The new Firefox 37 comes with improved HTTP / 2 and superior HMTL5 compatibility with YouTube

The popular browser Firefox reached version 37, bringing a series of news but not as significant as other versions.

Posted on: 03 Apr 2015 11:11 by A. Brown

The permanently active Push system offered by the new Google Chrome 42

The permanently active Push system offered by the new Google Chrome 42

Google Chrome version 42 comes with implementation of interesting options for software developers who want to turn their websites into complex Web applications: Push notification system which is permanently active.

Posted on: 17 Mar 2015 07:57 by A. Brown

Gamers, Microsoft presents the advantages of DirectX 12 and 11.3 platforms used by new games for Windows 10

Gamers, Microsoft presents the advantages  of DirectX 12 and 11.3 platforms used by new games for Windows 10

The Windows 10 preview event brought also to the attention of gamers a demonstration of the advantages of the new DirectX 12 API by Microsoft, which announced several technologies providing integration with Xbox One game consoles.

Posted on: 27 Jan 2015 09:15 by A. Brown

Android devices now have access to Google Chrome 40

Android devices now have access to Google Chrome 40

Finally was officially released version 40 of Chrome browser for Android devices, iOS and Windows PCs, coming up with an interesting range of bug fixes and optimizations.

Posted on: 23 Jan 2015 13:57 by A. Brown

SPREAD THE WORD

User Rating


Rating: 3.0 out of 5
Based on 1 ratings. 1 user reviews.

  • Currently 3.00 out of 5
  • 1
  • 2
  • 3
  • 4
  • 5