PHPExcel lock particular cells
Context: I want to lock cells H4:H10 and O4:O10, others will allow user to edit.
//set password $activeSheet->protectCells('H4:H10', 'password'); $activeSheet->protectCells('O4:O10', 'password');
//lock need cells $activeSheet->getStyle('H4:H10')->getProtection() ->setLocked(\PHPExcel_Style_Protection::PROTECTION_PROTECTED); $activeSheet->getStyle('O4:O10')->getProtection() ->setLocked(\PHPExcel_Style_Protection::PROTECTION_PROTECTED);
//unlock others $activeSheet->getStyle('A4:G10')->getProtection() ->setLocked(\PHPExcel_Style_Protection::PROTECTION_UNPROTECTED); $activeSheet->getStyle('I4:N10')->getProtection() ->setLocked(\PHPExcel_Style_Protection::PROTECTION_UNPROTECTED);
$activeSheet->getProtection()->setSheet(true);