Delete Cells

Description

This activity deletes the cell(s) from the specified address or range in the specified Sheet.

note

This activity works only inside Google Context activity.

Properties

• Delete - Specify one of the following options.

  Option	Description
  Single	Delete a single cell at the specified Cell Address property.
  Multiple	Delete range of cells specified by From and To addresses.

• Cell Address - Specify the address of the cell.

• From - Specify the starting address of the range. An address can be a cell address. Required if Multiple Cells is selected.

• To - Specify the ending address of the range. An address can be a cell address. Required if Multiple Cells 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 Sheet name in which you want to delete cells. By default, it will operate on the current active Sheet.

• Shift Cells - You can select one of the following options.

  Option	Description
  Up	The cells will be shifted upwards to replace the deleted cells.
  Left	The cells will be shifted toward the left to replace the deleted cells.

• 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