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
Use Sheet Reference, where provided, to choose By Name or By Index. Only the fields for that selection mode determine the target.
- By Name: supply Sheet Name. Leaving the name empty uses the workbook's active worksheet.
- By Index: supply the zero-based Sheet Index. Index
0identifies the first worksheet.
Select the mode explicitly rather than supplying both fields and relying on precedence. Worksheet indexes can change when sheets are added, moved, or deleted; use names when the worksheet's identity should remain stable.
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.