Skip to main content

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:

OR

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.