private function PHPExcel_Writer_Excel2007_Worksheet::_writeBreaks 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::_writeBreaks()

* Write Breaks * *

Parameters

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

1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeBreaks()

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 901

Class

PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

Code

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

  // Get row and column breaks
  $aRowBreaks = array();
  $aColumnBreaks = array();
  foreach ($pSheet
    ->getBreaks() as $cell => $breakType) {
    if ($breakType == PHPExcel_Worksheet::BREAK_ROW) {
      $aRowBreaks[] = $cell;
    }
    else {
      if ($breakType == PHPExcel_Worksheet::BREAK_COLUMN) {
        $aColumnBreaks[] = $cell;
      }
    }
  }

  // rowBreaks
  if (!empty($aRowBreaks)) {
    $objWriter
      ->startElement('rowBreaks');
    $objWriter
      ->writeAttribute('count', count($aRowBreaks));
    $objWriter
      ->writeAttribute('manualBreakCount', count($aRowBreaks));
    foreach ($aRowBreaks as $cell) {
      $coords = PHPExcel_Cell::coordinateFromString($cell);
      $objWriter
        ->startElement('brk');
      $objWriter
        ->writeAttribute('id', $coords[1]);
      $objWriter
        ->writeAttribute('man', '1');
      $objWriter
        ->endElement();
    }
    $objWriter
      ->endElement();
  }

  // Second, write column breaks
  if (!empty($aColumnBreaks)) {
    $objWriter
      ->startElement('colBreaks');
    $objWriter
      ->writeAttribute('count', count($aColumnBreaks));
    $objWriter
      ->writeAttribute('manualBreakCount', count($aColumnBreaks));
    foreach ($aColumnBreaks as $cell) {
      $coords = PHPExcel_Cell::coordinateFromString($cell);
      $objWriter
        ->startElement('brk');
      $objWriter
        ->writeAttribute('id', PHPExcel_Cell::columnIndexFromString($coords[0]) - 1);
      $objWriter
        ->writeAttribute('man', '1');
      $objWriter
        ->endElement();
    }
    $objWriter
      ->endElement();
  }
}