Link to Requirements in Microsoft Excel
You can create direct links from requirements managed in Microsoft® Excel® to items in MATLAB® and Simulink®. You can use the links and backlinks inserted in Excel to navigate from the requirements to the design or to tests.
Alternatively, you can import requirements from Microsoft Excel into Requirements Toolbox™. For more information, see Differences Between Importing and Direct Linking.
You can create direct links to requirements in Microsoft Excel only on Microsoft Windows® platforms.
Link and Navigate to Requirements in Excel from Simulink blocks
This example shows how to link requirements authored in Microsoft Excel to Simulink blocks and how to navigate between the requirements and the design by using direct links and external backlinks.
slvnvdemo_FuelSys_TestScenarios.xlsx requirements document.
Configure Selection Link Settings
First, ensure that Requirements Toolbox™ can link to Excel documents and that bidirectional linking and external connectivity are enabled.
In Simulink, in the Apps tab, click Requirements Manager.
In the Requirements tab, ensure Layout > Requirements Browser is selected.
In the Requirements pane, in the View drop-down menu, select
In the Requirements tab, click Link Settings > Linking Options. The Requirement Settings dialog opens.
In the Selection Linking tab, next to Enabled applications, ensure that Excel is selected.
Ensure that Document file reference is set to
filename only (on MATLAB path).
Under When creating selection-based links, select Modify destination for bidirectional linking and Store absolute path to model file. Ensure that Use ActiveX for incoming links (backward compatibility) is cleared.
Ensure that Enable external connectivity at MATLAB startup is selected.
Link to a Selection in Microsoft Excel
slvnvdemo_FuelSys_TestScenarios Excel file, select the requirement
126.96.36.199 Speed Sensor Failure in cell B22.
At the top level of the
slvnvdemo_fuelsys_officereq model, right-click the
speed sensor block and select Requirements > Link to selection in Excel to create the link.
Navigate Between Simulink and Excel
To navigate from the
speed sensor block to the requirement in Excel, right-click the block and select Requirements > 1. "188.8.131.52 Speed Sensor Failure".
To navigate from the requirement in Excel to the
speed sensor block, click the backlink icon .
If your Excel file does not contain a backlink, you can update the backlinks for the link set. For more information, see Manage Navigation Backlinks in External Requirements Documents.