Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.872.804 Times

MATLAB-Excel Single Interface 1.0

  Date Added: March 25, 2013  |  Visits: 275

MATLAB-Excel Single Interface

Report Broken Link
Printer Friendly Version


Product Homepage
Download (19 downloads)



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

Requirements: No special requirements
Platforms: Matlab
Keyword: Arguments Arrayquotinputrange Quot Arrayquotoutputrange Quot Click Design Double Followscall Input Inputrange Inputscall Insert Output Quotcommandnamequot Quotinputrange Quot Quotoutputrange Quot Ranges Return Runinmatlab Usedcall
Users rating: 0/10

License: Freeware Size: 30.72 KB
USER REVIEWS
More Reviews or Write Review


MATLAB-EXCEL SINGLE INTERFACE RELATED
Development Tools  -  mouse simulation 1.0
With this program you can control mouse and click or double click anywhere you like without touching mouse !I also upload keyboard_simulation for controlling keyboard without touching it !It is recommended to combine these file for use it.These...
10 KB  
MP3 Tools  -  System Tray Hand 1.4
System Tray Hand displays system tray information that lets you right click, left click or double click the tray icon to run the application. It is a desktop widget which displays the current information of tray icon. The system tray is located in...
2.44 MB  
Utilities  -  Smart Controller 1.2
Smart Controller makes your iPhone or iPod touch as a wireless mouse(touch pad) to control your PC! Features: - Move Mouse - Single Click Mouse - Double Click Mouse - Drag Mouse - Click Mouse Right Button - Connect to your...
307.2 KB  
Libraries  -  Config::Magic 0.801
SYNOPSIS Example 1 use Config::Magic; use Data::Dumper; $input=q{ Section 1 { [Section 4] #Comment style #1 //Comment style #2 ;Comment style #3 Monkey:1 Monkey=>2 Monkey:=3 Foo = Bar Baz { Bip:1 Pants==5 } <...
20.48 KB  
Desktop Utilities  -  2010-11 Lakers Screensaver 1.0
Save the file and double click on it to run the file. It will automatically install the screensaver. Once it is installed, you will be able to set the screensaver settings for your computer.
3.83 MB  
Backup Utilities  -  KidKeyLock 2.2
Kid-Key-Lock's purpose is to lock specific keyboard keys/combinations and specific mouse functions. Kid-key-lock can be used to prevent accidental presses of the right mouse click, double click, and key combinations such as Alt-F4, Alt-Tab, the...
996.74 KB  
Business  -  Web Page Designing Software Available For Anyone Interested In Web Designing 9.0
With the ABCWebWizard Web Design software you can have full control of your web page design. This web page designing software lets you create your fully customized website with a simple point and click design. Unlike so many other types of...
2.93 MB  
Screen Savers  -  Kid-Key-Lock 1.7
Kid-Key-Lock's purpose is to lock specific keyboard keys/combinations and specific mouse functions. Kid-key-lock can be used to prevent accidental presses of the right mouse click, double click, and key combinations such as Alt-F4, Alt-Tab, the...
754 KB  
Programming  -  mCSS 1.5
mCSS is a free TextMate text editor CSS bundle which will enable you to access everything through tab triggers. You can access every CSS property by typing its initials. This system eliminates almost all typing. Installation...
143.36 KB  
Education  -  Falling Cup with Ball Model 1.0
The Falling Cup with Ball model shows a mass attached to the inside of a cup with a light spring. The cup is held upside down with the mass hanging out of the cup, then released from rest. What happens when the cup is released? 1. The...
10.24 KB  
NEW DOWNLOADS IN SCRIPTS, DEVELOPMENT TOOLS
Scripts  -  Free Ecommerce website creator 1.2
Free Ecommerce website creator is a free PHP shop creating script. This allows you to put a online shop on your own website. Create your own free ecommerce website for Your Business. Create an online shop using easyGUI online shop creator. The...
1.44 KB  
Scripts  -  MochiGames PHP Script ZDR 1.00
MochiGames PHP Script ZDR is web site, ready for use, for flash games. These flash games are downloaded automatically by "MochiGames PHP Script ZDR" from MochiGames media. The use of the games is free, you can use your own Mochi Publisher ID and...
368.54 KB  
Scripts  -  Php Chat 2.0
Add a free php site, single sign-on and multiple skins, 100% free 1. Server Modes: The chat server has paid mode and free mode. If the free chat mode, a free chat room will be assigned to your website with your domain as the room name. 2....
938.87 KB  
Scripts  -  Nibbleblog 3.0.1
Nibbleblog it's a powerful engine for creation and manipulation of BLOG's completely free. Very simple to install and configure (Only 1 step). The database used is based on XML files and this way it is not necessary to use MySQL or similar DBMS....
371.09 KB  
Scripts  -  PHP File Manager | CloudOsys 2.9b8
CloudOsys is a PHP file manager, a tool that allows your visitors upload files such as media content directly to your website. Your visitors will upload files directly to your website, where they can share and comment on them. Through cloud...
1.41 MB  
Development Tools  -  VMP Viewer 1.0
This is a very rudimentary tool to visualize the VMP files generated by BrainVoyager. Useful to share files with people who do not have BV.
10 KB  
Development Tools  -  7-Zip for Script 4.42
7-Zip is a file archiver with a high compression ratio.Features:- High compression ratio in new 7z format with LZMA compression- Supported formats:- Packing / unpacking: 7z, ZIP, GZIP, BZIP2 and TAR- Unpacking only: RAR, CAB, ISO, ARJ, LZH, CHM,...
624.64 KB  
Development Tools  -  PHP Docbook Displayer for Scripts 1.0b
PHP Docbook Displayer provides XSL and CSS stylesheets, and PHP scripts, to generate easily and dynamically websites from Docbook files.It aims at simplifying to the max the web publication process : simply drop the docbook file under the site root !
102.4 KB  
Development Tools  -  WP Translate 1.0
This simple language translation plugin allows your users to quickly translate your webpages, through a widget on your blog.You have the option to select the title of the Widget, which will be displayed above the language translation form. Users...
10 KB  
Development Tools  -  save2word 1.0
A simple function to copy figure from MATLAB into MS Word automatically. It is a modification of saveppt (a function in File exchange) that save figures to MS Powerpoint.
10 KB