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. If the field is empty, the value from the «Column index» field is taken. | Robin.String | No | |
| Column index | Column index of the cell into which the result of the calculation by the formula will be written. | Robin.Numeric | No | |
| 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 |
| Register | If the parameter value is „True“, then the formula bar remains unchanged. If „False“, then all letters in the formula are capitalized. The default is „False“. | Robin.Boolean | true | No |
Обзор
Инструменты контента