Skip to main content
Docs
Go to the Studio
Roberty Studio
RPAExcel

Sort by row

Sort by row

Sorts the rows of an Excel tab by the values of a specific column, in ascending or descending order.


Options​

Excel tab​

Select the Excel tab, obtained earlier in the flow by the Select an Excel tab or Create an Excel tab actions.

Column to sort​

Enter the letter of the column whose values are used as the sorting criterion.

Order by​

Select the sort order: ascending or descending.

Ignore first row?​

Decide whether the document's first row should be ignored.

Returns​

This action has no returns.

Rules and Conditions​

  • Every field is required.
  • This action is only available on Windows, because it uses the Microsoft Excel installed on the computer. On macOS and Linux, the action fails with the message "only available on Windows".