Sort

The Sort action sorts cell values in an Excel workbook.

Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.

  1. Drag the Target Selector from the Build Pane Area to add new actions and edit existing actions. The Build Pane displays after you select a targeted element in a Windows application. The center of the Build Pane is referred to as the Task Editor Pane. and drop it onto an Excel worksheet column or exact cell or on the bot-generated target.

  2. Select Sort.

  3. Select to Sort by Column name or Column number.

  4. Enter the Column name or number that will be used to find the column with the cells that need to be sorted. Optionally, click the Magic Wand to use the Expression Builder.

  5. Select a sort Direction (Ascending (Z-A) or Descending (A-Z)).

  6. If desired, select to Include headers. This option is selected by default. If you include headers, then the first row of your selection will be the header row, most likely containing column labels, and it will not be sorted. If you do not select to include headers, then all rows will be sorted along with the rest of the data.

  7. Click Rules to modify how Nintex Bot finds the target.

  8. If needed, adjust the Timing settings to fine tune how the action runs.

  9. If needed, adjust the Run error task settings to fine tune how the action runs.

    • Run error task: A botflow containing an error task automatically runs the error task in the event of an error. If the botflow does not contain an error task, the botflow stops in the event of an error.
    • Stop on error: The botflow stops in the event of an error.
    • Ignore errors: The action is skipped in the event of an error and the botflow attempts to execute the next action.

  10. (Optional) Add a Note to document special instructions or functionality.

  11. Toggle the run switch to Run and click OK to execute and save the action.

    12. Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run. For more information, go to Action Builder.