История страницы
Set cell value Version 9 (
...
Net)
Action group: Excel
...
Description
The action sets the value to the specified cell.
Action icon
Parameters
Input parameters
- Context - The context of the action for working with an Excel document.
- 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". For example C.
- 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".
- Row of the cell - 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". For example: 4.
- Value - The value that will be written to the selected cell. For example: 23.
...
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 |
...