The sort method allows a user to sort an area by a particular column in the area. This method can sort numeric, alphabetic, and alphanumeric data. The user can also specify if the area contains headers, and whether to sort by ascending or descending.

 public static void Sort(Integer columnIndex, bool isAscending, bool hasHeader)

Public Static void Sub Sort(ByVal columnIndex As integer, ByVal isAscending As bool, ByVal hasHeader As bool)

An integer representing the column you would like to sort the area by.

A boolean representing whether you want to sort the area in ascending or descending order.

A boolean representing whether or not the area you want to sort contains a header row.

//Sort area with headers by the first column ascending 
Area a = WB[0].CreateArea("A1:C6");
a.Sort(0, true, true);
            
//Sort area with headers by first column descending
Area b = WB[0].CreateArea("A10:C15");
b.Sort(0, false, true);
            
//Sort area without headers by the first column ascending
Area c = WB[0].CreateArea("E2:G6");
c.Sort(0, true, false);
            
//Sort area without headers by the first column descending
Area d = WB[0].CreateArea("E11:G15");
d.Sort(0, false, false);
'Sort area with headers by the first column ascending 
Dim a As Area = WB(0).CreateArea("A1:C6")
a.Sort(0, True, True)


'Sort area with headers by first column descending
Dim b As Area = WB(0).CreateArea("A10:C15")
b.Sort(0, False, True)


'Sort area without headers by the first column ascending
Dim c As Area = WB(0).CreateArea("E2:G6")
c.Sort(0, True, False)


'Sort area without headers by the first column descending
Dim d As Area = WB(0).CreateArea("E11:G15")
d.Sort(0, False, False)