Skip to main content

Add Sheet

UiPath.MicrosoftOffice365.Activities.Excel.AddSheet

Description​

The Add Sheet activity uses the Microsoft Graph Add worksheet API to add a new worksheet (Sheet) to a specified workbook (Workbook). The new worksheet gets added to the end of the existing worksheets in the workbook.

Scopes​

This activity requires the following scopes:

  • Sites.Read.All

OR

  • Sites.ReadWrite.All

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​

  • Sheet - The name of the newly created sheet. This property supports String variables and string formatted values.
  • Workbook - The DriveItem of the document to modify. This object can be retrieved using the Find Files And Folders activity. 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, be sure to specify which 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 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 Add Sheet activity inside the Microsoft Office 365 Scope activity.
  5. Enter values for the Input properties.
  6. Run the activity.

docs image