Set cell value Version 9 (Net)
Action group: Excel
Description
The action sets the value to the specified cell.
Action 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 | The column of the cell to which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General" | String | No | |
Column index | The column index of the cell to which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General" | Numeric | No | |
Row of the cell | The cell row in which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General" | Numeric | Yes | |
Value | The value to be written to the selected cell | Object | Yes | |
Special conditions for use
If there is already data in the cell, it will be overwritten.
Example of use
Task
There is an Excel document in which values are written. It is required to set the value 23 in cell C4.
Solution
Use the actions "Open", "Set cell value", "Save".
Implementation
- Assemble a robot scheme consisting of actions:
- Customize the parameters for the "Open" action:
- Set the parameters for the "Set cell value" action:
- Set the parameters for the "Save" action:
- Launch the robot using the "Start" button in the top panel.
Result
The program robot completed successfully.
The value 23 is written in cell C4.
Обзор
Инструменты контента