История страницы
...
Sheet identification method Specifies Specifies whether the sheet will be defined via name or index the sheet to be defined
Sheet name The name of the sheet to which the action will be applied
...
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
---|---|---|---|---|
Parameters | ||||
Context | The unique identifier of the session to which the action will be applied. | Excel instance | EXCEL_INSTANCE | Yes |
Sheet identifier | Specifies whether the sheet will be defined via name or index. Dropdown Drop-down list:
After selecting the value of this field, the action will refer to either the value of the "Sheet name" field or the value of the "Sheet index" field. | String | Sheet index | Yes |
Sheet name | The name of the sheet to which the action will be applied. | String | Sheet1 | No |
Sheet index | The sequence number of the sheet to which the action will be applied. | Numeric | 1 | No |
...
- Assemble a robot scheme consisting of actions:
- Configure parameters for the "Open" action. In the "PathToFile" field, specify the path to the required Excel file. Check the "Open Visible" = true checkbox to display the robot actions on the screen.
- Customize parameters for the "Activate sheet" action. In the "Context" field specify the context of the opened document, in the "Sheet identification method" field specify " Via sheet name", in the "Sheet name" field specify the name of the sheet to be made active (in this case "Sheet3").
- Configure parameters for the "Save" action. Specify the context of the Excel document in the "Context" parameter.
- Launch the robot using the "Start" button in the top panel.
...
Обзор
Инструменты контента