Delete Column

UiPath.Gsuite.Activities.DeleteColumnConnections

Description

Delete a specified column from a sheet or range. The column on the right of the deleted column is then shifted to the left.

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 target spreadsheet to delete columns from. Click the Folder 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.
  • Spreadsheet sample - Select a file with the same ranges as the variable file. The field is visible after clicking Use spreadsheet template. Browse the Google Drive folders and select a spreadsheet. In Studio Desktop, the option is available from the Plus button menu next to Range. This field accepts IResource input. To learn more, see Working with templates.
  • 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 - Indicates the range where to delete the column. You can write custom ranges using full A1 Notation, e.g., Sheet1C2:F10. This property supports String variables and string formatted values.
• Has headers - If selected, the column headers are generated by reading the range header. Boolean value. Default value is set to True.
• Column Name or Column Position - Specify a column or a column position to delete, e.g., "Transaction Date", "2". The first position is 0.
  • Update columns - Select this option if you've modified your sheet and need to retrieve the latest data.
• Delete behavior - Indicates the delete mode.
  • Clear contents - Clear contents of the selected column.
  • Delete - Delete the selected column and shift cells left.
    Note: If the Clear option is selected:

    • If Has Headers is True: clears the content and excludes the header.
    • If Has Headers is False: clears the entire column, including the header.

    If you want to remove the header as well, use the Delete option.

Output

• Range information - The updated range information, after the column is deleted, stored in a RangeInformation variable. Automatically generated output variable. You can use it as it is or save it with a different name.

Example

See also:

• Sheets activities
• Delete Rows
• Read Range