Activities
latest
false
Banner background image
Productivity Activities
Last updated Mar 27, 2024

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.

  • Properties
  • Example of Using the Get Workbook Sheets Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.