Spreadsheet Link™ User's Guide

Description

Getting Started Spreadsheet Link Product Description Key Features Installation Product Installation Supported Excel Versions Files and Folders Created by the Installation After You Upgrade the Spreadsheet Link Software Add-In Setup Configure Microsoft Excel Work with Excel Macros Work with Microsoft Visual Basic Editor Set Spreadsheet Link Preferences Preferences Dialog Box Preferences in Worksheet Cells Start and Stop Spreadsheet Link and MATLAB Start Spreadsheet Link and MATLAB Automatically Start Spreadsheet Link and MATLAB Manually Connect to an Already Running MATLAB Session Specify the MATLAB Startup Folder Stop Spreadsheet Link and MATLAB Create Diagonal Matrix Using Microsoft Excel Ribbon Create Diagonal Matrix Using Microsoft Excel Context Menu Create Diagonal Matrix Using Worksheet Cells Create Diagonal Matrix Using VBA Macro Find and Execute MATLAB Function Using MATLAB Function Wizard Find Custom MATLAB Function Using MATLAB Function Wizard Return Multiple Output Arguments from MATLAB Function Convert Dates Between Microsoft Excel and MATLAB Localization Information Execute Spreadsheet Link Functions Spreadsheet Link and Microsoft Excel Function Differences Spreadsheet Link Function Types Spreadsheet Link Function Execution Method Specify Spreadsheet Link Function in Microsoft Excel Set Calculation Mode Specify Spreadsheet Link Function Arguments Specify MATLAB Function in MATLAB Function Wizard Solving Problems with the Spreadsheet Link Software Model Data Using Regression and Curve Fitting Model Data in Worksheet Model Data Using VBA Macro Interpolate Thermodynamic Data Price Stock Options Using Binomial Model Plot Efficient Frontier of Financial Portfolios Map Time and Bond Cash Flows Error Messages and Troubleshooting Worksheet Cell Errors Microsoft Excel Errors Data Errors Matrix Data Errors Errors When Opening Saved Worksheets License Errors Startup Errors MATLAB Automatic Start Error MATLAB Version Errors Audible Error Signals Functions matlabfcn matlabinit matlabsub MLAppendMatrix MLAutoStart MLProgramId MLClose MLDeleteMatrix MLEvalString MLGetFigure MLGetMatrix MLGetVar MLMissingDataAsNaN MLOpen MLPutMatrix MLPutRanges MLPutVar MLShowMatlabErrors MLStartDir MLUseCellArray MLUseFullDesktop