1. Component introduction
Prerequisite components: Launch Excel or Get opened Excel
You can use this component to sort data in a column in ascending or descending order.
2. Inputs
For help with each input item, see the component panel in the Visual Editor.
3. Outputs
For more information about each output, see the component panel in the ROS Visual Editor.
4. Component usage example
4.1. Component configuration example
Set
Opened sheet objectto v_Sheet_obj_1, which is the output of a prerequisite component (Get active sheet or Activate sheet).Set
Sort methodto "Ascending".In the
Sort by column numberfield, enter "B".Set
Exclude first row from sortingto "Yes".Default values for advanced options
4.2. Example execution result
None
5. Example flow
Setup flow
Use the Launch Excel component to launch the specified Excel file.
Use the Get active sheet component to obtain the active sheet object.
Use the Sort Excel component to sort the data by column B in ascending order and exclude the first row from sorting.
Execution result
After the flow runs successfully, the data is automatically sorted by column B in ascending order.