How to sort the values in specific column in excelsheet

[ddpadil (Dilip)]

Hi,
Did this help

Uipath - Sort Datatable

Hi, I’m trying to sort a datatable variable which come from a .csv file. I would like to sort the column name: “Column2”, ¿How it could be posible just using the uipath posibilities? ( Not writing in an Excel… ) I´ve been trying with the table.defaultview or table.select properties but i’m not able to sort it. How it could be done? Cheers, David

Sorting of excel file which doesn't have table name

Hi All, There a scenario, Where we want to read an excel file and sort that based on some column/Field in ascending /descending form and get the updated Excel table. Since , To sort the excel file we use the sort Excel activity but the input/src excel must have table name defiled on it. as below: [image] But in our scenario, We are reading the Excel file dynamically and table is not defined on it. How to accomplish this? We want to read and update the same excel with sorted data.