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.
Thanks
Ananthaeswar.
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.
Thanks
Ananthaeswar.
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:
sortTable.zip (7.5 KB)
Take a look at this:
Regards,
Susana