[]
Sorts all the rows in the sheet according to the specified parameters.
public bool SortRows(int keyColumn, bool ascending, bool showIndicator)
Public Function SortRows(keyColumn As Integer, ascending As Boolean, showIndicator As Boolean) As Boolean
Type | Name | Description |
---|---|---|
int | keyColumn | Column whose values are compared during sorting |
bool | ascending | Whether the sort is ascending |
bool | showIndicator | Whether to display the sort indicator |
Type | Description |
---|---|
bool |
Sorts all the rows in the sheet according to the specified parameters.
public bool SortRows(int keyColumn, bool ascending, bool showIndicator, IComparer comparer)
Public Function SortRows(keyColumn As Integer, ascending As Boolean, showIndicator As Boolean, comparer As IComparer) As Boolean
Type | Name | Description |
---|---|---|
int | keyColumn | Column whose values are compared during sorting |
bool | ascending | Whether the sort is ascending |
bool | showIndicator | Whether to display the sort indicator |
IComparer | comparer | IComparer object used to compare the values |
Type | Description |
---|---|
bool |
Sorts a range of rows in the sheet according to the specified parameters.
public bool SortRows(int row, int rowCount, SortInfo[] sortInfo)
Public Function SortRows(row As Integer, rowCount As Integer, sortInfo As SortInfo()) As Boolean
Type | Name | Description |
---|---|---|
int | row | Starting row index (the start of the range of rows to sort) |
int | rowCount | Number of rows in the range to sort |
SortInfo[] | sortInfo | Array of SortInfo objects that contain the column indexes and the order of sorting |
Type | Description |
---|---|
bool |