Clear Range

Clears all content and formatting from a range of cells in the active sheet.

Common Properties

• Name - The custom name of the node.
• Color - The custom color of the node.
• Delay Before (sec) - Waits in seconds before executing the node.
• Delay After (sec) - Waits in seconds after executing the node.
• Continue On Error - Automation will continue regardless of any error. The default value is false.

info

If ContinueOnError property is true, no error is caught when the project is executed even if the Catch node is used.

Input

• File Descriptor - File descriptor of the Excel file. This is the identifier returned by the Open Excel node.
• From Cell - Starting cell of the range (e.g., A1). Required when Range is "Specific-Range".
• To Cell - Ending cell of the range (e.g., C10). Required when Range is "Specific-Range".

Output

This node has no output.

Options

• Range - Whether to clear all used cells or a specific range:
  • Specific-Range - Clear a specific range (requires From Cell and To Cell)
  • All-Range - Clear all cells with data in the active sheet

Example

Clearing a specific range:

// File Descriptor: message.excel_fd
// From Cell: "A1"
// To Cell: "D10"
// Range: Specific-Range
// Clears cells A1 through D10

Clearing all data in the sheet:

// Range: All-Range
// Clears all cells with data in the active sheet

Clearing temporary data:

// From Cell: "F1"
// To Cell: "H20"
// Range: Specific-Range
// Useful for clearing calculated or temporary columns

Tips

• This operation clears both content and formatting (colors, borders, fonts, etc.).
• The cells remain in the worksheet structure (they're not deleted).
• Use this when you want to reset a range before writing new data.
• For clearing an entire sheet by name, use Clear Sheet.
• All-Range only clears the "used range" - cells that have or had data.

Common Errors

Error	Solution
From Cell cannot be empty when Range is Specific-Range	Provide a starting cell address
To Cell cannot be empty when Range is Specific-Range	Provide an ending cell address
Range must be selected	Choose either Specific-Range or All-Range
Invalid File Descriptor	Ensure the Open Excel node was executed first