# 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>`

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td>&#x3C;excel path><br>(Required) </td><td>Provide the path of the Excel file from which you want to retrieve the sheet name.</td><td></td></tr></tbody></table>

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

<table><thead><tr><th>Argument</th><th>Description</th><th data-hidden></th></tr></thead><tbody><tr><td>&#x3C;Dynamic Variable><br>(Required)</td><td>This dynamic variable stores the excel sheet names.</td><td></td></tr><tr><td>&#x3C;Dynamic Variable><br>(Optional)</td><td>This dynamic variable stores the status as <strong>True</strong> or <strong>False</strong>.</td><td></td></tr></tbody></table>

### 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).

<figure><img src="/files/mLp4JpA1d0dPqnx1RtDx" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.avoautomation.com/avo-assure/actions/excel/sheet-name.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.