Rename Sheet

UiPath.MicrosoftOffice365.Activities.Excel.RenameSheet

Description

Uses the Microsoft Graph Update worksheet API to change the name of a specified workbook (Workbook) worksheet from its current name (OriginalSheetName) to a new name (NewSheetName).

Project compatibility

Windows - Legacy | Windows

Configuration

Properties

Common

• DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Input

• NewSheetName - The new name for the sheet. This property supports String variables and string formatted values.
• Original Sheet Name - The name of the sheet to rename. This property supports String variables and string formatted values.
• Workbook - The DriveItem of the workbook whose sheet is renamed. Use the output property variable from either the Find Files And Folders (First or Results) or Create Workbook (Workbook) activities. When using the Results output property from the Find Files and Folders activity, specify the item in the array that you want to use (e.g., myWorkbooks(0)).

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level. This field supports Boolean values.

How it works

The following steps and message sequence diagram is an example of how the activity works from design time (i.e., the activity dependencies and input/output properties) to run time.

1. Complete the Setup steps.
2. Add the Microsoft Office 365 Scope activity to your project.
3. Add an activity or run an external process that outputs a DriveItem object (e.g., Find Files and Folders, Create Workbook, Copy Item).
4. Add the Rename Sheet activity inside the Microsoft Office 365 Scope activity.
5. Enter values for the Input properties.

6. Run the activity.

   • Your input property values are sent to the UpdateWorksheet API.