Sort_

A group of actions: Excel

The action sorts table by column.

Action icon

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Action context for working with an Excel document	Robin.Excel	Excel context	Yes
Column	Column name to be sorted. If the column is unspecified, sorting will be performed in the first column of the used range.	Robin.String		No
Start cell	Start cell address from which the sorting range will be set. Fill-in format: «ХY» where «X» is column name and «Y» is row index	Robin.String		No
End cell	Destination cell address to which the sorting range will be set. Fill-in format: «ХY» where «X» is column name and «Y» is row index	Robin.String		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