Verify Column Value in Excel

This is a pre-built action located 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 and save the result in dynamic variable.

Syntax

Input Value: <value>;<column/row>

Argument	Description
value (Required)	Value which needs to be verified
column/row (Required)	Specific the Column or row to be verified

Output Value:

Argument	Description
<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)	This variable holds the results in True and False

Example:

Verify Column Value in Excel file

The Verify Column Value in Excel action takes the value from the Input Value column (e.g., ORD10004 ;Order ID) and checks whether the specified value (ORD10004) exists in the given column (Order ID) in the excel sheet. The result of the verification is stored in the {Value Present} variable, with the following possible values:

• True – if the value is found.

• False – if the value is not found or an error occurs.