Class DeleteEmptyColumnsOptions

Options controlling which columns are considered empty during a Worksheet.DeleteEmptyColumns operation.

Inheritance

object

DeleteEmptyColumnsOptions

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 DeleteEmptyColumnsOptions

Constructors

DeleteEmptyColumnsOptions()

Options controlling which columns are considered empty during a Worksheet.DeleteEmptyColumns operation.

Declaration

public DeleteEmptyColumnsOptions()

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 column whose cells contain only whitespace strings is considered empty. Default: true.

Declaration

public bool TreatWhitespaceAsEmpty { get; set; }

Property Value

Type	Description
bool