DeleteBlankOptions class

DeleteBlankOptions class

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

Inheritance: DeleteBlankOptionsDeleteOptions

The DeleteBlankOptions type exposes the following members:

Constructors

ConstructorDescription
initConstructs a new instance of DeleteBlankOptions

Properties

PropertyDescription
update_referenceIndicates if update references in other worksheets.
empty_string_as_blankWhether one cell will be taken as blank when its value is empty string. Default value is true.
empty_formula_value_as_blankWhether one cell will be taken as blank when it is formula and the calculated result is null or empty string. Default value is false.

See Also