Is there any means available through which I can clear the cell?? Clearing in this context means removing the formatting.I searched the developer documentation as well as the discussions,but couldn't find any suitable result.
Do you mean actually delete the cell?
should delete cell B2
One more thing Is it possible in PHP Excel to read a particular sheet from a bunch of sheet. Like suppose I have a excel sheet with 10 sheets,So is it possible to read for example the 7th sheet??
Set the active sheet to the 7th sheet using either:
$objPHPExcel->setActiveSheetIndexByName('Sheet 7 Name');
if you know the sheet name.
Once you've set the active sheet, $objPHPExcel->getActiveSheet() will reference that sheet.