Set column values Version 2 (Python)

Action group: Office

Description

The action sequentially fills the cells of the column with values from the specified list, starting from some starting cell of the column

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for ods/xlsx documentRobin.OpenSheetD oc
Yes
Column nameThe name of the column in which the values will be set. If the field is empty, then the value is taken from the field «Column number».Robin.String
No
Column numberThe number of the column to which the action will be applied. Numbering starts from 1. If the field is empty, then the value is taken from the «Column name» field.Robin.Numeric
No
Start line numberThe row number, starting from which the values in the cells of the column will be filled. Numbering starts from 1Robin.Numeric
Yes
Cell valuesA list of values that will fill the cells in the column.Robin.Collection
Yes

Special conditions of use

None.

Example of use

Task

Set the values of column A starting from row 2 in the table. The values of the variable "Collection" = "Irina, Ivan, Ilya". Save the document under the name "New". 

Solution

Use the actions "Open", "Set column values", "Save".

Implementation

  1. Assemble a robot scheme consisting of actions:

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

  3. Set the parameters for the "Set column values" action. 

  4. Set the parameters for the "Save" action. 

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

Result

The program robot completed successfully.

 

The values are set in the table.