MKXLSFUNC: Easily integrate legacy spreadsheet tools into MATLAB
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.
Citar como
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. Recuperado .
Compatibilidad con la versión de MATLAB
Compatibilidad con las plataformas
Windows macOS LinuxCategorías
Etiquetas
Agradecimientos
Inspirado por: xlswrite1, Function for faster data transfer Matlab <--> Excel
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Descubra Live Editor
Cree scripts con código, salida y texto formateado en un documento ejecutable.
html/
Versión | Publicado | Notas de la versión | |
---|---|---|---|
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
|
||
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 |