delete_blank_rows method

delete_blank_rows

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

def delete_blank_rows(self):
    ...

delete_blank_rows

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

def delete_blank_rows(self, options):
    ...
ParameterTypeDescription
optionsDeleteOptionsThe options of deleting range.

Remarks

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