Cells.DeleteBlankRows

DeleteBlankRows()

Delete all blank rows which do not contain any data or other object.

public void DeleteBlankRows()

See Also


DeleteBlankRows(DeleteOptions)

Delete all blank rows which do not contain any data or some special objects such as visible comment, pivot table.

public void DeleteBlankRows(DeleteOptions options)
ParameterTypeDescription
optionsDeleteOptionsThe options of deleting range.

Remarks

For blank rows that will be deleted, it is not only required that IsBlank should be true, but also there should be no visible comment defined for any cell in those rows, and no pivot table whose range intersects with them.

See Also