GetExcelWorksheets (String excelFilePath)
Last updated
Last updated
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.