Add Delete Columns

UiPath.GSuite.Activities.AddDeleteColumns

Description

Adds blank columns or removes existing columns from a specified sheet.

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

Properties

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

• ColumnName - The name of the column that you want to add or delete. This property supports String variables and string formatted values.
  • You specify the column by the column name (A, AC) or the column index (1, 10). The column index is required when mathematical operations are required to identify the column.
• ColumnPosition - The position where you want to add the column, or the position of the column that you want to delete. This property supports Int32 variables and Int32 formatted values.
• NumberOfItems - The number of columns that you want to add or delete. This property supports Int32 variables and Int32 formatted values.
• SheetName - The name of the sheet that you want to add column to or delete columns from. This property supports String variables and string formatted values. The default value is "New Sheet".
• SpreadSheetID - The ID of the spreadsheet that you want to add or delete columns. 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 Copy File activity.

Options

• ChangeMode - Specifies whether you want to add or delete columns. Select from two options: INSERT or DELETE.

Misc

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