Clear spreadsheet using PHPExcel

Question

How do I clear the sheet with PHPExcel? Something like Sheet.ClearContents in VBA. All I could find was delete rows and columns and it's not useful for me as I need to clear entire sheet before writing data to the file.

Answer 1

not a good way, you will erase the style . you should copy the style first!额

Answer 2

You can remove the sheets and create a new one.

$myExcelObj->disconnectWorksheets();
$myExcelObj->createSheet();