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

Select + icon and then select Add Step Manually to add a new test step.
From the Element column, select @Generic.
From the Action column, select Start Loop to start the extraction from excel sheet.
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|.
Select + icon and then select Add Step Manually to add a new test step.
From the Element column, select @Generic.
From the Action column, select End Loop to stop the extraction from excel sheet.
Select Save.

Last updated