After creating an offline suite, for every test case, the associated test data are created as excel files. You can modify the test data such as replace the existing test data and enable or disable TC iterations.
Points to Know
Do not to add or remove any columns or change the column orders
Enter as $NULL$ in the associated cell where you do not want to add a value for a parameter in a TC or task iteration.
If you do not want a task iteration, delete the respective row.
To edit test data:
Open offline suite folder
Take a backup of original test data excel sheet that you want to edit.
Open the Test data excel. Right-click the Test Data sheet , and then click unprotect sheet.
In the excel sheet, the following values are displayed in the second row.
TC Iteration: Shows the number for every TC Iteration. There must be at least one TC Iteration for executing the test case.
Selection: Shows as True or False for the enabled or disabled iterations. You can modify the values.
DataSetTag: Optionally, enter a label for identifying the dataset in the test case execution report. You can modify the values.
From the third row, edit the values in their formats. The first row displays the different tasks highlighted in the grey color. Each task covers its parameters in the second row.
If you want to add a TC iteration, insert a row specifying values for TC Iteration number, selection and DataSetTag(Optional), then enter the values for the associated parameters.
If you want to add a task iteration, insert a row without specifying the TC Iteration number, and then enter the values for the associated parameters.
Ensure to save the excel file.