Skip to main content

Delete Row

Deletes one or more rows from an Excel worksheet. Rows below the deleted range shift up.

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 node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.

Input​

  • Client Id - The client ID from the Connect node (optional if using direct credentials).
  • Workbook Id - The workbook ID from Get Workbook or Create Workbook node.
  • Worksheet Name - Name of the worksheet. Default is "Sheet1".
  • Row Index - Row number to delete (1-based).

Options​

  • Credentials - OAuth2 credentials (optional, alternative to using Client ID).
  • Delete Count - Number of rows to delete starting from Row Index. Default is 1.

Output​

  • Success - True if rows were deleted successfully.
  • Deleted Row Index - Starting row index that was deleted.
  • Rows Deleted - Total number of rows deleted.

Examples​

Delete Single Row:

// Input
Row Index: 5
Delete Count: 1

// Deletes row 5
// Previous row 6 becomes new row 5

Use Cases​

  • Remove unwanted data rows
  • Clean up worksheets
  • Delete header or footer rows
  • Remove duplicate or invalid data rows

Tips​

  • Deletion is permanent
  • Rows below shift up automatically
  • Formulas referencing deleted rows may need updating

Common Errors​

ErrInvalidArg - "Row Index must be greater than 0"

  • Solution: Provide a valid row index (1 or greater)