Switch Sheet
AutomatR.Excel.Activities.SwitchSheet
The "Switch Sheet" activity in AutomatR is part of the Excel activities package, allowing users to switch to another sheet within the same Excel workbook. This activity is useful for navigating between different sheets when working on complex Excel automation workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| Switch To Sheet | Enter the name of the sheet to switch to in the current Excel workbook. String variables containing the desired sheet name, e.g., "Sheet3". |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example: 5 seconds i.e., 5) to start the activity. Integer variables containing the delay duration. |
How to use:
- Drag and drop the "Switch Sheet" activity onto the workflow.
- Configure the properties by specifying the sheet name to switch to within the current Excel workbook.
- Optionally, configure the delay.
- Execute the workflow to switch to the specified sheet.
Important:
- Ensure that the Excel workbook is open and accessible.
- The specified sheet name should be valid; otherwise, the activity will not switch to the desired sheet.