Sheet Name

This is a pre-built Action located under the @Excel Element. The functionality of this Action in Avo Assure is to retrieve the name of the Excel sheet. 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 from which you want to retrieve the sheet name.

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

Argument	Description
<Dynamic Variable> (Required)	This dynamic variable stores the excel sheet names.
<Dynamic Variable> (Optional)	This dynamic variable stores the status as True or False.

Example: Retrieving All Sheet Names from an Excel File

In this example, we explain how to retrieve all sheet names from a specified Excel file using the Sheet Name action.

• Action: Sheet Name

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

  • The input value (C:\sam\Get.xlsx) specifies the path of the Excel file from which the sheet names need to be retrieved. The action reads the file at the given location and extracts all available sheet names.

• Output Value: {Sheet Names}

  • The retrieved sheet name (e.g., Order ID, Employee Info) is stores in this {Sheet Name} dynamic variable.

  • If a second output variable is defined, it stores the action status with the following possible values:

    • True: If the sheet names are retrieved successfully.

    • False: If the sheet names are not retrieved successfully.

• Logical Explanation: The Sheet Name action takes the value from the Input Value column C:\sam\Get.xlsx and fetches all the sheet names present in the specified Excel file. The retrieved sheet names are stored in the {Sheet Names} variable (e.g., Order ID, Employee Info).