Verify excel Empty

This is a pre-built Action located under the @Excel Element. The functionality of this Action in Avo Assure is to check whether an Excel file is empty or blank, allowing you to verify the presence of data before proceeding with further tasks. The result is stored in a dynamic variable for further use during test execution.

Syntax

Input Value: <excel path>

Argument	Description
<excel path> (Required)	Provide the path of the Excel file to verify whether the file is empty or blank.

Output Value: <Dynamic Variable>(Optional);<Dynamic Variable>(Optional)

Argument	Description
<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)	Both dynamic variable stores the status as True or False.
0	This show the reports 100% pass even if the step is failed.

Example: Verifying if an Excel File is Empty

In this example, we explain how to check whether a specified Excel file contains any data using the Verify excel Empty action.

• Action: Verify excel Empty

• Input Value: C:\sam\Get.xlsx

  • The input value (C:\sam\Get.xlsx) specifies the path of the Excel file that needs to be verified. The action checks whether the file located at this path contains any data or is empty.

• Output Value: {IsEmpty}

  • The execution status of the action is stored in this {IsEmpty} variable with the following possible values:

    • True: If the Excel file is empty.

    • False: If the Excel file contains data.

• Logical Explanation: The Verify Excel Empty action takes the value from the Input Value column C:\sam\Get.xlsx and checks if the specified Excel file has any data. The verification result is stored in the {IsEmpty} variable as true.