How to sort the column in excel which doesnt have any column name


I have one excel, it has data from mid of the excel,the column doesn’t have any header, and any column name.
i want to sort the whole excel sheet data using that column.can anyone please me with that.



Hello @Ananthaeswar2,

Hope this could help:

If you are using Excel Read Range Activity to get the excel table (with option AddHeaders unchecked) then columns are by default named Column0, Column1 … and so on.
Here is an example: (7.5 KB)

Take a look at this: