Get Worksheets
Description
The Get Worksheets activity retrieves the names of all worksheets contained within an Excel workbook.
This activity is commonly used to inspect workbook structure, validate worksheet existence, or dynamically select worksheets during workflow execution.
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
Outputs
Sheets
Returns a collection containing the names of all worksheets in the workbook.
Example:
Sheet1
Customers
Orders
Summary
The worksheet names are returned in the same order they appear within the workbook.
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.