private function PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForPrintArea in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Workbook.php \PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForPrintArea()

* Write Defined Name for PrintTitles * *

Parameters

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

1 call to PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForPrintArea()

PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNames in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Workbook.php

* Write Defined Names * *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Workbook.php, line 430

Class

PHPExcel_Writer_Excel2007_Workbook

PHPExcel_Writer_Excel2007_Workbook

Code

private function _writeDefinedNameForPrintArea(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $pSheetId = 0) {

  // definedName for PrintArea
  if ($pSheet
    ->getPageSetup()
    ->isPrintAreaSet()) {
    $objWriter
      ->startElement('definedName');
    $objWriter
      ->writeAttribute('name', '_xlnm.Print_Area');
    $objWriter
      ->writeAttribute('localSheetId', $pSheetId);

    // Setting string
    $settingString = '';

    // Print area
    $printArea = PHPExcel_Cell::splitRange($pSheet
      ->getPageSetup()
      ->getPrintArea());
    $chunks = array();
    foreach ($printArea as $printAreaRect) {
      $printAreaRect[0] = PHPExcel_Cell::absoluteReference($printAreaRect[0]);
      $printAreaRect[1] = PHPExcel_Cell::absoluteReference($printAreaRect[1]);
      $chunks[] = '\'' . str_replace("'", "''", $pSheet
        ->getTitle()) . '\'!' . implode(':', $printAreaRect);
    }
    $objWriter
      ->writeRawData(implode(',', $chunks));
    $objWriter
      ->endElement();
  }
}