Сравнение версий

Ключ

  • Эта строка добавлена.
  • Эта строка удалена.
  • Изменено форматирование.

...

The action copies the sheet to the specified document. 

Action icon 

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

Settings of parameters

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

Special conditions of use

...

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. 

...