Cell clear Version 1 (Python)

Action group: Office

Description

The action removes a value from the specified cell.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for ods/xlsx documentRobin.OpenSheetD oc
Yes
Column of the cellCell column whose value will be clearedRobin.String
Yes
Row of the cellCell column whose value will be clearedRobin.Numeric
Yes

Special conditions of use

None.

Example of use

Task 

There is an Excel document with values in it. You need to clear the value in cell C3. 

Solution

Use the actions "Open", "Cell clear", "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 "Cell clear" action:
    In the Context field, specify the context of the open Excel document. 
    In the "Column of the cell" and "Row of the cell" fields, specify the values C and 3, respectively. 

  4. Set the Context parameter for the Save action: 
  5. Launch the robot using the "Start" button in the top panel.

Result

The program robot completed successfully.

The value from cell C3 has been cleared.