MKXLSFUNC: Easily integrate legacy spreadsheet tools into MATLAB

版本 1.4.0.0 (114.7 KB) 作者: Sky Sartorius
Creates an m-file function that does analysis within your specified Excel-based analysis tool.
854.0 次下载
更新时间 2013/5/21

查看许可证

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.

引用格式

Sky Sartorius (2024). MKXLSFUNC: Easily integrate legacy spreadsheet tools into MATLAB (https://www.mathworks.com/matlabcentral/fileexchange/40404-mkxlsfunc-easily-integrate-legacy-spreadsheet-tools-into-matlab), MATLAB Central File Exchange. 检索来源 .

MATLAB 版本兼容性
创建方式 R2013a
兼容任何版本
平台兼容性
Windows macOS Linux
类别
Help CenterMATLAB Answers 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
版本 已发布 发行说明
1.4.0.0

help, error checking, more path support, style

1.3.0.0

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

1.2.0.0

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

1.1.0.0

minor cleanups, more helpful example

1.0.0.0