ExcelRangeSort(ExcelSortKey, Boolean, Boolean) Method |
Sorts the rows of this range by one or more columns, optionally matching the case of the texts.
The values, formulas and cell formats move with the rows; the relative references of the moved formulas
are adjusted to the new row, as in Excel. Numbers and dates come before texts and the blank cells are placed
last. Formula cells are sorted by their calculated results (call
UpdateFormulaResult first for the formulas added in code). The range cannot contain merged cells.
Namespace: ExpertXls.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic void Sort(
ExcelSortKey[] sortKeys,
bool hasHeaderRow,
bool matchCase
)
Public Sub Sort (
sortKeys As ExcelSortKey(),
hasHeaderRow As Boolean,
matchCase As Boolean
)
Parameters
- sortKeys ExcelSortKey
- The columns to sort by, in order of priority.
- hasHeaderRow Boolean
- True if the first row of the range is a header row that is not sorted.
- matchCase Boolean
- True to compare the texts with regard to case.
See Also