Learn more about Spreadsheet Link EX

Configuring the Spreadsheet Link EX Software

On this page…
Configuring Version 2003 and Earlier Versions of the Microsoft Excel Software Configuring Version 2007 of the Microsoft Excel Software Setting Spreadsheet Link EX Preferences

Configuring Version 2003 and Earlier Versions of the Microsoft Excel Software

1. Start Microsoft Excel.

2. Enable the Spreadsheet Link EX Add-In.

   1. Click Tools > Add-Ins. The Add-Ins dialog box appears.

   2. Click Browse.

   3. Select matlabroot\toolbox\exlink\excllink.xla.

      Note   Throughout this document the notation matlabroot is the MATLAB root folder, the folder where the MATLAB software is installed on your system.

   4. Click OK.

      In the Add-Ins dialog box, the Spreadsheet Link EX for use with MATLAB check box is now selected.

   5. Click OK to exit the Add-Ins dialog box.

The Spreadsheet Link EX Add-In loads now and with each subsequent Excel session.

The MATLAB Command Window button appears on the Microsoft Windows taskbar.

The Spreadsheet Link EX toolbar appears on your Excel worksheet.

The Spreadsheet Link EX software is now ready for use.

Back to Top

Configuring Version 2007 of the Microsoft Excel Software

1. Start a Microsoft Excel session.

2. Enable the Spreadsheet Link EX Add-In:

   1. Click , the Microsoft Office Button.

   2. Click Excel Options. The Excel Options dialog box appears.

   3. Click Add-Ins.

   4. From the Manage selection list, choose Excel Add-Ins.

   5. Click Go. The Add-Ins dialog box appears.

   6. Click Browse.

   7. Select matlabroot\toolbox\exlink\excllink2007.xlam.

   8. Click Open.

   9. In the Add-Ins dialog box, the Spreadsheet Link EX for use with MATLAB check box is now selected.

      

   10. Click OK to close the Add-Ins dialog box.

   11. Click OK to close the Excel Options dialog box.

The Spreadsheet Link EX Add-In loads now and with each subsequent Excel session.

The MATLAB Command Window button appears on the Microsoft Windows taskbar:

The MATLAB group appears on the top right of the Home tab in your Excel worksheet:

The Spreadsheet Link EX software is now ready for use.

Right-click on a cell for MATLAB options. The following menu appears:

Note   Using both the 2003 and 2007 Add-Ins referenced in Excel 2007 causes problems with the context sensitive menu. Use only one Add-In at a time to avoid this issue.

Back to Top

Setting Spreadsheet Link EX Preferences

Use the Preferences dialog box to set Spreadsheet Link EX preferences. Click the preferences button in the Excel toolbar or Matlab group to open this dialog box.

Preferences include:

• Start MATLAB when Excel starts (enabled by default) starts a MATLAB session automatically when an Excel session starts.

• MATLAB current working folder lets you specify the current working folder for your MATLAB session at startup.

• Use MATLAB desktop starts the MATLAB desktop, including the current folder, workspace, command history, and Command Window panes, when an Excel session starts.

• Force use of MATLAB cell arrays with MLPutMatrix enables the MLPutMatrix function to use cell arrays for data transfer between the Excel software and the MATLAB workspace.

• Treat missing/empty cells as NaN sets data in missing or empty cells to NaN or zero.

Back to Top

Installing the Spreadsheet Link EX Software

Starting and Stopping the Spreadsheet Link EX Software

© 1984-2009- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS