Worksheet Exists
Description
The Worksheet Exists activity determines whether a worksheet exists within an Excel workbook.
The worksheet can be identified by name or by worksheet index.
This activity is commonly used before worksheet operations such as creating, renaming, deleting, or reading worksheet data.
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 check.
The worksheet can be identified using either a worksheet name or a worksheet index.
Learn more → Excel Worksheet Selection
Behavior
The activity checks whether the specified worksheet exists within the workbook.
A worksheet is considered to exist when:
- A worksheet with the specified name is found.
- A worksheet exists at the specified worksheet index.
Outputs
Sheet Exists
Returns True when the specified worksheet exists.
Returns False when the worksheet cannot be found.
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.