Paste column Version 1 (Python)

Action group: Version 

Description

The action inserts a new column to the left of the specified column.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with ods/xlsx table.Robin.OpenSheetD oc
Yes
Column nameThe name of the column before which you want to paste the new column. If the field is not filled in, the column will be determined by the value from the «Column index» field.Robin.String
No
Column indexThe ordinal number of the column to insert a new column before. The numbering starts from 1.Robin.Numeric
No
ValuesValues for the new column.Robin.Collection
No

Special conditions of use

None.

Example of use 

Task

There is a tabular document. It is necessary to insert a column with data on capitals to the right of the column with countries.

Solution

Use the actions "Open", "Paste column", "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 column" action. 
    1. in the "Context" field specify the context of the opened document "Test 1";
    2. in the "Column name" field specify the name of the column where the column with values will be inserted;
    3. in the "Values" field specify the data that will be in the new column.

  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.

The column has been added to the document.