Sort excel

[sruthesanju (Sweety)]

data-WPS Office.xls (10.5 KB) I have uploaded excel .In this excel I need to sort the excel by date which is in 4th column I should not use filter activity

[Srini84 (Srinivas)]

@sruthesanju

You can use Sort Data Table activity

Hope this helps you

Thanks

[prasath17 (Guru)]

@sruthesanju - please check this post…

Arrange date in descending order

Hi @sangasangasanga, Use below LINQ code to sort the datatable (From p In dataTable Order By DateTime.ParseExact(p.Item("Date").ToString, "d MMM yyyy", System.Globalization.CultureInfo.InvariantCulture) Descending Select p).CopyToDataTable Regards, Arivu