Skip to main content
Version: Current

Clear Cells

Description​

The Clear Cells activity removes cell contents, formatting, comments, hyperlinks, or a combination of these elements from one or more cells within a worksheet.

This activity can be used to reset worksheet data while preserving the surrounding worksheet structure.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design-Time Configuration​

Workbook Configuration​

This activity requires an Excel workbook.

Learn more → Excel Workbook Configuration

Worksheet Selection​

This activity operates on a worksheet within the workbook.

Learn more → Excel Worksheet Selection

Worksheet Data Selection​

This activity targets specific cells within a worksheet.

Learn more → Worksheet Data Selection

Cells​

Cell address, range address, or comma-separated list of cell and range addresses to clear.

Examples:

  • A1
  • A1:B10
  • A1,C5,D10
  • A1:B5,D10:F20

Formats​

Determines whether cell formatting is removed.

When enabled, formatting such as fonts, colors, borders, number formats, and alignment settings are cleared.

Default value is False.

Contents​

Determines whether cell values and formulas are removed.

Default value is True.

Comments​

Determines whether cell comments are removed.

Default value is False.

Determines whether hyperlinks are removed from the selected cells.

Default value is False.

Behavior​

At least one of the following options should be enabled:

  • Contents
  • Formats
  • Comments
  • Hyperlinks

When multiple options are enabled, all selected cell properties are cleared during a single operation.

Outputs​

This activity does not produce any activity-specific outputs.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when any incoming path completes, or only after all relevant paths have completed.

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include Fault, Continue, Suspend, and Retry.

Learn more → Error Handling