Class DeleteEmptyRowsOptions

Options controlling which rows are considered empty during a Worksheet.DeleteEmptyRows operation.

Inheritance

object

DeleteEmptyRowsOptions

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 DeleteEmptyRowsOptions

Constructors

DeleteEmptyRowsOptions()

Options controlling which rows are considered empty during a Worksheet.DeleteEmptyRows operation.

Declaration

public DeleteEmptyRowsOptions()

Properties

TreatFormulaCellsAsNonEmpty

Indicates whether a cell that contains a formula (even one evaluating to an empty string) counts as non-empty. Default: true — formula cells are never treated as empty.

Declaration

public bool TreatFormulaCellsAsNonEmpty { get; set; }

Property Value

Type	Description
bool

TreatWhitespaceAsEmpty

Indicates whether a row whose cells contain only whitespace strings is considered empty. Default: true.

Declaration

public bool TreatWhitespaceAsEmpty { get; set; }

Property Value

Type	Description
bool