public function PHPExcel_Writer_Excel2007_DocProps::writeDocPropsApp in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/DocProps.php \PHPExcel_Writer_Excel2007_DocProps::writeDocPropsApp()

* Write docProps/app.xml to XML format * *

Parameters

PHPExcel $pPHPExcel: * @return string XML Output * @throws PHPExcel_Writer_Exception

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/DocProps.php, line 45

Class

PHPExcel_Writer_Excel2007_DocProps

PHPExcel_Writer_Excel2007_DocProps

Code

public function writeDocPropsApp(PHPExcel $pPHPExcel = null) {

  // 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');

  // Properties
  $objWriter
    ->startElement('Properties');
  $objWriter
    ->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/officeDocument/2006/extended-properties');
  $objWriter
    ->writeAttribute('xmlns:vt', 'http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes');

  // Application
  $objWriter
    ->writeElement('Application', 'Microsoft Excel');

  // DocSecurity
  $objWriter
    ->writeElement('DocSecurity', '0');

  // ScaleCrop
  $objWriter
    ->writeElement('ScaleCrop', 'false');

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

  // Vector
  $objWriter
    ->startElement('vt:vector');
  $objWriter
    ->writeAttribute('size', '2');
  $objWriter
    ->writeAttribute('baseType', 'variant');

  // Variant
  $objWriter
    ->startElement('vt:variant');
  $objWriter
    ->writeElement('vt:lpstr', 'Worksheets');
  $objWriter
    ->endElement();

  // Variant
  $objWriter
    ->startElement('vt:variant');
  $objWriter
    ->writeElement('vt:i4', $pPHPExcel
    ->getSheetCount());
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

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

  // Vector
  $objWriter
    ->startElement('vt:vector');
  $objWriter
    ->writeAttribute('size', $pPHPExcel
    ->getSheetCount());
  $objWriter
    ->writeAttribute('baseType', 'lpstr');
  $sheetCount = $pPHPExcel
    ->getSheetCount();
  for ($i = 0; $i < $sheetCount; ++$i) {
    $objWriter
      ->writeElement('vt:lpstr', $pPHPExcel
      ->getSheet($i)
      ->getTitle());
  }
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // Company
  $objWriter
    ->writeElement('Company', $pPHPExcel
    ->getProperties()
    ->getCompany());

  // Company
  $objWriter
    ->writeElement('Manager', $pPHPExcel
    ->getProperties()
    ->getManager());

  // LinksUpToDate
  $objWriter
    ->writeElement('LinksUpToDate', 'false');

  // SharedDoc
  $objWriter
    ->writeElement('SharedDoc', 'false');

  // HyperlinksChanged
  $objWriter
    ->writeElement('HyperlinksChanged', 'false');

  // AppVersion
  $objWriter
    ->writeElement('AppVersion', '12.0000');
  $objWriter
    ->endElement();

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