Action group: Excel Sort
Action icon
Version:
- 9 (net)
The action sorts the table by column
Settings
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
Parameters | ||||
Context | Action context for working with an Excel document | Excel instance | Excel context | Yes |
| Sort column name | Name of the column to be sorted by. If the field is not filled in, the value from the "Sort column index" field is taken. If the sorting column name and index fields are not filled in, sorting is performed by the first column in the range. | String | No | |
| Sort column index | The index of the column by which the sorting will be performed. If the "Sort column name" field is filled in, the value of this field is ignored. If the sorting column name and index fields are not filled in, sorting is performed by the first column in the range. | Numeric | No | |
| Start cell column name | The column name of the initial cell (range start) from which the sorting range will be set. If the field is not filled in, the value from the "Start cell column index" field is taken. | String | No | |
| Start cell column index | The column index of the initial cell (range start) from which the sorting range will be set. If the field is not filled in, the boundary of the used area is taken. | Numeric | No | |
| Start cell row | The starting cell string from which the sort range will be set. | Numeric | No | |
| End cell column name | The column name of the end cell (end of range) to which the sort range will be set. If the field is not filled in, the value from the "End cell column index" field is taken. | String | No | |
| End cell column index | The column index of the end cell (end of range) to which the sorting range will be set. If the field is not filled in, the boundary of the used area is taken. | Numeric | No | |
| End cell row | The end cell string to which the sort range will be set. | Numeric | No | |
| Order | Sort order. Only the order of the data included in the range is changed. The order of the data in the table that were not included in the sorting range is not changed. If the set range contains data of one column (for example, from "A1" to "A10"), the data sorting is performed only within this column and the set range of rows - the parameters " Sort column name" and "Sort column index" do not affect the sorting. If the set range contains data of two or more columns (for example, from "A1" to "C10"), the data sorting is performed by the column specified in the " Sort column name" or " Sort column index" parameters. If the parameters " Sort column name" and "Sort column index" are not filled in, the sorting is performed by the first column in the range. | String | No | |
Version:
- 8 (net)
The action sorts the table by column
Settings
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
Parameters | ||||
Context | Action context for working with an Excel document | Excel instance | Excel context | Yes |
| Start cell column name | The column name of the initial cell (range start) from which the sorting range will be set. If the field is not filled in, the value from the "Start cell column index" field is taken. | String | No | |
| Start cell column index | The column index of the initial cell (range start) from which the sorting range will be set. If the field is not filled in, the boundary of the used area is taken. | Numeric | No | |
| Start cell row | The starting cell string from which the sort range will be set. | Numeric | No | |
| End cell column name | The column name of the end cell (end of range) to which the sort range will be set. If the field is not filled in, the value from the "End cell column index" field is taken. | String | No | |
| End cell column index | The column index of the end cell (end of range) to which the sorting range will be set. If the field is not filled in, the boundary of the used area is taken. | Numeric | No | |
| End cell row | The end cell row to which the sort range will be set. | Numeric | No | |
| Order | Sort order. Only the order of the data included in the range is changed. The order of the data in the table that were not included in the sorting range is not changed. If the set range (fields "Start of range" and "End of range") contains data of one column (for example, from "A1" to "A10"), the data sorting is performed only within this column and the set range of rows - the parameter "Column" does not influence the sorting. If the set range (fields "Start of range" and "End of range") contains data of two or more columns (for example, from "A1" to "C10"), the data sorting is performed by the column specified in the "Column" parameter. If the "Column" parameter is not filled in, the sorting is performed by the first column in the range. | String | No | |
Version:
- 7 (net)
The action sorts the table by column
Settings
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
Parameters | ||||
Context | Action context for working with an Excel document | Excel instance | Excel context | Yes |
| Start cell column name | The column of the starting cell from which the sort range will be set. | String | No | |
| Start cell row | The starting cell string from which the sort range will be set. | Numeric | No | |
| End cell column name | The column of the end cell to which the sort range will be set. | String | No | |
| End cell row | The end cell string to which the sort range will be set. | Numeric | No | |
| Order | Sort order. Only the order of the data included in the range is changed. The order of the data in the table that were not included in the sorting range is not changed. If the set range (fields "Start of range" and "End of range") contains data of one column (for example, from "A1" to "A10"), the data sorting is performed only within this column and the set range of rows - the parameter "Column" does not influence the sorting. If the set range (fields "Start of range" and "End of range") contains data of two or more columns (for example, from "A1" to "C10"), the data sorting is performed by the column specified in the "Column" parameter. If the "Column" parameter is not filled in, the sorting is performed by the first column in the range. | String | No | |
Version:
- 6 (net)
- 5 (net)
- 4 (net)
- 3 (net)
- 2 (net)
- 1 (net)
The action sorts the table by column
Settings
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
Parameters | ||||
Context | Action context for working with an Excel document | Excel instance | Excel context | Yes |
| Sort column name | Name of the column to be sorted by. If no column is specified, sorting is performed by the first one in the range. | String | No | |
| Start cell | Address of the initial cell from which the sorting range will be set. Fill in the format "XY", where "X" is the column number and "Y" is the row number. | String | No | |
| End cell | Address of the end cell to which the sort range will be set. Fill in the format "XY", where "X" is the column number and "Y" is the row number. | String | No | |
| Order | Sort order. Only the order of the data included in the range is changed. The order of the data in the table that were not included in the sorting range is not changed. If the set range (fields "Start of range" and "End of range") contains data of one column (for example, from "A1" to "A10"), the data sorting is performed only within this column and the set range of rows - the parameter "Column" does not influence the sorting. If the set range (fields "Start of range" and "End of range") contains data of two or more columns (for example, from "A1" to "C10"), the data sorting is performed by the column specified in the "Column" parameter. If the "Column" parameter is not filled in, the sorting is performed by the first column in the range. | String | No | |
Обзор
Инструменты контента