UiPath Activities

The UiPath Activities Guide

Get Workbook Sheets

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


Get Workbook Sheets


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.