Add-In Setup - MATLAB & Simulink (2024)

Add-In Setup

Configure Microsoft Excel

To enable the Spreadsheet Link™ add-in, start a Microsoft® Excel® session and follow these steps.

For Microsoft Excel 2013 and later versions:

  1. Select File from the main menu.

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

  3. Click Add-Ins.

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

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

  6. Click Browse.

  7. Select matlabroot\toolbox\exlink\excllink.xlam. (matlabroot returns the full path to the folder where MATLAB® is installed.)

  8. Click Open. In the Add-Ins dialog box, the Spreadsheet Link for use with MATLAB and Excel check box is selected.

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

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

The Spreadsheet Link add-in loads now and with each subsequent Excel session.

The MATLAB Command Window button appears on the Microsoft Windows® taskbar Add-In Setup- MATLAB & Simulink (2).

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

Add-In Setup- MATLAB & Simulink (3)

Spreadsheet Link is ready for use.

Right-click a cell to list the MATLAB options.

Note

If the options are missing from the context menu and if the Trust Center dialog box has the Require Application Add-ins to be signed by Trusted Publisher check box selected, then you must click the Enable Content button for every session.

To check the settings in the Trust Center dialog box:

  1. Click the Developer tab.

  2. In the Code group, click the Macro Security button. The Trust Center dialog box opens.

  3. Click Add-ins.

Work with Excel Macros

To work with Excel macros, follow these steps to enable the Developer tab on the Excel ribbon.

For Microsoft Excel 2013 and later versions:

  1. Click the File menu.

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

  3. Click Customize Ribbon.

  4. From the Main Tabs list, select Developer and click OK. The Excel ribbon displays the Developer tab.

  5. In the Code section of the Developer tab, click Macros. The Macro dialog box opens. Use this dialog box to run existing macros, create macros, and edit and delete macros.

Work with Microsoft Visual Basic Editor

To enable Spreadsheet Link as a Reference in the Microsoft Visual Basic® Editor:

  1. Open a Visual Basic session. Click the Visual Basic button on the Developer tab, or press Alt+F11.

    Note

    For instructions about displaying the Developer tab, see Excel Help.

  2. In the Visual Basic toolbar, select Tools > References.

  3. In the References — VBA Project dialog box, select the SpreadsheetLink check box.

  4. Click OK.

See Also

matlabroot

Related Topics

Add-In Setup
- MATLAB & Simulink (2024)
Top Articles
Latest Posts
Article information

Author: Aracelis Kilback

Last Updated:

Views: 5983

Rating: 4.3 / 5 (44 voted)

Reviews: 91% of readers found this page helpful

Author information

Name: Aracelis Kilback

Birthday: 1994-11-22

Address: Apt. 895 30151 Green Plain, Lake Mariela, RI 98141

Phone: +5992291857476

Job: Legal Officer

Hobby: LARPing, role-playing games, Slacklining, Reading, Inline skating, Brazilian jiu-jitsu, Dance

Introduction: My name is Aracelis Kilback, I am a nice, gentle, agreeable, joyous, attractive, combative, gifted person who loves writing and wants to share my knowledge and understanding with you.