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 order
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 or TC iteration, delete the respective row.
To edit the test data for an offline suite:
Open offline suite folder.
Take a backup of the original test data excel file 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 and specifying values for TC Iteration number and Selection , 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.