PHPExcel has not been loaded. Include PHPExcel.php in your script, e.g. require_once \'PHPExcel.php\'.'); } else { // Create new PHPPresentation object echo date('H:i:s') . ' Create new PHPPresentation object'.EOL; $objPHPPresentation = new PhpPresentation(); // Set properties echo date('H:i:s') . ' Set properties'.EOL; $objPHPPresentation->getDocumentProperties()->setCreator('PHPOffice') ->setLastModifiedBy('PHPPresentation Team') ->setTitle('Sample 08 Title') ->setSubject('Sample 08 Subject') ->setDescription('Sample 08 Description') ->setKeywords('office 2007 openxml libreoffice odt php') ->setCategory('Sample Category'); // Remove first slide echo date('H:i:s') . ' Remove first slide'.EOL; $objPHPPresentation->removeSlideByIndex(0); // Create templated slide echo date('H:i:s') . ' Create templated slide'.EOL; $currentSlide = createTemplatedSlide($objPHPPresentation); // local function // Generate sample data for first chart echo date('H:i:s') . ' Generate sample data for first chart'.EOL; $series1Data = array('Jan' => 133, 'Feb' => 99, 'Mar' => 191, 'Apr' => 205, 'May' => 167, 'Jun' => 201, 'Jul' => 240, 'Aug' => 226, 'Sep' => 255, 'Oct' => 264, 'Nov' => 283, 'Dec' => 293); $series2Data = array('Jan' => 266, 'Feb' => 198, 'Mar' => 271, 'Apr' => 305, 'May' => 267, 'Jun' => 301, 'Jul' => 340, 'Aug' => 326, 'Sep' => 344, 'Oct' => 364, 'Nov' => 383, 'Dec' => 379); // Create a bar chart (that should be inserted in a shape) echo date('H:i:s') . ' Create a bar chart (that should be inserted in a chart shape)'.EOL; $bar3DChart = new Bar3D(); $bar3DChart->addSeries( new Series('2009', $series1Data) ); $bar3DChart->addSeries( new Series('2010', $series2Data) ); // Create a shape (chart) echo date('H:i:s') . ' Create a shape (chart)'.EOL; $shape = $currentSlide->createChartShape(); $shape->setName('PHPPresentation Monthly Downloads') ->setResizeProportional(false) ->setHeight(550) ->setWidth(700) ->setOffsetX(120) ->setOffsetY(80) ->setIncludeSpreadsheet(true); $shape->getShadow()->setVisible(true) ->setDirection(45) ->setDistance(10); $shape->getFill()->setFillType(Fill::FILL_GRADIENT_LINEAR) ->setStartColor(new Color('FFCCCCCC')) ->setEndColor(new Color('FFFFFFFF')) ->setRotation(270); $shape->getBorder()->setLineStyle(Border::LINE_SINGLE); $shape->getTitle()->setText('PHPPresentation Monthly Downloads'); $shape->getTitle()->getFont()->setItalic(true); $shape->getPlotArea()->getAxisX()->setTitle('Month'); $shape->getPlotArea()->getAxisY()->setTitle('Downloads'); $shape->getPlotArea()->setType($bar3DChart); $shape->getView3D()->setRightAngleAxes(true); $shape->getView3D()->setRotationX(20); $shape->getView3D()->setRotationY(20); $shape->getLegend()->getBorder()->setLineStyle(Border::LINE_SINGLE); $shape->getLegend()->getFont()->setItalic(true); // Create templated slide echo date('H:i:s') . ' Create templated slide'.EOL; $currentSlide = createTemplatedSlide($objPHPPresentation); // local function // Generate sample data for second chart echo date('H:i:s') . ' Generate sample data for second chart'.EOL; $seriesData = array('Monday' => 12, 'Tuesday' => 15, 'Wednesday' => 13, 'Thursday' => 17, 'Friday' => 14, 'Saturday' => 9, 'Sunday' => 7); // Create a pie chart (that should be inserted in a shape) echo date('H:i:s') . ' Create a pie chart (that should be inserted in a chart shape)'.EOL; $pie3DChart = new Pie3D(); $pie3DChart->addSeries( new Series('Downloads', $seriesData) ); // Create a shape (chart) echo date('H:i:s') . ' Create a shape (chart)'.EOL; $shape = $currentSlide->createChartShape(); $shape->setName('PHPPresentation Daily Downloads') ->setResizeProportional(false) ->setHeight(550) ->setWidth(700) ->setOffsetX(120) ->setOffsetY(80) ->setIncludeSpreadsheet(true); $shape->getShadow()->setVisible(true) ->setDirection(45) ->setDistance(10); $shape->getFill()->setFillType(Fill::FILL_GRADIENT_LINEAR) ->setStartColor(new Color('FFCCCCCC')) ->setEndColor(new Color('FFFFFFFF')) ->setRotation(270); $shape->getBorder()->setLineStyle(Border::LINE_SINGLE); $shape->getTitle()->setText('PHPPresentation Daily Downloads'); $shape->getTitle()->getFont()->setItalic(true); $shape->getPlotArea()->setType($pie3DChart); $shape->getView3D()->setRotationX(30); $shape->getView3D()->setPerspective(30); $shape->getLegend()->getBorder()->setLineStyle(Border::LINE_SINGLE); $shape->getLegend()->getFont()->setItalic(true); // Save file echo write($objPHPPresentation, basename(__FILE__, '.php'), $writers); } if (!CLI) { include_once 'Sample_Footer.php'; }