public function PHPExcel_Writer_Excel2007_Theme::writeTheme in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Theme.php \PHPExcel_Writer_Excel2007_Theme::writeTheme()

* Write theme to XML format * *

Parameters

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

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Theme.php, line 139

Class

PHPExcel_Writer_Excel2007_Theme

PHPExcel_Writer_Excel2007_Theme

Code

public function writeTheme(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');

  // a:theme
  $objWriter
    ->startElement('a:theme');
  $objWriter
    ->writeAttribute('xmlns:a', 'http://schemas.openxmlformats.org/drawingml/2006/main');
  $objWriter
    ->writeAttribute('name', 'Office Theme');

  // a:themeElements
  $objWriter
    ->startElement('a:themeElements');

  // a:clrScheme
  $objWriter
    ->startElement('a:clrScheme');
  $objWriter
    ->writeAttribute('name', 'Office');

  // a:dk1
  $objWriter
    ->startElement('a:dk1');

  // a:sysClr
  $objWriter
    ->startElement('a:sysClr');
  $objWriter
    ->writeAttribute('val', 'windowText');
  $objWriter
    ->writeAttribute('lastClr', '000000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:lt1
  $objWriter
    ->startElement('a:lt1');

  // a:sysClr
  $objWriter
    ->startElement('a:sysClr');
  $objWriter
    ->writeAttribute('val', 'window');
  $objWriter
    ->writeAttribute('lastClr', 'FFFFFF');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:dk2
  $this
    ->_writeColourScheme($objWriter);
  $objWriter
    ->endElement();

  // a:fontScheme
  $objWriter
    ->startElement('a:fontScheme');
  $objWriter
    ->writeAttribute('name', 'Office');

  // a:majorFont
  $objWriter
    ->startElement('a:majorFont');
  $this
    ->_writeFonts($objWriter, 'Cambria', self::$_majorFonts);
  $objWriter
    ->endElement();

  // a:minorFont
  $objWriter
    ->startElement('a:minorFont');
  $this
    ->_writeFonts($objWriter, 'Calibri', self::$_minorFonts);
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:fmtScheme
  $objWriter
    ->startElement('a:fmtScheme');
  $objWriter
    ->writeAttribute('name', 'Office');

  // a:fillStyleLst
  $objWriter
    ->startElement('a:fillStyleLst');

  // a:solidFill
  $objWriter
    ->startElement('a:solidFill');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gradFill
  $objWriter
    ->startElement('a:gradFill');
  $objWriter
    ->writeAttribute('rotWithShape', '1');

  // a:gsLst
  $objWriter
    ->startElement('a:gsLst');

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '0');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:tint
  $objWriter
    ->startElement('a:tint');
  $objWriter
    ->writeAttribute('val', '50000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '300000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '35000');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:tint
  $objWriter
    ->startElement('a:tint');
  $objWriter
    ->writeAttribute('val', '37000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '300000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '100000');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:tint
  $objWriter
    ->startElement('a:tint');
  $objWriter
    ->writeAttribute('val', '15000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '350000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:lin
  $objWriter
    ->startElement('a:lin');
  $objWriter
    ->writeAttribute('ang', '16200000');
  $objWriter
    ->writeAttribute('scaled', '1');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gradFill
  $objWriter
    ->startElement('a:gradFill');
  $objWriter
    ->writeAttribute('rotWithShape', '1');

  // a:gsLst
  $objWriter
    ->startElement('a:gsLst');

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '0');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:shade
  $objWriter
    ->startElement('a:shade');
  $objWriter
    ->writeAttribute('val', '51000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '130000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '80000');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:shade
  $objWriter
    ->startElement('a:shade');
  $objWriter
    ->writeAttribute('val', '93000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '130000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '100000');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:shade
  $objWriter
    ->startElement('a:shade');
  $objWriter
    ->writeAttribute('val', '94000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '135000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:lin
  $objWriter
    ->startElement('a:lin');
  $objWriter
    ->writeAttribute('ang', '16200000');
  $objWriter
    ->writeAttribute('scaled', '0');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:lnStyleLst
  $objWriter
    ->startElement('a:lnStyleLst');

  // a:ln
  $objWriter
    ->startElement('a:ln');
  $objWriter
    ->writeAttribute('w', '9525');
  $objWriter
    ->writeAttribute('cap', 'flat');
  $objWriter
    ->writeAttribute('cmpd', 'sng');
  $objWriter
    ->writeAttribute('algn', 'ctr');

  // a:solidFill
  $objWriter
    ->startElement('a:solidFill');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:shade
  $objWriter
    ->startElement('a:shade');
  $objWriter
    ->writeAttribute('val', '95000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '105000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:prstDash
  $objWriter
    ->startElement('a:prstDash');
  $objWriter
    ->writeAttribute('val', 'solid');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:ln
  $objWriter
    ->startElement('a:ln');
  $objWriter
    ->writeAttribute('w', '25400');
  $objWriter
    ->writeAttribute('cap', 'flat');
  $objWriter
    ->writeAttribute('cmpd', 'sng');
  $objWriter
    ->writeAttribute('algn', 'ctr');

  // a:solidFill
  $objWriter
    ->startElement('a:solidFill');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:prstDash
  $objWriter
    ->startElement('a:prstDash');
  $objWriter
    ->writeAttribute('val', 'solid');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:ln
  $objWriter
    ->startElement('a:ln');
  $objWriter
    ->writeAttribute('w', '38100');
  $objWriter
    ->writeAttribute('cap', 'flat');
  $objWriter
    ->writeAttribute('cmpd', 'sng');
  $objWriter
    ->writeAttribute('algn', 'ctr');

  // a:solidFill
  $objWriter
    ->startElement('a:solidFill');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:prstDash
  $objWriter
    ->startElement('a:prstDash');
  $objWriter
    ->writeAttribute('val', 'solid');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:effectStyleLst
  $objWriter
    ->startElement('a:effectStyleLst');

  // a:effectStyle
  $objWriter
    ->startElement('a:effectStyle');

  // a:effectLst
  $objWriter
    ->startElement('a:effectLst');

  // a:outerShdw
  $objWriter
    ->startElement('a:outerShdw');
  $objWriter
    ->writeAttribute('blurRad', '40000');
  $objWriter
    ->writeAttribute('dist', '20000');
  $objWriter
    ->writeAttribute('dir', '5400000');
  $objWriter
    ->writeAttribute('rotWithShape', '0');

  // a:srgbClr
  $objWriter
    ->startElement('a:srgbClr');
  $objWriter
    ->writeAttribute('val', '000000');

  // a:alpha
  $objWriter
    ->startElement('a:alpha');
  $objWriter
    ->writeAttribute('val', '38000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:effectStyle
  $objWriter
    ->startElement('a:effectStyle');

  // a:effectLst
  $objWriter
    ->startElement('a:effectLst');

  // a:outerShdw
  $objWriter
    ->startElement('a:outerShdw');
  $objWriter
    ->writeAttribute('blurRad', '40000');
  $objWriter
    ->writeAttribute('dist', '23000');
  $objWriter
    ->writeAttribute('dir', '5400000');
  $objWriter
    ->writeAttribute('rotWithShape', '0');

  // a:srgbClr
  $objWriter
    ->startElement('a:srgbClr');
  $objWriter
    ->writeAttribute('val', '000000');

  // a:alpha
  $objWriter
    ->startElement('a:alpha');
  $objWriter
    ->writeAttribute('val', '35000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:effectStyle
  $objWriter
    ->startElement('a:effectStyle');

  // a:effectLst
  $objWriter
    ->startElement('a:effectLst');

  // a:outerShdw
  $objWriter
    ->startElement('a:outerShdw');
  $objWriter
    ->writeAttribute('blurRad', '40000');
  $objWriter
    ->writeAttribute('dist', '23000');
  $objWriter
    ->writeAttribute('dir', '5400000');
  $objWriter
    ->writeAttribute('rotWithShape', '0');

  // a:srgbClr
  $objWriter
    ->startElement('a:srgbClr');
  $objWriter
    ->writeAttribute('val', '000000');

  // a:alpha
  $objWriter
    ->startElement('a:alpha');
  $objWriter
    ->writeAttribute('val', '35000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:scene3d
  $objWriter
    ->startElement('a:scene3d');

  // a:camera
  $objWriter
    ->startElement('a:camera');
  $objWriter
    ->writeAttribute('prst', 'orthographicFront');

  // a:rot
  $objWriter
    ->startElement('a:rot');
  $objWriter
    ->writeAttribute('lat', '0');
  $objWriter
    ->writeAttribute('lon', '0');
  $objWriter
    ->writeAttribute('rev', '0');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:lightRig
  $objWriter
    ->startElement('a:lightRig');
  $objWriter
    ->writeAttribute('rig', 'threePt');
  $objWriter
    ->writeAttribute('dir', 't');

  // a:rot
  $objWriter
    ->startElement('a:rot');
  $objWriter
    ->writeAttribute('lat', '0');
  $objWriter
    ->writeAttribute('lon', '0');
  $objWriter
    ->writeAttribute('rev', '1200000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:sp3d
  $objWriter
    ->startElement('a:sp3d');

  // a:bevelT
  $objWriter
    ->startElement('a:bevelT');
  $objWriter
    ->writeAttribute('w', '63500');
  $objWriter
    ->writeAttribute('h', '25400');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:bgFillStyleLst
  $objWriter
    ->startElement('a:bgFillStyleLst');

  // a:solidFill
  $objWriter
    ->startElement('a:solidFill');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gradFill
  $objWriter
    ->startElement('a:gradFill');
  $objWriter
    ->writeAttribute('rotWithShape', '1');

  // a:gsLst
  $objWriter
    ->startElement('a:gsLst');

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '0');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:tint
  $objWriter
    ->startElement('a:tint');
  $objWriter
    ->writeAttribute('val', '40000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '350000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '40000');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:tint
  $objWriter
    ->startElement('a:tint');
  $objWriter
    ->writeAttribute('val', '45000');
  $objWriter
    ->endElement();

  // a:shade
  $objWriter
    ->startElement('a:shade');
  $objWriter
    ->writeAttribute('val', '99000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '350000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '100000');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:shade
  $objWriter
    ->startElement('a:shade');
  $objWriter
    ->writeAttribute('val', '20000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '255000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:path
  $objWriter
    ->startElement('a:path');
  $objWriter
    ->writeAttribute('path', 'circle');

  // a:fillToRect
  $objWriter
    ->startElement('a:fillToRect');
  $objWriter
    ->writeAttribute('l', '50000');
  $objWriter
    ->writeAttribute('t', '-80000');
  $objWriter
    ->writeAttribute('r', '50000');
  $objWriter
    ->writeAttribute('b', '180000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gradFill
  $objWriter
    ->startElement('a:gradFill');
  $objWriter
    ->writeAttribute('rotWithShape', '1');

  // a:gsLst
  $objWriter
    ->startElement('a:gsLst');

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '0');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:tint
  $objWriter
    ->startElement('a:tint');
  $objWriter
    ->writeAttribute('val', '80000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '300000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:gs
  $objWriter
    ->startElement('a:gs');
  $objWriter
    ->writeAttribute('pos', '100000');

  // a:schemeClr
  $objWriter
    ->startElement('a:schemeClr');
  $objWriter
    ->writeAttribute('val', 'phClr');

  // a:shade
  $objWriter
    ->startElement('a:shade');
  $objWriter
    ->writeAttribute('val', '30000');
  $objWriter
    ->endElement();

  // a:satMod
  $objWriter
    ->startElement('a:satMod');
  $objWriter
    ->writeAttribute('val', '200000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:path
  $objWriter
    ->startElement('a:path');
  $objWriter
    ->writeAttribute('path', 'circle');

  // a:fillToRect
  $objWriter
    ->startElement('a:fillToRect');
  $objWriter
    ->writeAttribute('l', '50000');
  $objWriter
    ->writeAttribute('t', '50000');
  $objWriter
    ->writeAttribute('r', '50000');
  $objWriter
    ->writeAttribute('b', '50000');
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();
  $objWriter
    ->endElement();

  // a:objectDefaults
  $objWriter
    ->writeElement('a:objectDefaults', null);

  // a:extraClrSchemeLst
  $objWriter
    ->writeElement('a:extraClrSchemeLst', null);
  $objWriter
    ->endElement();

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