Sort Range Activity

Help Studio
, ,
1

How to sort excel file by column using sort range activity?

The image shows a sequence of automated steps in an Excel process involving sorting a range within a specified file and sheet, based on the "Order Number" column in ascending order. (Captioned by AI)
The image shows a sequence of automated steps in an Excel process involving sorting a range within a specified file and sheet, based on the "Order Number" column in ascending order. (Captioned by AI)676Ă—827 20.5 KB

Sort Range: The range Orders does not exist.

This is my excel file look like.

A spreadsheet displaying a list of order numbers in column A, with no data entered in the adjacent columns for order date, order status, store, and order subtotal. (Captioned by AI)
A spreadsheet displaying a list of order numbers in column A, with no data entered in the adjacent columns for order date, order status, store, and order subtotal. (Captioned by AI)1461Ă—756 19.5 KB

2

Hi @jmsphlp

The Error “Sort Range: The range Orders does not exist.” means that the name “Orders” mentioned in the expression Excel.SelectedSheet.Range("Orders") is Wrong.

Please check the correct name.

If that is the only data present in your sheet, Use the following approach:

image
image439Ă—214 5.76 KB

As you can see below, The sort works:
Input:

image
image346Ă—217 2.97 KB

Output:

image
image305Ă—206 1.94 KB

If this solves your issue, Do mark it as a solution
Happy Automation :star_struck:

1 Like
3

Hi,

As your table starts with A1, it’s unnecessary to use Range. The following may help you.

image
image485Ă—237 6.68 KB

Or Excel.Sheet(“SheetName”) also works.

Regards,

2 Likes
Forum Engagement Daily Reports
4

Hi,

This works. Thank you. :))

Regards.

1 Like
5

Hey @jmsphlp
you can do this using linq method also

dt.AsEnumerable().OrderBy(Function(x) x(0)).CopyToDataTable()

it order your data in ascending form. And if you want to do in desc

dt.AsEnumerable().OrderByDescending(Function(x) x(0)).CopyToDataTable()

The image shows a workflow in UiPath Studio for sorting a data table and Excel sheet by a specified column in ascending order, alongside the properties panel detailing configurations for the sort operation. (Captioned by AI)
The image shows a workflow in UiPath Studio for sorting a data table and Excel sheet by a specified column in ascending order, alongside the properties panel detailing configurations for the sort operation. (Captioned by AI)1050Ă—432 28.3 KB

there are activity also for this

cheers