|
|
|
| R2012a Documentation → Spreadsheet Link EX | |
Learn more about Spreadsheet Link EX |
|
| Contents | Index |
| On this page… |
|---|
Install the Microsoft Excel product before you install the MATLAB and Spreadsheet Link EX software. To install the Spreadsheet Link EX Add-In, follow the instructions in the MATLAB installation documentation. Select the Spreadsheet Link EX check box when choosing components to install.
Note If you have several versions of MATLAB installed on your computer, Spreadsheet Link EX software uses the version that you registered last. |
Note Throughout this document the notation matlabroot is the MATLAB root folder, the folder where the MATLAB software is installed on your system. |
The Spreadsheet Link EX installation program creates a subfolder under matlabroot\toolbox\. The exlink folder contains the following files:
excllink.xla: The Spreadsheet Link EX Add-In for Microsoft Excel 2003 and earlier versions
excllink2007.xlam: The Spreadsheet Link EX Add-In for Microsoft Excel 2007 or 2010
ExliSamp.xls: Spreadsheet Link EX example files described in this documentation
The Spreadsheet Link EX software uses Kernel32.dll, which should already be in the appropriate Windows system folder (for example, C:\Winnt\system32). If not, consult your system administrator.
Add matlabroot\bin to your system path. For more information about editing your system path, consult your Windows documentation or your system administrator.
If MATLAB and Spreadsheet Link EX are installed on your computer, to upgrade to a newer version:
Install the new version of MATLAB and the Spreadsheet Link EX software.
Start MATLAB and a Microsoft Excel session.
If you have existing workbooks with macros that use the Spreadsheet Link EX software, update the references to the Spreadsheet Link EX software in each workbook.
To update the references in an existing workbook in Microsoft Excel 2003 or earlier versions:
In a Microsoft Excel session, open the Visual Basic® Editor window by selecting Tools > Macros > Visual Basic Editor.
In the left pane, select a module for which you want to update a reference.
From the main menu, select Tools > References.
In the References dialog box, select the SpreadsheetLinkEX check box.
Click OK.
To update the references in an existing workbook in Microsoft Excel 2007 or 2010:
In a Microsoft Excel session, open the Visual Basic Editor window by clicking Visual Basic on the Developer tab. (If you do not find the Developer tab, see the Excel Help.)
In the left pane, select a module for which you want to update a reference.
From the main menu, select Tools > References.
In the References dialog box, select the SpreadsheetLink2007_2010 check box.
Click OK.
 | Microsoft Excel and MATLAB Interaction | Add-in Setup |  |
Includes the most popular MATLAB recorded presentations with Q&A sessions led by MATLAB experts.
| © 1984-2012- The MathWorks, Inc. - Site Help - Patents - Trademarks - Privacy Policy - Preventing Piracy - RSS |
