Check the column exist

This is a pre-built action located under @Excel element. This action verifies that a specific column is present or Not present in an Excel file and save the result in dynamic variable.

Syntax

Input Value: <column name>

Argument
Description

column name (Required)

Required column name to check specific column is present or not

Output Value:

Argument
Description

<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)

This variable holds the results in True and False

Example

The Check the Column Exist action takes the column name from the Input Value column (e.g., Employee ID) and checks whether it exists in the Excel file. The result is stored in the {ColumnExist} variable, and the execution status is stored in the {Status} variable with the following possible values:

True – if the column is found. False – if the column is not found or an error occurs.

Last updated

Was this helpful?