Click or drag to resize

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.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public void Sort(
	ExcelSortKey[] sortKeys,
	bool hasHeaderRow,
	bool matchCase
)

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