Activities
latest
false
Productivity Activities
Last updated Jul 9, 2024

Delete Range

UiPath.Gsuite.Activities.DeleteRangeConnections

Description

Deletes a specified range.

Scopes

This activity requires the following scopes:

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

Project compatibility

Windows | Cross-platform

Configuration

  • Google Sheets connection - The connection for the Google Workspace account to use in the activity.
  • Spreadsheet - The Google spreadsheet to use. Click the Folderdocs image icon to browse Google Drive folders and select a spreadsheet. This option accepts input as IResource. Use the See more button menu to switch to Use variable or Url or ID input (String) modes.
    • If you select Use variable, you can use the output variable from other activities, such as Create Spreadsheet.
    • Spreadsheet URL - The URL or ID of the spreadsheet of interest. This field is available when Url or ID is selected as the input mode. This property supports String variables and string formatted values. For details, see How to retrieve spreadsheet IDs.
    • Select the Reload File Picker option if you've modified your folders and need to retrieve the latest data.

  • Range - Select a range or type a custom one (a full custom range can be used, i.e., Sheet1!A1:C10). This field is prepopulated with information retrieved from the selected spreadsheet. This property supports String variables and string formatted values.
    • Select the Update Ranges option if you've modified your sheets and need to retrieve the latest data.

  • Delete behavior - Indicates the delete mode. The available options are:
    • Clear - Clear the selected range. Default option.
    • Rows - Delete entire sheet rows of the selected range.
    • Columns - Delete entire sheet columns of the selected range.

Example



See also:
  • Description
  • Project compatibility
  • Configuration
  • Example

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.