A group of actions: Excel
The action sorts table by column.
Settings
Property | Description | Type | Filling example | Mandatory field |
Parameters | ||||
Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
Start cell column | Column of the starting cell from which the sorting range will be set. | Robin.String | No | |
Start cell row | Row of the starting cell from which the sorting range will be set. | Robin.Numeric | No | |
End cell column | Column of the ending cell to which the sorting range will be set. | Robin.String | No | |
End cell row | Row of the ending cell to which the sorting range will be set. | Robin.Numeric | No | |
Order | Sorting order. Only the data included in the range is reordered. The order of data in the table that was not included in the sort range does not change. If the specified range (the «Range Beginning» and «Range End» fields) contains data of one column (for example, from «A1» to «A10»), then the data sorting occurs only within this column and the specified range of rows - the «Column» parameter has no effect on sorting. If the specified range (the «Range Beginning» and «Range End» fields) contains data in two or more columns (for example, from «A1» to «C10»), then the data is sorted by the column specified in the «Column» parameter. If the «Column» parameter is empty, then the sorting goes by the first column in the range. | Robin.String | No |
Обзор
Инструменты контента