Delete Range

UiPath.GSuite.Activities.DeleteRange

Description

Deletes a specified range of cells and shifts the remaining cells up or left.

Scopes

This activity requires the following scopes:

• https://www.googleapis.com/auth/drive

OR

• https://www.googleapis.com/auth/spreadsheets

Project compatibility

Windows - Legacy | Windows

Configuration

In the Body of the Activity

• Spreadsheet - A reference to a Google Spreadsheet from which to delete the range. Typically obtained via the Use Google Spreadsheet activity. This property supports IGoogleSheetTarget variables.
• Sheet - The name of the sheet that you want to make changes to. This property supports String variables and string formatted values. The default value is "Sheet1".
• Range - Specifies the range of cells that you want to delete. This property supports String variables and string formatted values (enter your range in A1-style notation). The default value is "A1:B2".
  • For example, if you have data in cells A1:C4, and you enter A1:B3 as your Range, the data in cells A1:B3 is deleted and the data in cells A4, B4, and C1:C4 remains.

Properties Panel

Common

• ContinueOnError - If set, the remaining activities are executed if the current activity fails. This field supports Boolean values.
• DisplayName - The display name of the activity. This property supports String variables and string formatted values.

Input

• Spreadsheet - See Spreadsheet in the body of the activity.
• Range - See Range in the body of the activity.
• SheetName - See Sheet in the body of the activity.
• SpreadsheetID - The ID of the spreadsheet file to use.

Misc

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

Options

• Shift - A drop-down list that indicates whether you want to shift the remaining cells after deleting the specified Range. Select one of the following values from the drop-down list:

  • No Shift - The data in the cells located outside of the Range is unchanged and the remaining cells are left blank.

    • For example, if your Range value is "A1:B3", the data in cells A4, B4, and C1:C4 is unchanged.

  • Up - The data in the cells located below the Range is moved up to populate the remaining cells.

    • For example, if your Range value is "A1:B3", the data in cells A4 and B4 is moved to A1 and B1, while the data in C1:C4 is unchanged.

  • Left - The data in the cells located to the right of the Range is moved left to populate the remaining cells.

    • For example, if your Range value is "A1:B3", the data in cells C1, C2, and C3 is moved to A1, A2, and A3, while the data in A4, B4 and C4 is unchanged.