Sort data in Excel


#1

Hi – For the attached Excel file i want to sort the column ‘P’ (Vehicle line) first and the sort Column ‘A’(Key)

what function i should use and how? Please help meNDPC Input.xlsx (8.8 KB)


#2

Hi,

Use Sort data table activity :slight_smile:


#3

how do i use it ?


#4

Hi,

If the excel contains table then only we can able to use Sort Table activity


#5


Sort Date
#6

We can use … :slight_smile:

Store the excel values in the datatable and use this activity …


#7

Hi @Sob

I am using UiPath 2018.1.1 I didn’t find the sort datatable activity
For your Reference
image

Regards
JothyPrasanth M


#8

Thanks – Please help on what to enter on the properties – I entered the column and the name but it is not working. based on my excel file can you tell me what shuld i enter?


#9

Check in your package .

image


#10

Ok, May be I need to update the Datatable packages,
Thanks @Sob

Regards
JothyPrasanth M


#11

Give your input and output datatable.
and also your index value .


#12

See these -