DeleteBlankOptions class

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

Inheritance: DeleteBlankOptions → DeleteOptions

The DeleteBlankOptions type exposes the following members:

Constructor	Description
`__init__(self)`	Constructs a new instance of DeleteBlankOptions

Property	Description
update_reference	Indicates if update references in other worksheets.
formula_change_monitor	Gets/sets the monitor for tracking changes caused by the deletion.
empty_string_as_blank	Whether one cell will be taken as blank when its value is empty string. Default value is true.
empty_formula_value_as_blank	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.
drawings_as_blank	Whether drawing related objects such as picture, shape, chart… will be taken as blank. Default value is true.
merged_cells_shrink_type	Indicates how to process merged cells when deleting blank rows/columns.
start_index	Specifies the start row/column index of the range to check and delete blank rows/columns.
end_index	Specifies the end row/column index(inclusive) of the range to check and delete blank rows/columns. Default value is -1 and -1 means the maximum range of all objects(cells, drawings, …) that need to be checked.