Delete Cell

Deletes or clears a specific cell 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.

File Descriptor - File descriptor of the Excel file. This is the identifier returned by the Open Excel node.
Cell - Cell address to delete or clear (e.g., A1, B5, C10).

This node has no output.

Clear - Determines the deletion behavior. Default is true.
- true - Clears the cell content only (keeps the cell in place, removes value and formatting)
- false - Deletes the cell and shifts adjacent cells left

Clearing a cell (keeps cell structure):

// File Descriptor: message.excel_fd
// Cell: "A5"
// Clear: true
// The cell A5 is emptied but remains in place

Deleting a cell (shifts cells left):

// Cell: "B3"
// Clear: false
// The cell B3 is deleted, and cells to the right shift left

Clearing multiple cells:

// Loop through cell addresses
// Cell: message.cell_address
// Clear: true

Removing error values:

// Cell: "D10"
// Clear: true
// Removes #DIV/0! or other error values

Use Clear: true (default) when you want to empty the cell but maintain the worksheet structure.
Use Clear: false when you want to remove the cell entirely and shift adjacent cells.
When Clear is false, cells to the right shift left to fill the gap.
Clearing removes both the value and any formatting (like colors or borders).
For deleting entire rows or columns, use Delete Row or Delete Column.

Error	Solution
Cell cannot be empty	Provide a valid cell address (e.g., A1, B5)
Invalid File Descriptor	Ensure the Open Excel node was executed first
Invalid cell address	Use proper Excel cell notation (column letter + row number)