Class RemoveDuplicatesOptions

Controls how duplicate rows are identified and removed.

Inheritance

object

RemoveDuplicatesOptions

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet.DataCleansing

Assembly: DRIT.Spreadsheet.dll

Syntax

public class RemoveDuplicatesOptions

Constructors

RemoveDuplicatesOptions()

Controls how duplicate rows are identified and removed.

Declaration

public RemoveDuplicatesOptions()

Properties

Columns

Specifies the 0-based column indices (relative to the range's left edge) that define row uniqueness. When null (default), all columns in the range are used. For example, with a range B2:D10, column 0 = B, 1 = C, 2 = D.

Declaration

public ISet<int> Columns { get; set; }

Property Value

Type	Description
ISet<int>

HasHeader

Indicates whether the first row of the range is treated as a header and therefore never removed. Default: false.

Declaration

public bool HasHeader { get; set; }

Property Value

Type	Description
bool

MatchCase

Indicates whether string comparison is case-sensitive. Default: false (case-insensitive, matching Excel's default behaviour).

Declaration

public bool MatchCase { get; set; }

Property Value

Type	Description
bool

TrimBeforeCompare

Indicates whether leading and trailing whitespace is stripped from string values before comparison. Default: false.

Declaration

public bool TrimBeforeCompare { get; set; }

Property Value

Type	Description
bool