Cell clear Version 1 (Python)
Action group: Office
Description
The action removes a value from the specified cell.
Action icon
Settings of parameters
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for ods/xlsx document | Robin.OpenSheetD oc | Yes | |
| Column of the cell | Cell column whose value will be cleared | Robin.String | Yes | |
| Row of the cell | Cell column whose value will be cleared | Robin.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
- Assemble a robot scheme consisting of actions:
Set the "Path to file" parameter for the "Open" action.
- 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.
- Set the Context parameter for the Save action:
- 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.
Обзор
Инструменты контента