История страницы

Copy sheet Version 3 (Net)

Action group: Excel

...

Description

The action copies the sheet to the specified document. 

Action icon 

...

Image Added

Settings of parameters

Image Removed

Parameters

Input parameters    

1. Source context - The context of the file from which the sheet will be taken.
   

2. Target context - The context of the file where the sheet will be inserted. If this parameter is not selected, the source context file will be taken.
   

3. Sheet identification method - The parameter specifies the method of sheet identification: via name or index. For example: Via sheet name.
   

4. Sheet name - The name of the sheet to which the action will be applied. For example: Sheet to copy.

5. Sheet index - The sequence number of the sheet to which the action will be applied. The sequence number starts with "1".

6. Copied sheet name - The sheet name that will be assigned to the copied sheet. For example: New_Sheet.
   

Settings

Special conditions of use

None 

Example of use

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". 

...

1. 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.

4. Customize the "Save" action parameter.

...

5. Launch the robot using the "Start" button in the top panel.

Optional. To copy an Excel sheet into another Excel document, you must link the documents before doing so. 

...

The software robot completed successfully. The copied sheet "New 1" has been added to the document.