How to sort specific excel column

Help Studio
, ,
1

Hi Devs,

Can someone help me to sort the excel column value from Z to A order.

Thanks & Regards,
Riya

2

@Riya1,

If you are using Excel Process Scope use Sort Range activity.

Thanks,
Ashok :slight_smile:

3

dt = dt.AsEnumerable().OrderByDescending(Function(row) row(“ColumnName”).ToString()).CopyToDataTable()

4

Hey @Riya1 you can follow these screenshot to solve your query…
input example

The image shows a "Build Data Table" activity window within a workflow, listing entries under "Col1" alongside a series of workflow steps including sorting and outputting the data table. (Captioned by AI)
The image shows a "Build Data Table" activity window within a workflow, listing entries under "Col1" alongside a series of workflow steps including sorting and outputting the data table. (Captioned by AI)1377×748 51 KB

A UiPath workflow is designed to build, sort, and output a data table in descending order, displaying the sorted result in a message box. (Captioned by AI)
A UiPath workflow is designed to build, sort, and output a data table in descending order, displaying the sorted result in a message box. (Captioned by AI)1296×763 53.7 KB

cheers Happy Automation…

5

Hi @Riya1

=> Use Read Range Workbook to read the excel and store the data in datatable say dt.

=> Use the below LINQ Sxpression to sort an particular column from Z to A

dt = dt.AsEnumerable().OrderByDescending(Function(row) row.Field(Of String)("ColumnName")).CopyToDataTable()

=> Use Write Range Workbook to write dt back to the excel.

Regards