Spreadsheet Link™ User's Guide

✍ Scribed by The MathWorks, Inc.

• Publisher: The MathWorks, Inc.
• Year: 2022
• Tongue: English
• Leaves: 130
• Category: Library

✦ Table of Contents

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