A group of actions: Excel
The action calculates the value in the selected cell using the formula. By default, formulas are in English. You can view the names of functions on the official website: https://support.office.com/en-gb/article/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb . To use a local (in our case, Russian) language, you must make a note in the «Local language» field.
Action icon
Settings
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Column of the cell | Column of the cell into which the result of the calculation by the formula will be written. | Robin.String | Yes | |
| Row of the cell | Row of the cell into which the result of the calculation by the formula will be written. | Robin.Numeric | Yes | |
| Formula | The formula by which the calculation will be performed in the cell. The formula starts with the «=» symbol. | Robin.String | Yes | |
| Local language | If the parameter value is True, then the names of the formulas will be given in the local language, otherwise - in English. | Robin.Boolean | true | No |
Обзор
Инструменты контента