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 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