Documentation

This is machine translation

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

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Spreadsheet Link Functions

Alphabetical List By Category

Startup and Shutdown

matlabinitInitialize Spreadsheet Link and start MATLAB
MLAutoStartAutomatically start MATLAB
MLCloseStop MATLAB
MLOpenStart MATLAB

Customization

MLAutoStartAutomatically start MATLAB
MLProgramIdSpecify MATLAB version
MLStartDirSpecify MATLAB current working folder after startup
MLUseFullDesktopSpecify whether to use full MATLAB desktop or Command Window
MLMissingDataAsNaNSet empty cells to NaN or 0
MLUseCellArrayToggle MLPutMatrix to use MATLAB cell arrays
MLShowMatlabErrorsReturn standard Spreadsheet Link errors or full MATLAB errors

Data Export to MATLAB

MLAppendMatrixCreate or append MATLAB matrix with data from Microsoft Excel worksheet
MLDeleteMatrixDelete MATLAB matrix
MLPutMatrixCreate or overwrite MATLAB matrix with data from Microsoft Excel worksheet
MLPutRangesSend data in Microsoft Excel named ranges to MATLAB
MLPutVarCreate or overwrite MATLAB matrix with data from Microsoft Excel VBA variable

Data Import from MATLAB

MLGetFigureImport current MATLAB figure into Microsoft Excel worksheet
MLGetMatrixWrite contents of MATLAB matrix to Microsoft Excel worksheet
MLGetVarWrite contents of MATLAB matrix in Microsoft Excel VBA variable

MATLAB Functions in Microsoft Excel

matlabfcnEvaluate MATLAB command given Microsoft Excel data
matlabsubEvaluate MATLAB command given Microsoft Excel data and designate output location
MLEvalStringEvaluate MATLAB command in MATLAB
MLShowMatlabErrorsReturn standard Spreadsheet Link errors or full MATLAB errors
Was this topic helpful?