private function PHPExcel_Writer_Excel2007_Worksheet::_writeSheetProtection 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::_writeSheetProtection()
* Write SheetProtection * *
Parameters
PHPExcel_Shared_XMLWriter $objWriter XML Writer: * @param PHPExcel_Worksheet $pSheet Worksheet * @throws PHPExcel_Writer_Exception
1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeSheetProtection()
- 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 432
Class
- PHPExcel_Writer_Excel2007_Worksheet
- PHPExcel_Writer_Excel2007_Worksheet
Code
private function _writeSheetProtection(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null) {
// sheetProtection
$objWriter
->startElement('sheetProtection');
if ($pSheet
->getProtection()
->getPassword() != '') {
$objWriter
->writeAttribute('password', $pSheet
->getProtection()
->getPassword());
}
$objWriter
->writeAttribute('sheet', $pSheet
->getProtection()
->getSheet() ? 'true' : 'false');
$objWriter
->writeAttribute('objects', $pSheet
->getProtection()
->getObjects() ? 'true' : 'false');
$objWriter
->writeAttribute('scenarios', $pSheet
->getProtection()
->getScenarios() ? 'true' : 'false');
$objWriter
->writeAttribute('formatCells', $pSheet
->getProtection()
->getFormatCells() ? 'true' : 'false');
$objWriter
->writeAttribute('formatColumns', $pSheet
->getProtection()
->getFormatColumns() ? 'true' : 'false');
$objWriter
->writeAttribute('formatRows', $pSheet
->getProtection()
->getFormatRows() ? 'true' : 'false');
$objWriter
->writeAttribute('insertColumns', $pSheet
->getProtection()
->getInsertColumns() ? 'true' : 'false');
$objWriter
->writeAttribute('insertRows', $pSheet
->getProtection()
->getInsertRows() ? 'true' : 'false');
$objWriter
->writeAttribute('insertHyperlinks', $pSheet
->getProtection()
->getInsertHyperlinks() ? 'true' : 'false');
$objWriter
->writeAttribute('deleteColumns', $pSheet
->getProtection()
->getDeleteColumns() ? 'true' : 'false');
$objWriter
->writeAttribute('deleteRows', $pSheet
->getProtection()
->getDeleteRows() ? 'true' : 'false');
$objWriter
->writeAttribute('selectLockedCells', $pSheet
->getProtection()
->getSelectLockedCells() ? 'true' : 'false');
$objWriter
->writeAttribute('sort', $pSheet
->getProtection()
->getSort() ? 'true' : 'false');
$objWriter
->writeAttribute('autoFilter', $pSheet
->getProtection()
->getAutoFilter() ? 'true' : 'false');
$objWriter
->writeAttribute('pivotTables', $pSheet
->getProtection()
->getPivotTables() ? 'true' : 'false');
$objWriter
->writeAttribute('selectUnlockedCells', $pSheet
->getProtection()
->getSelectUnlockedCells() ? 'true' : 'false');
$objWriter
->endElement();
}