Spreadsheet Link™ EX

Configuring the Spreadsheet Link™ EX Software

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 directory, the directory where the MATLAB is installed on your system.

   4. Click OK.

      In the Add-Ins dialog box, the Spreadsheet Link EX 3.0.1 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^® software 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. Click My Computer > Properties. The System Properties pane appears.

2. Click the Advanced tab.

3. Click Environment Variables.

4. Under System variables, double-click the PATH variable. The Edit System Variable window appears.

5. Add matlabroot\bin\win32 to the Variable value field.

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

6. Click OK on all dialog boxes until you exit System Properties.

7. Right-click the MATLAB shortcut icon and choose Properties from its context menu. The Properties pane appears.

8. In the Target field, enter /regserver.

9. Click Apply.

10. Start a Microsoft Excel software session.

11. 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/excllink.xla.

    8. Click Open.

    9. In the Add-Ins dialog box, the Spreadsheet Link EX 3.0.1 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 software 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

Setting Spreadsheet Link™ EX Preferences

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

Preferences include:

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

• MATLAB current working directory enables you to specify the current working directory for your MATLAB software session at startup.

• Use MATLAB desktop starts the MATLAB desktop, including the current directory, workspace, command history, and Command Window panes, when an Excel software 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