Sort by color Version 4 (Net)
Action group: Excel
Description
The action sorts the table by color.
Icon
Settings of parameters
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 start 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 | Row of the start cell 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 | |
Search column name | The name of the column to be sorted by. The column must be in the specified range. If the "Search cell list" parameter is not filled in, sorting will be performed by all colors included in the column. If the field is not filled in, the value from the "Search column index" field is taken. | String | No | |
Search column index | The index of the column to be sorted by. The column must be within the specified range. If the "Search cell list" parameter is not filled in, sorting will be performed by all colors included in the column. | Numeric | No | |
Search cell list | Addresses of the cells, specified in comma, by the colors of which the search will be performed. Cells may not be included in the specified range. If the parameter is not filled in, all colors of the search column are searched. Example: "A1, C3, C5" - sorting will be performed only by colors in these cells. | String | No |
Special conditions of use
None.
Example of use
Task
Sort the cells in column B by color.
Solution
Use the actions "Open", "Sort by color", "Save".
Implementation
- Assemble a robot scheme consisting of actions:
- Customize the settings for the "Open" action.
- Configure the settings for the "Sort by color" action.
- Customize the settings for the "Save" action.
- Click on the "Start" button in the top panel.
Result
The program robot completed successfully.
The data in column B is sorted by color.