Delete Column
Description
The Delete Column activity removes an entire column from a worksheet in an Excel workbook.
All cells within the selected column are deleted, and the remaining columns are shifted to fill the gap.
Common Capabilities
Process Data Support
This activity supports dynamic configuration using variables from the Process Data drawer.
You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.
Learn more → Using Process Data
Design-Time Configuration
Workbook Configuration
This activity requires an Excel workbook.
Learn more → Excel Workbook Configuration
Worksheet Selection
This activity operates on a worksheet within the workbook.
Learn more → Excel Worksheet Selection
Column Selection
Selects the column to delete.
The column can be identified using either a column letter or a zero-based column index.
Learn more → Worksheet Data Selection
Column Index
Zero-based position of the column to delete.
For example:
| Index | Column |
|---|---|
| 0 | A |
| 1 | B |
| 2 | C |
Column Letter
Excel column identifier for the column to delete.
Examples:
- A
- B
- C
- AA
- AB
Column letters are not case-sensitive.
Behavior
When a column is deleted:
- All cells within the selected column are removed.
- Columns to the right shift left to fill the gap.
- Formulas and references within the workbook may be adjusted automatically by Excel.
Outputs
This activity does not produce any activity-specific outputs.
Wait All Incoming
Controls how this activity behaves when multiple incoming execution paths converge.
Determines whether the activity executes when any incoming path completes, or only after all relevant paths have completed.
Learn more → Execution Control
On Error
Defines how the workflow behaves if this activity encounters a runtime error.
Supported strategies include Fault, Continue, Suspend, and Retry.