Excel Worksheet Selection
Many Excel activities operate on a specific worksheet within a workbook.
When required, the target worksheet can be identified using either a worksheet name or worksheet index.
Sheet Name
Optional name of the worksheet to use.
When specified, the activity locates the worksheet by name.
Worksheet names must exist in the workbook at runtime unless the activity explicitly creates a new worksheet.
Sheet names are not case-sensitive.
Sheet Index
Optional zero-based position of the worksheet within the workbook.
For example:
| Index | Worksheet |
|---|---|
| 0 | First worksheet |
| 1 | Second worksheet |
| 2 | Third worksheet |
When specified, the activity locates the worksheet based on its position within the workbook.
Worksheet Selection Behavior
When both Sheet Name and Sheet Index are provided, Sheet Name takes precedence.
This ensures the activity targets the intended worksheet even if worksheet positions change.
Activity-specific behavior applies when neither value is provided.
Process Data Support
Sheet names and sheet indexes can be configured dynamically using variables from the Process Data drawer.
This allows workflows to select worksheets based on runtime conditions, user input, or outputs from previous activities.