UiPath Activities

Delete Range

UiPath.GSuite.Activities.DeleteRange

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

Properties

Common

  • DisplayName - The display name of the activity.

Input

  • 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.
  • SheetName - 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".
  • SpreadSheetID - The ID of the spreadsheet that you want to make changes to. This property supports String variables and string formatted values. When entering your value, use the exact ID, or the output property variable from a previous Find Files And Folders or Create New SpreadSheet activity.

Misc

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

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 (see Shift Examples below).
    • 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 (see Shift Examples below).
    • 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 (see Shift Examples below).

Updated 6 months ago


Delete Range


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.