Paste range from clipboard Version 1 (Python)

Action group: Office

Description

Action inserts a range of cells from the clipboard

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for ods/xlsx documentRobin.OpenSheetD oc
Yes
Start cellThe address of the starting cell where the range will be inserted. The default is A1. Fill in the format «XY», where «X» is the column number and «Y» is the line number.Robin.String
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. 


  • Нет меток