Data Parametrizing through Excel Sheet

Avo Assure allows you to use an Excel sheet to store and manage test data. You can use an Excel sheet to run the same test steps with multiple sets of input values. This helps you manage test data separately and reuse the same test case with different data sets.

To use data parameterization through excel sheet, perform the following actions:

1. On the Home page, under Projects, select the required project.
2. Go to Design Studio > Test Case.
3. Select the Test case and Test Step Group where you want to use data parameterization.
4. Select + icon and then select Add Step Manually to add a new test step.
5. From the Element column, select @Generic.
6. From the Action column, select Get Param.
7. In the Input Value column, enter the Excel file path and sheet name according to the action syntax.

Note:

• The Excel file must be stored in the unrestricted folder.
• From the File Explorer, copy the Excel file path using the Copy as Path option.
• When you use the Get Param action, you must add both Start Loop and End Loop as required steps.

1. Select + icon and then select Add Step Manually to add a new test step.
2. From the Element column, select @Generic.
3. From the Action column, select Start Loop to start the extraction from excel sheet.
4. After the Start Loop action, enter the required variables for the captured element in the Input Value column, separated by the pipe operator (|). For example: |URL|.

Note: The variable names should match the Excel column names.

1. Select + icon and then select Add Step Manually to add a new test step.
2. From the Element column, select @Generic.
3. From the Action column, select End Loop to stop the extraction from excel sheet.

Note: If you do not add Start Loop or End Loop, a dangling node error occurs during test execution.

1. Select Save.

Note: To learn about the different types of Excel actions, click here.