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

* Write SheetFormatPr * *

Parameters

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

1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeSheetFormatPr()

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 315

Class

PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

Code

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

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

  // Default row height
  if ($pSheet
    ->getDefaultRowDimension()
    ->getRowHeight() >= 0) {
    $objWriter
      ->writeAttribute('customHeight', 'true');
    $objWriter
      ->writeAttribute('defaultRowHeight', PHPExcel_Shared_String::FormatNumber($pSheet
      ->getDefaultRowDimension()
      ->getRowHeight()));
  }
  else {
    $objWriter
      ->writeAttribute('defaultRowHeight', '14.4');
  }

  // Set Zero Height row
  if ((string) $pSheet
    ->getDefaultRowDimension()
    ->getZeroHeight() == '1' || strtolower((string) $pSheet
    ->getDefaultRowDimension()
    ->getZeroHeight()) == 'true') {
    $objWriter
      ->writeAttribute('zeroHeight', '1');
  }

  // Default column width
  if ($pSheet
    ->getDefaultColumnDimension()
    ->getWidth() >= 0) {
    $objWriter
      ->writeAttribute('defaultColWidth', PHPExcel_Shared_String::FormatNumber($pSheet
      ->getDefaultColumnDimension()
      ->getWidth()));
  }

  // Outline level - row
  $outlineLevelRow = 0;
  foreach ($pSheet
    ->getRowDimensions() as $dimension) {
    if ($dimension
      ->getOutlineLevel() > $outlineLevelRow) {
      $outlineLevelRow = $dimension
        ->getOutlineLevel();
    }
  }
  $objWriter
    ->writeAttribute('outlineLevelRow', (int) $outlineLevelRow);

  // Outline level - column
  $outlineLevelCol = 0;
  foreach ($pSheet
    ->getColumnDimensions() as $dimension) {
    if ($dimension
      ->getOutlineLevel() > $outlineLevelCol) {
      $outlineLevelCol = $dimension
        ->getOutlineLevel();
    }
  }
  $objWriter
    ->writeAttribute('outlineLevelCol', (int) $outlineLevelCol);
  $objWriter
    ->endElement();
}