Delete Row

Deletes or clears a row at the specified position 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.
Row Number - Row number to delete or clear (1-based index).

This node has no output.

Clear - Determines the deletion behavior. Default is false.
- false - Deletes the entire row (rows below shift up)
- true - Clears the row content only (row structure remains, cells are emptied)

Deleting a row (shifts rows up):

// File Descriptor: message.excel_fd
// Row Number: 5
// Clear: false
// Row 5 is deleted, rows 6 and below shift up

Clearing a row (keeps row structure):

// Row Number: 3
// Clear: true
// Row 3 is emptied but remains in place

Removing header row:

// Row Number: 1
// Clear: false
// Deletes the first row

Clearing multiple rows:

// Loop through rows to clear
// Row Number: message.row_index
// Clear: true

When Clear is false, the row is completely removed and rows below shift up.
When Clear is true, only the content and formatting are removed; the row structure stays.
Use Clear: false to remove unwanted rows and compact your data.
Use Clear: true to reset a row for reuse while maintaining the structure.
Row indices are 1-based (row 1 is the first row).
Be careful when deleting rows in loops - indices change as rows are deleted.

Error	Solution
Row Number must be greater than 0	Provide a valid row number (1 or higher)
Invalid File Descriptor	Ensure the Open Excel node was executed first