Class DeleteBlankOptions

DeleteBlankOptions class

Represents the setting of deleting blank cells/rows/columns.

public class DeleteBlankOptions : DeleteOptions

Constructors

NameDescription
DeleteBlankOptions()The default constructor.

Properties

NameDescription
EmptyFormulaValueAsBlank { get; set; }Whether one cell will be taken as blank when it is formula and the calculated result is null or empty string. Default value is false.
EmptyStringAsBlank { get; set; }Whether one cell will be taken as blank when its value is empty string. Default value is true.
UpdateReference { get; set; }Indicates if update references in other worksheets.(Inherited from DeleteOptions.)

See Also