checks the column exists

This is a pre-built action in Assure under the @Excel element. It verifies whether a specific column is present or not in an Excel file, helping to ensure that the required data fields are included.

Note: This action also supports .csv file format

Syntax

Input: <column name>

Argument	Description
column name (Required*)	Particular column 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 (Required)	The dynamic variable is optional, as it is used to store the status as either True or False and display it later.

Example 1

A payroll department maintains an Excel sheet containing employee salary details. Before processing payroll, the system must verify that the Employee ID column is present to ensure data accuracy.

Note: Validation of Example

Verifying for Employee ID column → Returns True (column exists), allowing payroll processing.

Verifying for Bonus column→ Returns False (column missing), triggering an alert.

Example 2 A payroll department maintains an Excel sheet containing employee salary details. Before processing payroll, the system must verify that the Bonus column is not present to ensure data accuracy.