View License

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Highlights from
MKXLSFUNC: Easily integrate legacy spreadsheet tools into MATLAB

Be the first to rate this file! 5 Downloads (last 30 days) File Size: 115 KB File ID: #40404 Version: 1.4
image thumbnail

MKXLSFUNC: Easily integrate legacy spreadsheet tools into MATLAB


Sky Sartorius (view profile)


19 Feb 2013 (Updated )

Creates an m-file function that does analysis within your specified Excel-based analysis tool.

| Watch this File

File Information

Often a very useful and complicated spreadsheet tool is available, and mkxlsfunc takes the overhead out of integrating the tool into the rest of your MATLAB code by generating an m-file function that automatically writes inputs to the spreadsheet and reads the outputs.
[h,nargin,nargout] = mkxlsfunc(functionName,xlsFile,inputRange,outputRange,sheet,overwrite)
The newly-created function, when provided with too few or no inputs, will use default values as determined by the contents of the xls input cells at the time of the function creation.

MKXLSFUNC is also a great function for Excel addicts who want to do most of their tool development in Excel. It's also great for the colleagues of Excel addicts.


Xlswrite1 and Function For Faster Data Transfer Matlab < > Excel inspired this file.

MATLAB release MATLAB 8.1 (R2013a)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
20 Feb 2013 1.1

minor cleanups, more helpful example

20 Mar 2013 1.2

updated help and example file; changed vertcat to catch invalid inputs; added arrayfun to help block and example file

04 Apr 2013 1.3

formatting of function help block and generated function help block
turned example file into a published file
default for empty functionName now taken from file name

21 May 2013 1.4

help, error checking, more path support, style

Contact us