Sorting data in Excel

[AshwinS2 (Ashwin S)]

Hi @Naveen.Ch

Check this

Sort DataTable based on column value

Hi, I have an Excel looking like this: Column1, Column2, Column3 XX, XX, -1040 XX, XX, -104 XX, XX, -1072 XX, XX, -1087 XX, XX, -111 I want to read this and sort the DataTable based on valuesd in “Column3”. This is the result using when using DataView.Sort(ascending): -104 -1040 -1072 -1087 -111 This is of course not the result im looking for. Does anyone have any idea how i can do this sorting?

Dataview dv=new DataView(Dt)

Dv.Sort=“Column2,Column3,Column4 asc”

Thanks
Ashwin S

Thanks
Ashwin S