# GetExcelWorksheets (String excelFilePath)

| **Name**    | ***GetExcelWorksheets***                                          |
| ----------- | ----------------------------------------------------------------- |
| Syntax      | GetExcelWorksheets (String excelFilePath)                         |
| Purpose     | To enumerate and return names of Worksheets from an Excel file.   |
| Description | Enumerates names of all the worksheets in the Excel workbook.     |
| Return Type | List                                                              |
| Parameters  | excelFilePath \[System.String] – Full path of the Excel workbook. |

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20\(164\).png)

**Example**

In this example, we are passing the required parameter to the function transformation object using a *Variables* object. We will be checking for worksheets in an Excel file.

Where,

*excelFilePath* = C:\Users\Kanwal.Azim\OneDrive - Astera Software\Desktop\Test.xlsx

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20\(165\).png)

Right-click on the function transformation object and select *Preview Output.* As you can see, Astera Data Stack has returned a list of all the worksheet present in the Excel workbook, for which the path was specified.

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20\(165\).png)