Excel export of Test Cases with Test Steps

Tags: not added yet

Export Test Cases with Test Steps Using Ms Excel

For an example on how to export test steps to Word see:

How to export Test Cases with Test Steps

The attached custom Excel template will export Test Cases together with Test Steps: Excel template

What it does is simply exporting Test Cases's id and name and their Steps, where each Steps goes to a new row. Like this:

[!testCaseWithSteps.png!]

Export Test Cases with custom Test Step columns

While custom column field values are not exposed directly, they can be accessed using groovy:

step.additionalColumnValues.find{it.key.name == 'CustomWikitext'}.value

For example:

<jt:forEach items="${items}" var="item">

<cb:groovy template="false" silent="false">
    testCase = new com.intland.codebeamer.manager.testmanagement.TestCase(item, user, applicationContext);
</cb:groovy>

<jt:forEach items="${testCase.testSteps}" var="step">

<cb:groovy template="false" silent="false">
    return step.additionalColumnValues.find{it.key.name == 'CustomWikitext'}.value
</cb:groovy>

</jt:forEach>

</jt:forEach>

See: Test Cases Export.xlsx