Skip to main content

Delete Columns

Description​

This activity deletes the entire column or set of columns. You can either specify a column to delete or select the range of columns to be deleted from the Sheet.

note

This activity works only inside Google Context activity.

Properties​

  • Delete - Specify one of the following options.

    OptionDescription
    SingleDelete a single column located by Column Address property.
    MultipleDelete range of columns specified by From and To addresses.

  • Column Address - Specify either the column address or cell address to delete the column in that address.

  • From - Specify the starting address of the range. An address can be either a column address or a cell address. It is required only if Multiple Columns is selected.

  • To - Specify the ending address of the range. An address can be either a column address or a cell address. It is required only if Multiple Columns is selected.

Location​

Misc​

  • DisplayName – Add a display name to your activity.
  • Private – Logs the variable and argument values at the Verbose level when unchecked.

Optional​

  • Sheet Name - Specify the Sheet's name where you want to delete the column. By default, it operates on the current active Sheet.
  • Continue On Error – Specifies if the automation should continue even when the Activity throws an error. This field only supports Boolean values (True, False). The default value is False.
    note

    Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

Output​

  • Result - Returns the boolean(true or false) value indicating whether the deletion was successful or not.

Example​

Download Example

Delete Columns