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.

Syntax

Input: <value>;<column/row>

Argument
Description

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)

Argument
Description

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

Last updated

Was this helpful?