activities
latest
false
UiPath logo, featuring letters U and I in white

Productivity Activities

Last updated Feb 12, 2025

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.

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
© 2005-2025 UiPath. All rights reserved.