How to export all the Test sequences as excel or any other format from Simulink Test manager?

How to export all the Test sequences as excel or any other format from Simulink Test manager?

Answer 1

[atharva]

Hey Divyabharathi,

I understand that you want to export the test sequences.

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!

[Arkadi Bahnmann]

Hello @atharva,

I am also interested in this topic.

Where can I find the file programaticallySaveTestSequenceToXML.m you mentioned?

[Fernando Junior]

Yes. I would like to know how to find this .m custom file that you generated. Is it in guthub?

[Anila]

Hi Atharva, where can I find the file 'programaticallySaveTestSequenceToXML.m' ? Awaiting your response.

Answer 2

[Guilherme Costa Nascimento]

The code below gives a very simple way to do this. The more complex your Test Sequence and the more data you want to retain from it, the more you will need to add to this code.

I would advise against exporting to Excel because it's hard to represent the Test Sequence hierarchy using a tabular format. Instead, consider generating a report to share with others for review or documentation purposes.

% Path to the Test Sequence block
blkName = "myHarness/Test Sequence";

% List of steps for the Test Sequence
testSequenceSteps = sltest.testsequence.findStep(blkName);

% Preallocate table to store Test Sequence data
varNames = ["StepIndex", "StepName", "StepAction", "Transition", "Condition"];
testSequenceTable = array2table(strings(0, 5), "VariableNames", varNames);

% Go through each step
for i = 1:length(testSequenceSteps)

    % Get step information
    stepName    = testSequenceSteps{i};
    stepStruct  = sltest.testsequence.readStep(blkName, stepName);

    stepData    = string({num2str(stepStruct.Index), stepStruct.Name, stepStruct.Action, '', ''});

    % Table to store data for this step and its transitions
    testStepTable = array2table(stepData, "VariableNames", varNames);

    testStepTable = [testStepTable; array2table(strings(stepStruct.TransitionCount - 1, 5), ...
                                                        "VariableNames", varNames)];

    % Get data for each transition for this step
    for j = 1:stepStruct.TransitionCount
        transitionStruct = sltest.testsequence.readTransition(blkName, stepName, j);

        testStepTable{j, [4 5]} = string({transitionStruct.NextStep, transitionStruct.Condition});
    end

    % Add step data to main table
    testSequenceTable = [testSequenceTable; testStepTable];
end

writetable(testSequenceTable, 'exportedTestSequence.xlsx');