История страницы
Rename sheet
Action group: Excel
...
Description
The action allows you to rename a sheet in Excel.
Icon
Settings
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
|---|---|---|---|---|
Parameters | ||||
| Context | Action context for working with Excel documents | Excel instance | EXCEL_INSTANCE | Yes |
Sheet identification method | A dropdown drop-down list of elements: "Via sheet name", "Via sheet index" Selects whether to identify the sheet to be renamed by name or by index | 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 cause an error. | String | No | |
Sheet index | The sequence number of the sheet to which the action will be applied. The numbering starts with "1". If the parameter indicates a hidden sheet, the action will cause an error. | Numeric | No | |
New sheet name | The new name of the sheet. The The name must not exceed 31 characters in length, contain ":", "/", "\", "?", "*", "[" and "]", otherwise the action will fail. | String | Yes | |
Special conditions of use
The robot will return an error if:
...
If the user enters values in both fields "Sheet name" and "Sheet index", the robot will not generate an error. The selection will be made in the way specified in "Sheet identification method".
Example of use
Task: you need to rename the first sheet in an Excel document to "New sheet".
Solution: use the actions "Open", "Rename sheet", "Save".Solution: use the actions "Open", "Rename sheet", "Save".
...
- Assemble a robot scheme from the actions:
- Customize the "Open" action parameter.
- Customize the parameters of the "Rename sheet" action.
- Customize the "Save" action parameter.
- Launch the robot using the "Start" button in the top panel.
...
The first sheet in the document has been renamed.
Обзор
Инструменты контента