Clear Range

Clear Range activity that uses the Microsoft Graph Clear range API to clear values, format, fill, border, etc in Microsoft 365.

UiPath.MicrosoftOffice365.Activities.Excel.ClearRange

Description

Uses the Microsoft Graph Clear range API to clear values, format, fill, border, etc. of a range from the specified sheet.

Scopes

This activity requires the following scopes:

• Files.ReadWrite

OR

• Files.ReadWrite.All

OR

• Sites.ReadWrite.All

Project compatibility

Windows - Legacy | Windows

Configuration

Properties panel

Common

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

Input

• Clear Action - Indicates the type of clear action to perform. Select one of three options: All, Formats, Contents. The default value is All.
• Range - Indicates the range that will be cleared. This property supports String variables and string formatted values.
• Sheet Name - The name of the sheet from which the range will be cleared. This property supports String variables and string formatted values.
• Workbook - The Drive Item of the Excel document. Use the Find Files And Folders activity to retrieve this Drive Item. This field supports only DriveItem variables.

Misc

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