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