private function PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForPrintTitles in Loft Data Grids 7.2

Same name and namespace in other branches

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

* 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::_writeDefinedNameForPrintTitles()

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 387

Class

PHPExcel_Writer_Excel2007_Workbook

PHPExcel_Writer_Excel2007_Workbook

Code

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

  // definedName for PrintTitles
  if ($pSheet
    ->getPageSetup()
    ->isColumnsToRepeatAtLeftSet() || $pSheet
    ->getPageSetup()
    ->isRowsToRepeatAtTopSet()) {
    $objWriter
      ->startElement('definedName');
    $objWriter
      ->writeAttribute('name', '_xlnm.Print_Titles');
    $objWriter
      ->writeAttribute('localSheetId', $pSheetId);

    // Setting string
    $settingString = '';

    // Columns to repeat
    if ($pSheet
      ->getPageSetup()
      ->isColumnsToRepeatAtLeftSet()) {
      $repeat = $pSheet
        ->getPageSetup()
        ->getColumnsToRepeatAtLeft();
      $settingString .= '\'' . str_replace("'", "''", $pSheet
        ->getTitle()) . '\'!$' . $repeat[0] . ':$' . $repeat[1];
    }

    // Rows to repeat
    if ($pSheet
      ->getPageSetup()
      ->isRowsToRepeatAtTopSet()) {
      if ($pSheet
        ->getPageSetup()
        ->isColumnsToRepeatAtLeftSet()) {
        $settingString .= ',';
      }
      $repeat = $pSheet
        ->getPageSetup()
        ->getRowsToRepeatAtTop();
      $settingString .= '\'' . str_replace("'", "''", $pSheet
        ->getTitle()) . '\'!$' . $repeat[0] . ':$' . $repeat[1];
    }
    $objWriter
      ->writeRawData($settingString);
    $objWriter
      ->endElement();
  }
}