private function PHPExcel_Writer_Excel2007_Worksheet::_writeProtectedRanges in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.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();
  }
}