Skip to main content

Delete Column

Deletes one or more columns from an Excel worksheet. Columns to the right of the deleted range shift left.

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".
  • Column Letter - Column to delete (e.g., A, B, Z, AA).

Options​

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

Output​

  • Success - True if columns were deleted successfully.
  • Deleted Column - Column letter that was deleted.
  • Columns Deleted - Total number of columns deleted.

Examples​

Delete Single Column:

// Input
Column Letter: "C"

// Deletes column C
// Previous column D becomes new column C

Use Cases​

  • Remove unwanted data columns
  • Clean up worksheet structure
  • Delete calculated or temporary columns

Tips​

  • Deletion is permanent
  • Columns to the right shift left automatically

Common Errors​

ErrInvalidArg - "Workbook Id cannot be empty"

  • Solution: Ensure you've called Get Workbook first