private function PHPExcel_Writer_Excel2007_Worksheet::_writeProtectedRanges in Loft Data Grids 7.2
Same name and namespace in other branches
- 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php \PHPExcel_Writer_Excel2007_Worksheet::_writeProtectedRanges()
* Write ProtectedRanges * *
Parameters
PHPExcel_Shared_XMLWriter $objWriter XML Writer: * @param PHPExcel_Worksheet $pSheet Worksheet * @throws PHPExcel_Writer_Exception
1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeProtectedRanges()
- PHPExcel_Writer_Excel2007_Worksheet::writeWorksheet in vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel2007/ Worksheet.php - * Write worksheet to XML format * *
File
- vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel2007/ Worksheet.php, line 649
Class
- PHPExcel_Writer_Excel2007_Worksheet
- PHPExcel_Writer_Excel2007_Worksheet
Code
private function _writeProtectedRanges(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null) {
if (count($pSheet
->getProtectedCells()) > 0) {
// protectedRanges
$objWriter
->startElement('protectedRanges');
// Loop protectedRanges
foreach ($pSheet
->getProtectedCells() as $protectedCell => $passwordHash) {
// protectedRange
$objWriter
->startElement('protectedRange');
$objWriter
->writeAttribute('name', 'p' . md5($protectedCell));
$objWriter
->writeAttribute('sqref', $protectedCell);
if (!empty($passwordHash)) {
$objWriter
->writeAttribute('password', $passwordHash);
}
$objWriter
->endElement();
}
$objWriter
->endElement();
}
}