Set row values Version 2 (Python)

Action group: Office

Description

The action sequentially fills the cells of the given row with values from the given 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
Row numberRow number where the values will be set. Numbering starts from 1.Robin.Numeric
Yes
Start column nameThe name of the column from which the values will be set. If the field is empty, then the value is taken from the field “Initial column number.Robin.String
No
Start column numberThe number of the column from which the value will be set. Numbering starts from 1. If the field is not filled, then the value is taken from the field «Name of the initial column».Robin.Numeric
No
List of valuesA list of values that will fill the cells in the row.Robin.Collection
Yes

Special conditions of use

None.

Example of use

Task

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

Solution

Use the actions "Open", "Set row 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 row 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.