How to generate test definitions for yout test infrasctucture in an auto-populated Excel sheet directly from Test Data embedded in Test Cases.

Created an Excel template according to the columns and rows you require. The following are the keywords which can be used in the Excel templates.




Index number of the test case.


Number of times the test case is repeated.


The original name of the test case.


The repeated name of the test case.


The index of the test step within the test case.


The test step name.


The test step description.


The test step expected result.


List of variables assigned within the test step.


List of values assigned within the test step.


A specific test data value. Replace <variablename> with the variable name.

Register the Excel file

First off is to register the Excel sheet in Test Modeller. To do so, along the left Dashboard menu go to Workspace > Configuration and click the Code Templates tab. Click the blue button New Template and in the New Code Template pop-up complete the info for Name, from the Type drop down menu select Excel. Finally Browse to choose the original Excel file. Notice the new specificed Code Template is listed at the bottom as most recently added, with three actions to either edit, delete or download.

Idenfity Test Steps

Only nodes indicated as Test Steps export to the Excel Code Template. To activate a waypoint as a Test Step, first select one on the model canvas, then in the Explorer pane on the right click the i icon, then in Properties toggle to activate as a Test Step.

Note: Condition blocks may not be necessary to indicate as a Test Step since their purpose on the canvas is more to indicate a choice along a path. Test Steps refer more to the oucomes of those decisions.

Give paramters to Descriptions and Expected Results for export

In the Properties pane add Descriptions and Expected Results. In this example a cDescription is given as: Enter a valid username '$[Username]' and Expected Result as: '$[Username]' appears in the username field . These are the Test Data Variables specified to be injected. To do so click the Insert Variable dropdown.

Generate, export and download the Data

Click Generate and then Export Test Suite selecting Connector Profile as Excel Template and specify the Template as the one you originally created. Open the downloaded file and see the Test Steps, along with ant other spcified fields are populated including any Test Data Variables, with the Test Type and Status.