Spreadsheet Link™ EX

Starting and Stopping the Spreadsheet Link EX Software

Automatically Starting the Spreadsheet Link EX Software

When installed and configured according to the instructions in Configuring the Spreadsheet Link EX Software, the Spreadsheet Link EX and MATLAB software automatically start when you start a Microsoft Excel session.

Back to Top

Manually Starting the Spreadsheet Link EX Software

To start the Spreadsheet Link EX and MATLAB software manually from the Excel interface:

1. Click Tools > Macro.

2. Enter matlabinit into the Macro Name/Reference box.

   For more information about the matlabinit function, see Function Reference.

3. Click Run.

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

   

Back to Top

Connecting to an Existing MATLAB Session

To connect a new Excel session to an existing MATLAB session, start MATLAB with the spredsheetautomation command-line option. This option starts MATLAB as an automation server. The Command Window is minimized, and the Desktop is not running.

1. Right-click your MATLAB shortcut icon.

2. Select Properties.

3. Click the Shortcut tab.

4. Add the string /automation in the Target field. Remember to leave a space between matlab.exe and /automation.

5. Click OK.

Note   This option works only if the current MATLAB session is a registered automation version. If not, the Excel software starts a new MATLAB session rather than connecting to the existing one.

Back to Top

Stopping the Spreadsheet Link EX Software

• To stop both the Spreadsheet Link EX and MATLAB software, stop the Excel session as you normally would.

• To stop the Spreadsheet Link EX and MATLAB software and leave the Excel session running, enter the =MLClose() command into an Excel worksheet cell. You can use the MLOpen or matlabinit functions to restart the Spreadsheet Link EX and MATLAB sessions manually.

Back to Top

Configuring the Spreadsheet Link EX Software

About Functions