Delete Worksheet
Description
The Delete Worksheet activity removes a worksheet from an Excel workbook.
The selected worksheet and all of its contents, formatting, formulas, and worksheet-level settings are permanently removed from the workbook.
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
Selects the worksheet to delete.
Learn more → Excel Worksheet Selection
Behavior
When a worksheet is deleted:
- The worksheet is permanently removed from the workbook.
- All data, formulas, formatting, charts, and worksheet-level settings contained within the worksheet are removed.
- Remaining worksheets retain their existing order, except that worksheet indexes may change after the deletion.
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.