Add sheet Version 1 (Python)
Action group: Office
Description
The action adds a new sheet to the document
Action icon
Settings of parameters
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for ods/xlsx document | Robin.OpenSheetD oc | Yes | |
| New sheet name | The name of the new sheet to be created. It will be added after the active one. The new sheet will become the active sheet | Robin.String | No | |
Special conditions of use
None.
Example of use
Task
There is a document called Test with one sheet - Sheet 1. You need to add a new sheet and name it Sheet 2.
Solution
Use the actions "Open", "Add sheet", "Save".
Implementation
- Assemble a robot scheme consisting of actions:
Set the "Path to file" parameter for the "Open" action.
- Set parameters for the "Add sheet" action. In the "Context" field specify the open context of the document, in the "New sheet name" field the value "Sheet 2".
- Set the parameter 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.
Result
The program robot completed successfully.
A new sheet named "Sheet 2" has been successfully added to the document.
Обзор
Инструменты контента