Copy range to clipboard Version 1 (Python)

Action group: Office

Description

The action copies values from the specified area to the clipboard

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Action context for ods/xlsx document	Robin.OpenSheetD oc		Yes
Start cell column	The 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 taken	Robin.String		No
Start cell row	The 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 taken	Robin.Numeric		No
Destination cell column	Destination 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 taken	Robin.String		No
End cell row	The 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 taken	Robin.Numeric		No

None.

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.

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

Assemble a robot scheme consisting of actions:
Set the "Path to file" parameter for the "Open" action.
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.
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)
Set the "Context" parameter for the "Save" action. In the "Context" parameter specify the context of the Excel document.
Launch the robot using the "Start" button in the top panel.