Aspose::Cells::Cells::DeleteBlankRows method

Cells::DeleteBlankRows() method

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

void Aspose::Cells::Cells::DeleteBlankRows()

See Also

Cells::DeleteBlankRows(const DeleteOptions&) method

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

void Aspose::Cells::Cells::DeleteBlankRows(const DeleteOptions &options)
ParameterTypeDescription
optionsconst DeleteOptions&The options of deleting range.

Remarks

For blank rows that will be deleted, it is not only required that Row.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