Action group: Office
Action renames the specified sheet
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with ods/xlsx table. | Robin.OpenSheetD oc | Yes | |
| Identification method | Select the way to identify the sheet to be renamed: by name or index. | Robin.String | Yes | |
| Sheet name | Name of the sheet to which the action will be applied. If the parameter indicates a hidden sheet, the action will fail. | Robin.String | No | |
| Sheet index | The sequence number of the sheet to which the action will be applied. The numbering starts from 1. If the parameter indicates a hidden sheet, the action will fail. | Robin.Numeric | No | |
| New sheet name | New name of the sheet. The name must not exceed 31 characters in length, contain «:», «/», » «, «? «, «*», «[» and «]», otherwise the action will fail. | Robin.String | Yes | |
None.
It is necessary to rename the first sheet of the tabular document "Test 1" to "New sheet"
Use the actions "Open", "Rename sheet", "Save".
Assemble a robot scheme consisting of actions:
Set the "Open" action parameter.
Set the parameters of the "Rename sheet" action.
Set the "Save" action parameter.
Launch the robot using the "Start" button in the top panel.
The program robot completed successfully. The sheet has been renamed.
In the "Test 1" document, "Sheet 1" has been renamed "New sheet".
