PHP PHPExcel 下拉 让其只能在其下拉的分表隐藏并设置解锁密码

PHP PHPExcel 下拉 让其只能在其下拉的分表隐藏并设置解锁密码

$obpe->getActiveSheet()->setSheetState(\PHPExcel_Worksheet::SHEETSTATE_HIDDEN); //隐藏

 

$obpe = new PHPExcel();
 //密码
$obpe->getActiveSheet()->getProtection()->setPassword('PHPExcel');
$obpe->getActiveSheet()->getProtection()->setSheet(true);// This should be enabled inorder to enable any of thefollowing!
$obpe->getActiveSheet()->getProtection()->setSort(true);
$obpe->getActiveSheet()->getProtection()->setInsertRows(true);
obpe->getActiveSheet()->getProtection()->setFormatCells(true);