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 check if a particular value is 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*)	Particular value
column/row (Required*)	Column name or row name

Output: <Dynamic Variable>(Optional)

Example

A retail company maintains an Excel sheet that records customer orders. The company wants to ensure that a specific order ID (e.g., ORD12345) is not present in the Order ID column before adding a new order. For this, the Verify Column Value in Excel action will support validating the absence of the order ID in the specified column.

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.