PHPExcel锁定特定单元格 [英] PHPExcel lock particular cell

问题描述

在phpexcel中，我能够锁定单元格

In phpexcel i was able to lock cell by

$objPHPExcel->getActiveSheet()->protectCells('A1:D1', 'php');
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);

如果我双击A1到D1之间的任何单元，它将要求输入密码.
但是，如果我双击其他任何单元格(例如A2)，它都会显示

If i double click on any Cell between A1 to D1 it will ask for password as it should.
But if i double click on any other cell (eg) A2 it says

"The cell or chart that you are trying to change is protected and therefore 
read-only".

它锁定了整个工作表，是否可以只锁定特定的单元格而使其他单元格可编辑?

Its locking whole worksheet, Is it possible to lock only particular cell and leave other cells editable?

推荐答案

最后，我找到了正确的方法.

Finally, i found the right way to do it..

$objPHPExcel = new PHPExcel;
$objSheet = $objPHPExcel->getActiveSheet();

//保护细胞范围

$objSheet->protectCells('A1:B1', 'PHP');

//不保护手机范围

$objSheet->getStyle('A2:B2')->getProtection()
->setLocked(PHPExcel_Style_Protection::PROTECTION_UNPROTECTED);

//保护工作表

$objSheet->getProtection()->setSheet(true);

这很好用！

这篇关于PHPExcel锁定特定单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！