private function PHPExcel_Writer_Excel2007_Worksheet::_writeSheetPr in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Worksheet.php \PHPExcel_Writer_Excel2007_Worksheet::_writeSheetPr()

* Write SheetPr * *

Parameters

PHPExcel_Shared_XMLWriter $objWriter XML Writer: * @param PHPExcel_Worksheet $pSheet Worksheet * @throws PHPExcel_Writer_Exception

1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeSheetPr()

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 146

Class

PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

Code

private function _writeSheetPr(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null) {

  // sheetPr
  $objWriter
    ->startElement('sheetPr');

  //$objWriter->writeAttribute('codeName',		$pSheet->getTitle());
  if ($pSheet
    ->getParent()
    ->hasMacros()) {

    //if the workbook have macros, we need to have codeName for the sheet
    if ($pSheet
      ->hasCodeName() == false) {
      $pSheet
        ->setCodeName($pSheet
        ->getTitle());
    }
    $objWriter
      ->writeAttribute('codeName', $pSheet
      ->getCodeName());
  }
  $autoFilterRange = $pSheet
    ->getAutoFilter()
    ->getRange();
  if (!empty($autoFilterRange)) {
    $objWriter
      ->writeAttribute('filterMode', 1);
    $pSheet
      ->getAutoFilter()
      ->showHideRows();
  }

  // tabColor
  if ($pSheet
    ->isTabColorSet()) {
    $objWriter
      ->startElement('tabColor');
    $objWriter
      ->writeAttribute('rgb', $pSheet
      ->getTabColor()
      ->getARGB());
    $objWriter
      ->endElement();
  }

  // outlinePr
  $objWriter
    ->startElement('outlinePr');
  $objWriter
    ->writeAttribute('summaryBelow', $pSheet
    ->getShowSummaryBelow() ? '1' : '0');
  $objWriter
    ->writeAttribute('summaryRight', $pSheet
    ->getShowSummaryRight() ? '1' : '0');
  $objWriter
    ->endElement();

  // pageSetUpPr
  if ($pSheet
    ->getPageSetup()
    ->getFitToPage()) {
    $objWriter
      ->startElement('pageSetUpPr');
    $objWriter
      ->writeAttribute('fitToPage', '1');
    $objWriter
      ->endElement();
  }
  $objWriter
    ->endElement();
}