Use this method to delete the contents and formatting of all of the ranges in the worksheet. The ranges themselves are not deleted. To delete a range definition from the worksheet, use the method
delete_ranges.CALL METHOD spreadsheet->clear_all_ranges
EXPORTING no_flush = no_flush
IMPORTING error = error
retcode = retcode.