Returns a list of all the sheet names in a workbook as String variables, ordered by their index.
- DisplayName - The display name of the activity.
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
- 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.
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.
Updated about a year ago