Copy range to clipboard Version 1 (Python)

Action group: Office

Description

The action copies values from the specified area to the clipboard

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for ods/xlsx documentRobin.OpenSheetD oc
Yes
Start cell columnThe column of the starting cell (the beginning of the range), from which the copied area will be set. If the field is empty, then the border of the used area is takenRobin.String
No
Start cell rowThe string of the starting cell (beginning of the range) from which the copied area will be set. If the field is empty, then the border of the used area is takenRobin.Numeric
No
Destination cell columnDestination cell column (end of range) to which the copied area will be set. If the field is empty, then the border of the used area is takenRobin.String
No
End cell rowThe string of the end cell (end of the range) to which the copied area will be set. If the field is empty, then the border of the used area is takenRobin.Numeric
No

Special conditions of use

None.

Example of use

Task

There is an Excel document “Test” with a table.

 

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

Solution

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

Implementation

  1. Assemble a robot scheme consisting of actions:

  2. Set the "Path to file" parameter for the "Open" action. 

      

  3. Set the "Context" parameter for the "Copy range to clipboard" action. Do not fill in the other fields, as it is necessary to copy the table completely.
     
  4. Set the parameters for the "Paste range from clipboard" action. Set the "Context" parameter, as well as specify the initial cell for data insertion. (А7)
  5. Set the "Context" parameter for the "Save" action.  In the "Context" parameter specify the context of the Excel document. 
  6. Launch the robot using the "Start" button in the top panel.

Result

The program robot completed successfully.

The table is copied and pasted starting in cell A7.