A group of actions: Excel
The action returns all values in the working range of the specified page.
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 |
| Row | Row index from which the data will be received. If you enter a string outside the working range, the action will return an empty result. | Robin.Numeric | Yes | |
| Starting column name | Name of the column where the starting cell of the working range is located. If the field is not filled, then the value from the «Starting column index» field is taken. | Robin.String | No | |
| Starting column index | The index of the column where the starting cell of the working range is located. | Robin.Numeric | No | |
| Final column name | Name of the column that contains the end cell of the working range. If the field is not filled, then the value from the «Final column index» field is taken. | Robin.String | No | |
| Final column index | The index of the column that contains the end cell of the working range. | Robin.Numeric | No | |
| Skip hidden | Boolean variable. If the parameter value is True, then only visible cells are returned, otherwise - everything. | Robin.Boolean | true | No |
| Skip empty | Boolean variable. If the parameter value is True, then only filled cells are returned. | Robin.Boolean | true | No |
| Results | ||||
| Result | The variable in which the values from the row will be written | Robin.Collection | ||
Обзор
Инструменты контента