Paste row Version 1 (Python)

Action group: Office

Description

The action inserts a new line before the specified line.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with ods/xlsx table.Robin.OpenSheetD oc
Yes
Row indexThe row number before which the new row will be pasted. The numbering starts from 1.Robin.Numeric
Yes
ValuesValues for the new row.Robin.Collection
No

Special conditions of use

None.

Example of use

Task

There is a tabular document. It is necessary to insert a row with data after the last row in the table.

Solution

Use the actions "Open", "Paste line", "Save". 

Implementation

  1. Assemble a robot scheme consisting of actions:

2. Set parameters for the "Open" action. In the "File path" field specify the path to the required tabular document "Test 1".

3. Set the parameters for the "Paste row" action. 

    1. specify the context of the opened document "Test 1" in the "Context" field;
    2. in the "Row index" field specify the index of the line where the line with values will be inserted;
    3. in the "Values" field specify the data that will be in the new line.



4. Set the parameters of the "Save" action. In the "Context" field specify the context of the opened document "Test 1".

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

Result

The program robot completed successfully.

A new row has been added to the table.