Verify excel Empty

This is a pre-built action in Avo Assure and comes under @Excel element. This action allows the user to check if an Excel file is empty or blank, helping to quickly verify the presence of data before proceeding with further tasks and save the result in dynamic variable.

Syntax

Input Value: <excel path>

Argument	Description
excel path (Required)	Required excel file path for verifying the sheet is empty or blank

Output Value:

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

Example

Checks if the Excel file is empty The Verify Excel Empty action takes the value from the Input Value column (C:\sam\Get.xlsx) and checks if the specified Excel file contains any data. The result is stored in the {IsEmpty} variable, while the execution status is stored in the {Status} variable, with the following possible values:

• True – if the Excel file is empty.

• False – if the Excel file has data or verification fails.