Documentation

This is machine translation

Translated by Microsoft
Mouse over text to see original. Click the button below to return to the English verison of the page.

Spreadsheet Link Functions

Alphabetical List By Category

Startup and Shutdown

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

Customization

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

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 worksheet
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 errors or full MATLAB errors using MLEvalString
Was this topic helpful?