История страницы
Clear cell Version 9 (Net)
Action group: Excel
...
Description
The action removes a value from the specified cell.
Icon
Settings of parameters
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
Parameters | ||||
Context | Action context for working with an Excel document | Excel instance | Excel context | Yes |
Column of the cell | Name of the column in which the data will be cleared. If the field is not filled in, the value from the "Column index" field is taken. | String | No | |
Column index | The index of the column in which the data will be cleared. Indexing starts from 0. If the "Column of the cell" field is filled in, the value in the "Column index" field is ignored. The default value is "0". | Numeric | No | |
Row of the cell | The index of the row in which the data will be cleared. Indexing starts from 0 | Numeric | Yes |
...
- Assemble a robot scheme consisting of the actions:
- Customize parameters for the "Open" action:
- Customize the parameters for the "Clear cell" action:
- Customize parameters for the "Save" action:
- Launch the robot using the "Start" button in the top panel.
Result:
The program robot completed successfully.
...