public function PHPExcel_Writer_Excel2007_ContentTypes::writeContentTypes in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/ContentTypes.php \PHPExcel_Writer_Excel2007_ContentTypes::writeContentTypes()

* Write content types to XML format * *

Parameters

PHPExcel $pPHPExcel: * @param boolean $includeCharts Flag indicating if we should include drawing details for charts * @return string XML Output * @throws PHPExcel_Writer_Exception

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/ContentTypes.php, line 46

Class

PHPExcel_Writer_Excel2007_ContentTypes

PHPExcel_Writer_Excel2007_ContentTypes

Code

public function writeContentTypes(PHPExcel $pPHPExcel = null, $includeCharts = FALSE) {

  // Create XML writer
  $objWriter = null;
  if ($this
    ->getParentWriter()
    ->getUseDiskCaching()) {
    $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this
      ->getParentWriter()
      ->getDiskCachingDirectory());
  }
  else {
    $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
  }

  // XML header
  $objWriter
    ->startDocument('1.0', 'UTF-8', 'yes');

  // Types
  $objWriter
    ->startElement('Types');
  $objWriter
    ->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/content-types');

  // Theme
  $this
    ->_writeOverrideContentType($objWriter, '/xl/theme/theme1.xml', 'application/vnd.openxmlformats-officedocument.theme+xml');

  // Styles
  $this
    ->_writeOverrideContentType($objWriter, '/xl/styles.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml');

  // Rels
  $this
    ->_writeDefaultContentType($objWriter, 'rels', 'application/vnd.openxmlformats-package.relationships+xml');

  // XML
  $this
    ->_writeDefaultContentType($objWriter, 'xml', 'application/xml');

  // VML
  $this
    ->_writeDefaultContentType($objWriter, 'vml', 'application/vnd.openxmlformats-officedocument.vmlDrawing');

  // Workbook
  if ($pPHPExcel
    ->hasMacros()) {

    //Macros in workbook ?

    // Yes : not standard content but "macroEnabled"
    $this
      ->_writeOverrideContentType($objWriter, '/xl/workbook.xml', 'application/vnd.ms-excel.sheet.macroEnabled.main+xml');

    //... and define a new type for the VBA project
    $this
      ->_writeDefaultContentType($objWriter, 'bin', 'application/vnd.ms-office.vbaProject');
    if ($pPHPExcel
      ->hasMacrosCertificate()) {

      // signed macros ?
      // Yes : add needed information
      $this
        ->_writeOverrideContentType($objWriter, '/xl/vbaProjectSignature.bin', 'application/vnd.ms-office.vbaProjectSignature');
    }
  }
  else {

    // no macros in workbook, so standard type
    $this
      ->_writeOverrideContentType($objWriter, '/xl/workbook.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml');
  }

  // DocProps
  $this
    ->_writeOverrideContentType($objWriter, '/docProps/app.xml', 'application/vnd.openxmlformats-officedocument.extended-properties+xml');
  $this
    ->_writeOverrideContentType($objWriter, '/docProps/core.xml', 'application/vnd.openxmlformats-package.core-properties+xml');
  $customPropertyList = $pPHPExcel
    ->getProperties()
    ->getCustomProperties();
  if (!empty($customPropertyList)) {
    $this
      ->_writeOverrideContentType($objWriter, '/docProps/custom.xml', 'application/vnd.openxmlformats-officedocument.custom-properties+xml');
  }

  // Worksheets
  $sheetCount = $pPHPExcel
    ->getSheetCount();
  for ($i = 0; $i < $sheetCount; ++$i) {
    $this
      ->_writeOverrideContentType($objWriter, '/xl/worksheets/sheet' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml');
  }

  // Shared strings
  $this
    ->_writeOverrideContentType($objWriter, '/xl/sharedStrings.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml');

  // Add worksheet relationship content types
  $chart = 1;
  for ($i = 0; $i < $sheetCount; ++$i) {
    $drawings = $pPHPExcel
      ->getSheet($i)
      ->getDrawingCollection();
    $drawingCount = count($drawings);
    $chartCount = $includeCharts ? $pPHPExcel
      ->getSheet($i)
      ->getChartCount() : 0;

    //	We need a drawing relationship for the worksheet if we have either drawings or charts
    if ($drawingCount > 0 || $chartCount > 0) {
      $this
        ->_writeOverrideContentType($objWriter, '/xl/drawings/drawing' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.drawing+xml');
    }

    //	If we have charts, then we need a chart relationship for every individual chart
    if ($chartCount > 0) {
      for ($c = 0; $c < $chartCount; ++$c) {
        $this
          ->_writeOverrideContentType($objWriter, '/xl/charts/chart' . $chart++ . '.xml', 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml');
      }
    }
  }

  // Comments
  for ($i = 0; $i < $sheetCount; ++$i) {
    if (count($pPHPExcel
      ->getSheet($i)
      ->getComments()) > 0) {
      $this
        ->_writeOverrideContentType($objWriter, '/xl/comments' . ($i + 1) . '.xml', 'application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml');
    }
  }

  // Add media content-types
  $aMediaContentTypes = array();
  $mediaCount = $this
    ->getParentWriter()
    ->getDrawingHashTable()
    ->count();
  for ($i = 0; $i < $mediaCount; ++$i) {
    $extension = '';
    $mimeType = '';
    if ($this
      ->getParentWriter()
      ->getDrawingHashTable()
      ->getByIndex($i) instanceof PHPExcel_Worksheet_Drawing) {
      $extension = strtolower($this
        ->getParentWriter()
        ->getDrawingHashTable()
        ->getByIndex($i)
        ->getExtension());
      $mimeType = $this
        ->_getImageMimeType($this
        ->getParentWriter()
        ->getDrawingHashTable()
        ->getByIndex($i)
        ->getPath());
    }
    else {
      if ($this
        ->getParentWriter()
        ->getDrawingHashTable()
        ->getByIndex($i) instanceof PHPExcel_Worksheet_MemoryDrawing) {
        $extension = strtolower($this
          ->getParentWriter()
          ->getDrawingHashTable()
          ->getByIndex($i)
          ->getMimeType());
        $extension = explode('/', $extension);
        $extension = $extension[1];
        $mimeType = $this
          ->getParentWriter()
          ->getDrawingHashTable()
          ->getByIndex($i)
          ->getMimeType();
      }
    }
    if (!isset($aMediaContentTypes[$extension])) {
      $aMediaContentTypes[$extension] = $mimeType;
      $this
        ->_writeDefaultContentType($objWriter, $extension, $mimeType);
    }
  }
  if ($pPHPExcel
    ->hasRibbonBinObjects()) {

    //Some additional objects in the ribbon ?

    //we need to write "Extension" but not already write for media content
    $tabRibbonTypes = array_diff($pPHPExcel
      ->getRibbonBinObjects('types'), array_keys($aMediaContentTypes));
    foreach ($tabRibbonTypes as $aRibbonType) {
      $mimeType = 'image/.' . $aRibbonType;

      //we wrote $mimeType like customUI Editor
      $this
        ->_writeDefaultContentType($objWriter, $aRibbonType, $mimeType);
    }
  }
  $sheetCount = $pPHPExcel
    ->getSheetCount();
  for ($i = 0; $i < $sheetCount; ++$i) {
    if (count($pPHPExcel
      ->getSheet()
      ->getHeaderFooter()
      ->getImages()) > 0) {
      foreach ($pPHPExcel
        ->getSheet()
        ->getHeaderFooter()
        ->getImages() as $image) {
        if (!isset($aMediaContentTypes[strtolower($image
          ->getExtension())])) {
          $aMediaContentTypes[strtolower($image
            ->getExtension())] = $this
            ->_getImageMimeType($image
            ->getPath());
          $this
            ->_writeDefaultContentType($objWriter, strtolower($image
            ->getExtension()), $aMediaContentTypes[strtolower($image
            ->getExtension())]);
        }
      }
    }
  }
  $objWriter
    ->endElement();

  // Return
  return $objWriter
    ->getData();
}