GetExcelWorksheets (String excelFilePath)

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.

© Copyright 2023, Astera Software