История страницы
...
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 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 name must not exceed 31 characters in length, contain ":", "/", "\", "?", "*", "[" and "]", otherwise the action will fail. | String | Yes | |
...
- a parameter indicates a hidden sheet;
- non-existent data for sheet identification is entered;
- an incorrect "New sheet name" is entered.
- Sheet names must not be empty, must not exceed 31 characters and must not contain colons, slashes, question marks, asterisks and square brackets.
...
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".
...
Обзор
Инструменты контента