Overload | Description |
---|---|
SortRows(Int32,Boolean,Boolean) | Sorts all the rows on this sheet by the specified column. |
SortRows(Int32,Boolean,Boolean,IComparer) | Sorts all the rows on this sheet by the specified column using the specified comparison. |
SortRows(Int32,Boolean,Boolean,IComparer,Boolean,Boolean) | Sorts all the rows on this sheet by the specified column using the specified comparison. |
SortRows(Int32,Int32,SortInfo[]) | Sorts a range of rows on this sheet according to the specified sort information. |
Use this method to sort the arrangement of rows in a sheet using one or more columns as the key. This does not affect the data model, only how the data is displayed. Different overloads provide different ways to sort the rows. You can sort the entire sheet or specified rows depending on the method. For a discussion of sorting, refer to Managing Sorting of Rows.
To sort columns, use the SortColumns methods.
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
Reference
SheetView ClassSheetView Members
SortColumns Method
AutoSortColumn Method