A group of actions: Excel
The action returns all values in the specified column or 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 |
| Column name | Name of the column to which the action will be applied. If the field is not filled, then the value from the «Column index» field is taken. | Robin.String | No | |
| Column index | Index of the column to which the action will be applied. | Robin.Numeric | No | |
| Range start line number | The line number in which the starting cell of the range is located. If the field is empty, then the first line of the used area is taken. | Robin.Numeric | No | |
| Range end line number | The line number in which the ending cell of the range is located. If the field is empty, then the ending line of the used area is taken. | Robin.Numeric | No | |
| Skip hidden cells | Return only visible cells. | Robin.Boolean | true | No |
| Skip empty cells | Return only filled cells. | Robin.Boolean | true | No |
| Results | ||||
| Result | The variable in which the values from the column will be written | Robin.Collection | ||
Обзор
Инструменты контента