A group of actions: Excel
Action helps to execute the formula in the selected range in an Excel document.
Settings
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Start row | The number of the line starting from which the formula will be applied. | Robin.Numeric | No | |
| Start column name | The name of the column starting from which the formula will be applied. If the field is not filled in, then the value is taken from the «Start column index» field. | Robin.String | No | |
| Start column index | The index of the column starting from which the formula will be applied. If the field is not filled in, the initial boundary of the used area will be taken. | Robin.Numeric | No | |
| End row | The number of the line to which the formula will be applied. | Robin.Numeric | No | |
| End column name | The name of the column to which the formula will be applied. If the field is not filled in, then the value is taken from the «End column index» field. | Robin.String | No | |
| End column index | Index of the column to which the formula will be applied. If the field is not filled in, the final boundary of the used area will be taken. | Robin.Numeric | No | |
| Formula | The formula by which the calculation will be performed in the range. The formula starts with the «=» symbol. | Robin.String | Yes | |
| Local language | If the value is «true», then the formula will be read in the local language, otherwise – in English. | Robin.Boolean | true | No |
| Register | If the value is «true», then the formula remains unchanged, otherwise all letters will become uppercase. | Robin.Boolean | true | No |
| Skip hidden | If the value is «true», then the formula will not be applied to the hidden cells. | Robin.Boolean | true | No |
Обзор
Инструменты контента