Set cell value Version 1 (Python)

Action group: Office

Description

Action sets the value to the specified cell

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for ods/xlsx documentRobin.OpenSheetD oc
Yes
Column of the cellColumn of the cell where the value will be written. If there is already data in the cell, it will be overwritten.Robin.String
Yes
Row of the cellRow of the cell where the value will be written. If there is already data in the cell, it will be overwritten.Robin.Numeric
Yes
ValueThe value to be written to the selected cellRobin.Object
Yes

Special conditions of use

None.

Example of use

Task 

There is a file Book1.xlsx it is necessary to set the value in cell A3=test 4 and save the document.

Solution

Use the actions "Open", "Set cell value", "Save". 

Implementation

  1. Move the "Open" action to the workspace and set its parameters
    In the "Path to file" field specify the path to the file Book1.xlsx



  2. Move the "Set cell value" action to the workspace and fill in its parameters
    In the "Context" field, specify the context created in step 1.
    In the "Columnof the cell" field specify the value = A.
    In the "Row of the cell" field specify the value = 3. 
    In the "Value" field specify the value = test 4. 
  3. Move the "Save" action to the workspace and set its parameters
    Specify the context of the opened document in the "Context" field.



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

Result

The program robot completed successfully.

The required value is set in cell A3. The file is saved.