Activities
latest
false
Banner background image
Productivity Activities
Last updated 1 de mar. de 2024

Delete Range

UiPath.GSuite.Activities.DeleteRange

Description

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

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.
  • Description
  • Project compatibility
  • Configuration

Was this page helpful?

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