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

* Write Cols * *

Parameters

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

1 call to PHPExcel_Writer_Excel2007_Worksheet::_writeCols()

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 367

Class

PHPExcel_Writer_Excel2007_Worksheet

PHPExcel_Writer_Excel2007_Worksheet

Code

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

  // cols
  if (count($pSheet
    ->getColumnDimensions()) > 0) {
    $objWriter
      ->startElement('cols');
    $pSheet
      ->calculateColumnWidths();

    // Loop through column dimensions
    foreach ($pSheet
      ->getColumnDimensions() as $colDimension) {

      // col
      $objWriter
        ->startElement('col');
      $objWriter
        ->writeAttribute('min', PHPExcel_Cell::columnIndexFromString($colDimension
        ->getColumnIndex()));
      $objWriter
        ->writeAttribute('max', PHPExcel_Cell::columnIndexFromString($colDimension
        ->getColumnIndex()));
      if ($colDimension
        ->getWidth() < 0) {

        // No width set, apply default of 10
        $objWriter
          ->writeAttribute('width', '9.10');
      }
      else {

        // Width set
        $objWriter
          ->writeAttribute('width', PHPExcel_Shared_String::FormatNumber($colDimension
          ->getWidth()));
      }

      // Column visibility
      if ($colDimension
        ->getVisible() == false) {
        $objWriter
          ->writeAttribute('hidden', 'true');
      }

      // Auto size?
      if ($colDimension
        ->getAutoSize()) {
        $objWriter
          ->writeAttribute('bestFit', 'true');
      }

      // Custom width?
      if ($colDimension
        ->getWidth() != $pSheet
        ->getDefaultColumnDimension()
        ->getWidth()) {
        $objWriter
          ->writeAttribute('customWidth', 'true');
      }

      // Collapsed
      if ($colDimension
        ->getCollapsed() == true) {
        $objWriter
          ->writeAttribute('collapsed', 'true');
      }

      // Outline level
      if ($colDimension
        ->getOutlineLevel() > 0) {
        $objWriter
          ->writeAttribute('outlineLevel', $colDimension
          ->getOutlineLevel());
      }

      // Style
      $objWriter
        ->writeAttribute('style', $colDimension
        ->getXfIndex());
      $objWriter
        ->endElement();
    }
    $objWriter
      ->endElement();
  }
}