Documentation

Spreadsheet Link EX Functions

Startup and Shutdown

matlabinit Initialize Spreadsheet Link EX and start MATLAB
MLAutoStart Automatically start MATLAB
MLClose Stop MATLAB
MLOpen Start MATLAB

Customization

MLMissingDataAsNaN Set empty cells to NaN or 0
MLShowMatlabErrors Return standard Spreadsheet Link EX errors or full MATLAB errors using MLEvalString
MLStartDir Specify MATLAB current working folder after startup
MLUseCellArray Toggle MLPutMatrix to use MATLAB cell arrays
MLUseFullDesktop Specify whether to use full MATLAB desktop or Command Window

Data Export to MATLAB

MLAppendMatrix Create or append MATLAB matrix with data from Microsoft Excel worksheet
MLDeleteMatrix Delete MATLAB matrix
MLPutMatrix Create or overwrite MATLAB matrix with data from Microsoft Excel worksheet
MLPutRanges Send data in Microsoft Excel named ranges to MATLAB
MLPutVar Create or overwrite MATLAB matrix with data from Microsoft Excel VBA variable

Data Import from MATLAB

MLGetFigure Import current MATLAB figure into Microsoft Excel spreadsheet
MLGetMatrix Write contents of MATLAB matrix to Microsoft Excel worksheet
MLGetVar Write contents of MATLAB matrix in Microsoft Excel VBA variable

MATLAB Commands in Microsoft Excel

matlabfcn Evaluate MATLAB command given Microsoft Excel data
matlabsub Evaluate MATLAB command given Microsoft Excel data and designate output location
MLEvalString Evaluate command in MATLAB
MLShowMatlabErrors Return standard Spreadsheet Link EX errors or full MATLAB errors using MLEvalString
Was this topic helpful?