# 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FQHdXco4FrAznZcJ4Pubf%2F0.png?alt=media)

**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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FWOwYbUa5emZ8XC7VUuB3%2F1.png?alt=media)

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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F2WWpbuU9PfCRGdoZomI1%2F2.png?alt=media)