Simulink Requirement Editor: Indentation of Requirements upon importing them from Excel

3 views (last 30 days)
I want to import Requirements from an Excel File in the Requirements Editor of Simulink (2018a). I would like to be able to "group", or unfold/collapse requirements according to their topic, as it is shown in the example "Migrating Requirements Management Interface Data to Simulink® Requirements™" (https://ch.mathworks.com/help/slrequirements/examples/_mw_f304f626-0b76-4fbf-a313-1ab233014a0b.html) when requirements are imported from a word file (where apparently Bookmarks are recognized for that).
Is there a way to import requirements from excel, in order to have them in a collapsible structure in the Requirement editor? I have tried the REGEX way where I specified a regex expression for the unique Req IDs (IDs are recognized correctly, i.e. they turn red in the newly opened excel file that appears when pressing "Preview", and after the last item in a line there's a green item added, which I assume is a line termination item), but the mechanics behind when a new collapsible item is created is a bit shady to me.
Are named Excel cells the way to go? If yes, what's the strategy?
Thanks for your help!
Stefan

Answers (1)

Artem
Artem on 29 Oct 2018
Edited: Artem on 4 Jun 2024
Stefan, Thank you for posted question and detailed explanation. I think you are on the right path: REGEXP option should help. The hierarchy logic should do the job if your matched IDs are hierarchical. For example, let's say you Excel file has these IDs:
RQ1
RQ1.1
RQ1.2
RQ2
RQ2.1
RQ2.1.1
RQ2.1.2
You should get the correct nesting of imported items if you use a patter like this: RQ[\d\.]+. Let us know if this does not work - we'll investigate as a bug report.
Artem

Products


Release

R2018a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!