A group of actions: Excel

The action sorts table by column.

Action icon

Settings

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
ContextAction context for working with an Excel documentRobin.ExcelExcel contextYes
Start cell column nameThe column name of the starting cell (start of the range) from which the sorting range will be set. If the field is not filled, then the value from the «Start cell column index» field is taken.Robin.String No
Start cell column indexThe column index of the starting cell (start of the range) from which the sorting range will be set. If the field is not filled, then the border of the used area is taken.Robin.Numeric No
Start cell rowRow of the starting cell from which the sorting range will be set.Robin.Numeric No
End cell column nameThe column name of the ending cell (end of range) to which the sorting range will be set. If the field is not filled, then the value from the «End cell column index» field is taken.Robin.String No
End cell column indexThe column index of the ending cell (end of range) to which the sorting range will be set. If the field is not filled, then the border of the used area is taken.Robin.Numeric No
End cell rowRow of the ending cell to which the sorting range will be set.Robin.Numeric No
OrderSorting 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
  • Нет меток