I do not know what clear sheet means, but “Delete Range” proposed by @ashokkarale will help partially → if the deleted range contains some empty rows those in some cases won’t be deleted. This can be avoided using options ShiftCells=ON and ShiftOption=EntireRow
What works definitely is “Insert/Delete Rows” which truly deletes rows including empty ones.
Cheers