Verify 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.

Syntax

Input: <value>;<column/row>

Argument	Description
value (Required*)	Required value
column/row (Required*)	Column name or row name

Output: <Dynamic Variable>(Optional)

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.