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.

Last updated

Was this helpful?