Rename Sheet
AutomatR.Excel.Activities.RenameSheet
The "Rename Sheet" activity in AutomatR is part of the Excel activities package, designed to rename an Excel sheet to a specified name. This activity is useful for organizing and customizing the sheet names within an Excel workbook.
Properties
| Name | Description |
|---|---|
| Input | |
| New Sheet Name | Enter the name of the new sheet. String variables containing the desired name for the sheet. |
| 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 "Rename Sheet" activity onto the workflow.
- Configure the properties by specifying the new name for the sheet.
- Optionally, configure the delay.
- Execute the workflow to rename the Excel sheet to the specified name.
Example: Consider an example where the "Rename Sheet" activity is used to rename the current sheet to "SalesData":
Rename Sheet:
New Sheet Name: "SalesData"
In this example, the activity renames the current Excel sheet to "SalesData."
Important:
- Ensure that the specified sheet name is unique within the workbook.
- Be cautious while using this activity, as it permanently changes the name of the sheet.