How can I export the test results from simulink test manager to an excel sheet programmatically ?

Hi, I am trying to export the test results after execution of five testcases in simulink test manager to an excel sheet programmatically. Please let me know how can I perform the same ? I am using Matlab 2017b.

Any feedback is appreciated.

Answer 1

[atharva]

Hey Geethika,

I understand that you want to export the test sequence test steps to Excel.

Currently there isn't an automated way to export the Test Sequence information to TXT/XML files.

As a workaround, you can use some of the Test Sequence APIs to get the step and transition information. Here are some resources you can utilize to accomplish this:

1. To get names/paths of all the steps in a Test Sequence block: sltest.testsequence.findStep(blockPath)

https://www.mathworks.com/help/sltest/ref/sltest.testsequence.findstep.html?searchHighlight=readstep&s_tid=doc_srchtitle

2. Then you can loop over all the step paths to read step information for each step.

3. To get the information for each step as a struct: sltest.testsequence.readStep(blockPath, stepPath)

https://www.mathworks.com/help/sltest/ref/sltest.testsequence.readstep.html?s_tid=srchtitle

(The number of transitions is in the return struct)

4. For Each step, you can loop over all the transitions to read transition information for each step.

5. To get the information for each transition as a struct: sltest.testsequence.readTransition(blockPath, stepPath, transitionIndex)

https://www.mathworks.com/help/sltest/ref/sltest.testsequence.readtransition.html

After getting all the information, the you can write them into TXT or XML files.

6. Please take a look at the example in the attachment. The script "programaticallySaveTestSequenceToXML.m" works to export test sequences as an "xml" file. This script is modified from the shipped example below.

- Programmatically Create a Test Sequence

https://www.mathworks.com/help/sltest/ug/programmatically-create-a-test-sequence.html

I hope this helps!