Skip to main content

Delete Cell

Deletes a specific cell or range of cells from an Excel worksheet, shifting surrounding cells.

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".
  • Cell Address - Cell or range address to delete (e.g., A1, B2:C5).

Options​

  • Credentials - OAuth2 credentials (optional, alternative to using Client ID).
  • Shift Direction - Direction to shift cells: "Up" or "Left". Default is "Up".

Output​

  • Success - True if the cell was deleted successfully.
  • Deleted Cell - The cell address that was deleted.

Examples​

Delete Single Cell:

// Input
Cell Address: "B5"
Shift Direction: "Up"

// Deletes B5, cells below shift up

Use Cases​

  • Remove specific data points
  • Delete cells while preserving structure
  • Clean up individual cells

Common Errors​

ErrInvalidArg - "Cell address cannot be empty"

  • Solution: Provide a valid cell address