Delete Rows

Description

This activity deletes the specified row(s) from the specified Sheet. You can specify a single row or a range of rows to be deleted.

note

This activity works only inside Google Context activity.

Properties

• Delete - Specify one of the following options.

  Option	Description
  Single	Delete a single row located by Row Address property.
  Multiple	Delete range of rows specified by From and To addresses.

• Row Address - Specify either the row address or cell address to delete a single row in that address.

• From - Specify the starting address of the range. The address can be either a row address or a cell address. It is a mandatory field if Multiple Rows are selected.

• To - Specify the ending address of the range. The address can be either a row address or a cell address. It is a mandatory field if Multiple Rows is selected.

Location

• Spreadsheet Path / Id - Specify the relative spreadsheet path or Id inside Google Drive.

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 name of the Sheet in which you want to delete the row. 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