Export Tests to Microsoft Excel
Export Tests to Microsoft Excel
Article summary
Did you find this summary helpful?
Thank you for your feedback
Learn how to generate test definitions for your test infrastructure 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.
Keyword | Description |
|---|---|
$[test_case_no] | Index number of the test case. |
$[test_case_no_repeated] | Number of times the test case is repeated. |
$[test_case_name] | The original name of the test case. |
$[test_case_name_repeated] | The repeated name of the test case. |
$[test_case_step_no] | The index of the test step within the test case. |
$[test_case_step_name] | The test step name. |
$[test_case_step_desc] | The test step description. |
$[test_case_step_expected_result] | The test step expected result. |
$[test_data_variable_names] | List of variables assigned within the test step. |
$[test_data_variable_values] | List of values assigned within the test step. |
$[test_data_variable_value][<variablename>] | A specific test data value. Replace <variablename> with the variable name. |
Register the Excel file
First off is to register the Excel sheet in Quality 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 specified Code Template is listed at the bottom as most recently added, with three actions to either edit, delete or download.
Identify 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 outcomes of those decisions.
Give parameters to Descriptions and Expected Results for export
In the Properties pane, add Descriptions and Expected Results. In this example, a Description 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 specified fields are populated including any Test Data Variables, with the Test Type and Status.
