Overload | Description |
---|---|
SortColumns(Int32,Boolean) | Sorts all the columns on the sheet by the specified row. |
SortColumns(Int32,Boolean,IComparer) | Sorts all the columns on the sheet by the specified row using the specified comparison. |
SortColumns(Int32,Int32,SortInfo[]) | Sorts a specified range of columns on the sheet by the specified sort information. |
Use this method to sort the arrangement of columns in a sheet using one or more rows as the key.
This does not affect the data model, only how the data is displayed. Different overloads provide different ways to sort the columns. You can sort the entire sheet or specified columns depending on the method. For a discussion of sorting, refer to Managing Sorting of Rows.
To sort rows, use the SortRows 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