Quantcast

Documentation Center

  • Trial Software
  • Product Updates

Functions in Spreadsheet Link EX

  • By Category | Alphabetical List
  • 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 MATLAB 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?