© Copyright 2023, Astera Software
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. |
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
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.
