How to sort in excel

excel
csv
activities

#1

Hello guys, I need a help here. literally stuck with this.

I have an excel file with “name” and “price” columns. The price is in “Rs.” format. I need to sort the price in ascending order, meanwhile the “name” column should change acc: to it. I will attach a screenshot along with this which will clarify the situation.

Tried Attempts: Split String expression and activity

Thanx in advance!

@ddpadil @ddrdushy1 @vvaidya


#2

Hi @Henry,

Use Sort Table activity to sort the data. Please find the attached workflow.
Excel_sort.xaml (7.6 KB)

Regards,
Lakshman.


#3

is there any possibility to SORT a column in excel if the excel doesn’t have a table… ???