Overload | Description |
---|---|
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. |
SortRows(Int32,Boolean,Boolean) | Sorts all the rows on this sheet by the specified column. |
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
Reference
SheetView ClassSheetView Members
SortColumns Method
AutoSortColumn Method