Skip to main content

Clear Cells

Description​

Clears formats, contents, comments, hyperlinks of the specified cell(s)

Properties​

Input​

  • Cells – The Excel cell or range of cells or comma separated cells that you want to clear.
  • Spreadsheet – The spreadsheet in which the cell(s) need to be cleared

Optional​

  • 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: If this activity is included in Try Catch and the value of this property is True, no error is caught when the project is executed.

  • Sheet Name – The name of the spreadsheet in which you want to clear. By default, the operation will be performed on the current active Spreadsheet.

Misc​

  • DisplayName – Add a display name to your activity.
  • Private – By default, activity will log the values of your properties inside your workflow. If private is selected, then it stops logging.

Example​

Download Example

State