Add Sheet
AutomatR.Excel.Activities.AddSheet
The "Add Sheet" activity in AutomatR is part of the Excel activities package, designed to add a new sheet to the specified Excel workbook. This activity enhances automation capabilities in Excel by facilitating the dynamic creation of sheets within the workbook.
Properties
| Name | Description |
|---|---|
| Input | |
| New Sheet | Specifies the name of the new sheet to be added to the existing workbook. It allows a string variable containing the desired sheet name. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Add Sheet" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Add Sheet" activity onto the workflow.
- Configure the properties by specifying the new sheet name.
- Optionally, configure the delay.
- Execute the workflow to add a new sheet to the Excel workbook.
Example: Consider an example where the "Add Sheet" activity is used to add a new sheet named "Sheet3" to the existing Excel workbook:
Add Sheet:
New Sheet: "Sheet3"
Delay: 2
In this example, the activity adds a new sheet named "Sheet3" to the existing Excel workbook. The optional delay is set to 2 seconds, providing time for any necessary synchronization.