Query: SORT an EXCEL file in VBDOTNET

[utd_anurag]

Hi,

I was seeking your suggestions regarding sorting an excel worksheet.

I want to sort a file column-wise such that the order does not change.

Student Marks Age
5 55 15
3 76 13
1 45 14
2 67 18
4 87 16



If I want to sort by "Age" criteria, the result should be:

Student Marks Age
3 76 13
1 45 14
5 55 15
4 87 16
2 67 18

I am using the following code:

WSheet.Columns.Sort(Key1:="F", Order1:=Excel.XlSortOrder.xlAscending)

I am not able to set the criteria of sort function in the VB.NET.

I am a beginner in VB DOT NET.
Your inputs would be of great help.

Thanks,
Anurag