Sheet Name

This is a pre-built action located under @Excel element. This action will allow user to retrieve the Excel sheet name, enabling them to identify the file and begin performing actions on it efficiently and save the result in dynamic variable.

Syntax

Input Value: <excel path>

Argument	Description
excel path (Required)	Required excel sheet path for retrieving sheet name

Output Value:

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

Example Retrieves all sheet names from the specified Excel file The Sheet Name action takes the value from the Input Value column (C:\sam\Get.xlsx) and fetches all the sheet names available in the specified Excel file. The result is stored in the {Sheetnames} variable, while the execution status is stored in the {Status} variable, with the following possible values:

• False – if retrieval fails.

• True – if sheet names are retrieved successfully.