UiPath.Excel.Activities.ExcelGetWorkbookSheets
Returns a list of all the sheet names in a workbook as String variables, ordered by their index.
Properties
Common
- DisplayName - The display name of the activity.
Misc
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
Output
- Sheets - A list of strings containing all the sheet names in a workbook, ordered by their index. This field supports only strings and String variables.
Example of Using the Get Workbook Sheets Activity
To exemplify how to use this activity, we have built an automation project which retrieves a list containing all the names of the sheets in a workbook, and then writes them to the Output panel by using a For Each and a Write Line activity.
Download example
Updated about a year ago