[FIXED] How to delete worksheet in PHPExcel

Issue

In PHPExcel how can I delete a sheet with the name worksheet?

I have this, but it does not work:

$objWorkSheet->removeSheetByIndex("Worksheet");

Solution

Worksheet is the name of a worksheet, not its index (position within the collection of worksheets). You need to identify its index position and use that as the argument to removeSheetByIndex()

Something like:

$objWorkSheet->setActiveSheetIndexByName('Worksheet');
$sheetIndex = $objWorkSheet->getActiveSheetIndex();
$objWorkSheet->removeSheetByIndex($sheetIndex);

or

$objWorkSheet->removeSheetByIndex(
    $objWorkSheet->getIndex(
        $objWorkSheet->getSheetByName('Worksheet')
    )
);

Answered By - Mark Baker

Answer Checked By - Robin (PHPFixing Admin)