Copy sheet

Copy sheet Version 3 (Net)

Action group: Excel

The action copies the sheet to the specified document.

Property	Description	Type	Example of filling in	Obligatory to fill in the field
Parameters
Source context	The context of the file from which the sheet will be taken.	Excel instance	Excel instance	Yes
Target context	The context of the file where the sheet will be inserted. If not selected, the source context file will be taken.	Excel instance	Excel instance	No
Sheet identification method	Parameter specifies the method of sheet identification: via name or index	String		Yes
Sheet name	The name of the sheet to which the action will be applied.	String		No
Sheet index	The sequence number of the sheet to which the action will be applied. The sequence number starts with "1".	Numeric		No
Copied sheet name	The sheet name that will be assigned to the copied sheet.	String		No

None

Task

There is an Excel document with a sheet "To copy". You need to copy this sheet and create the same one in the same document, but with the name "New".

Solution

Use the actions "Open", "Copy sheet", "Save".

Implementation

Собрать схему робота, состоящую из действий:
Set the parameters of the "Open" action.
1. Specify in the "PathToFile" field the path to the required file.
2. In the "Open Visible" field specify checkbox = true.
Customize the parameters of the "Copy sheet" action.

1. In the "Source context" field specify the context of the open document.
2. In the "Sheet identification method" field specify the value "via sheet name"
3. In the "Sheet name" field specify the value of the sheet to be copied.
4. In the "Copy sheet name" field specify the name of the new sheet.