Copy range to clipboard Version 9 (Net)

Action group: Excel 

Description

Saves values from the specified area.

Icon

Settings of parameters

Property

Description

Type

Example of filling in

Obligatory to fill in the field

Parameters

Context

Action context for working with an Excel document

Excel instance

Excel context

Yes

Start cell column name

The column name of the initial cell (the beginning of the range) from which the area to be copied will be set. If the field is not filled in, the value from the "Start cell column index" field is taken.

String


No

Start cell column index

Column index of the initial cell (beginning of the range) from which the area to be copied will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

Start cell row

String of the initial cell (beginning of the range) from which the copied area will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

End cell column name

The column name of the end cell (end of range) to which the area to be copied will be set. If the field is not filled in, the value from the "End cell column index" field is taken.

String


No

End cell column index

The column index of the end cell (end of range) to which the area to be copied will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

End cell row

String of the end cell (end of range) to which the area to be copied will be set. If the field is not filled in, the boundary of the used area is taken.

Numeric


No

Skip hidden

Copy only visible cells.

Boolean

true

No

Special conditions of use

The "R1C1" reference style is not supported.

Example of use

Task

There is an Excel document "Test" with a table:

 image2024-1-16_16-44-16.png

It is necessary to copy this table to the buffer and paste it two rows below, starting from cell A7. 

Solution 

Use the actions "Open", "Copy range to clipboard", "Copy range from clipboard", "Save". 

Implementation

  1. Assemble a robot scheme consisting of the actions:
    image2024-1-16_16-45-2.png

  2. Fill in the parameters for the "Open" action. In the "Path to file" field, specify the path to the required Excel file. Check the Visible = true checkbox to display robot actions on the screen. 
    image2024-1-16_16-45-15.png

  3. Fill in the parameter for the "Copy range to clipboard" action. Do not fill in the other fields, as it is necessary to copy the table completely.
    image2024-1-16_16-45-37.png 

  4. Fill in the parameters for the "Paste range from clipboard" action. 
    image2024-1-16_16-45-55.png

  5. Fill in the parameter for the "Save" action. In the "Context" parameter specify the context of the Excel document. 
    image2024-1-16_16-46-11.png

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

Result

The program robot completed successfully.

image2024-1-16_16-51-13.png

The table is copied and pasted starting in cell A7. 

image2024-1-16_16-50-42.png