#lock cells

[crisbieber]

tumblr Explore the ways Zoho Sheet can help your team work together. http://dlvr.it/QGCB6P rlbmut

[vinh-tran]

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);