verify the column value in excel
This is a pre-built action in Avo Assure and comes under @Excel element. This action allows the user to verify whether a specific value is Present or Not Present in a column of an Excel file, which is helpful when dealing with files containing multiple columns.
Note: This action also supports .csv file format
Syntax
Input: <value>;<column/row>
value (Required)
Required value
column/row (Required)
Column name or row name
Not (Optional)
Not is used when working with negative scenario and it is not case sensitive
Output: <Dynamic Variable>(Optional)
<Dynamic Variable> (Requied)
The dynamic variable is optional, as it is used to store the status as either True or False and display it later.
Example 1
The Verify Column Value in Excel action checks the Order Status column for any orders marked as Pending. It scans the specified range of cells in the column and verifies if any cell contains the Pending status while excluding orders marked as Shipped.
Example 2 The Verify Column Value in Excel action ensures that a specific Order ID (e.g., ORD12345) is not present in the Order ID column before adding a new order. It validates the absence of the order ID in the specified column to prevent duplication.
Note: Checking for ORD12345 in the Order ID column will return true (value not present), allowing the new order to be added. Checking for ORD10002 will return false (value present), preventing duplicate entry.
Last updated
Was this helpful?