Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Setting Spreadsheet Link Preferences

To control how Spreadsheet Link™ and MATLAB® behave when Spreadsheet Link starts MATLAB in Microsoft® Excel®, you can set preferences with the Preferences dialog box or within individual worksheet cells.

Preferences Dialog Box

  1. Click Preferences in the MATLAB group. The MATLAB group appears to the top right of the Home tab in your Excel worksheet.

  2. Set your preferences by selecting check boxes and filling in the text boxes. For the MATLAB program id, enter the MATLAB version as shown in the Windows® registry. For the MATLAB startup folder, enter the full path of the startup folder.

Preferences in Worksheet Cells

To set a preference in a worksheet cell in Microsoft Excel, enter text that runs the corresponding Spreadsheet Link function in the worksheet cell. For example, to set the MATLAB version in a worksheet cell:

  1. Set the MATLAB version to 9.0, which corresponds to MATLAB R2016a, by entering this text.

    =MLProgramId("9.0")

  2. To run the function, press enter.

For details, see MLProgramId.

See Also

Related Topics

Was this topic helpful?