SortRows(Int32,Boolean,Boolean,IComparer,Boolean,Boolean) Method
In This Topic
Sorts all the rows on this sheet by the specified column using the specified comparison.
Syntax
'Declaration
Public Overloads Function SortRows( _
ByVal keyColumn As Integer, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As IComparer, _
ByVal As Boolean, _
ByVal As Boolean _
) As Boolean
'Usage
Dim instance As SheetView
Dim keyColumn As Integer
Dim ascending As Boolean
Dim showIndicator As Boolean
Dim comparer As IComparer
Dim sortFrozenRows As Boolean
Dim sortTrailingFrozenRows As Boolean
Dim value As Boolean
value = instance.SortRows(keyColumn, ascending, showIndicator, comparer, sortFrozenRows, sortTrailingFrozenRows)
Parameters
- keyColumn
- Column index whose values are compared during sorting
- ascending
- Whether to sort in ascending order
- showIndicator
- Whether the sort indicator should be displayed
- comparer
- IComparer object used to compare the values
- sortFrozenRows
- Whether frozen rows are sorted
- sortTrailingFrozenRows
- Whether trailing frozen rows are sorted
See Also