PDF.php

Go to the documentation of this file.

<?php
if (!defined('PHPEXCEL_ROOT')) {
        define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
}

require_once PHPEXCEL_ROOT . 'PHPExcel/Writer/IWriter.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Writer/HTML.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Cell.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/RichText.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Shared/Drawing.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/HashTable.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/Shared/PDF.php';


class PHPExcel_Writer_PDF extends PHPExcel_Writer_HTML implements PHPExcel_Writer_IWriter {
        private $_tempDir = '';

        public function __construct(PHPExcel $phpExcel) {
                parent::__construct($phpExcel);
                $this->setUseInlineCss(true);
                $this->_tempDir = sys_get_temp_dir();
        }

        public function save($pFilename = null) {
                // garbage collect
                $this->_phpExcel->garbageCollect();

                $saveArrayReturnType = PHPExcel_Calculation::getArrayReturnType();
                PHPExcel_Calculation::setArrayReturnType(PHPExcel_Calculation::RETURN_ARRAY_AS_VALUE);

                // Open file
                $fileHandle = fopen($pFilename, 'w');
                if ($fileHandle === false) {
                        throw new Exception("Could not open file $pFilename for writing.");
                }
                
                // Set PDF
                $this->_isPdf = true;

                // Build CSS
                $this->buildCSS(true);

                // Generate HTML
                $html = '';
                //$html .= $this->generateHTMLHeader(false);
                $html .= $this->generateSheetData();
                //$html .= $this->generateHTMLFooter();

        // Default PDF paper size
        $paperSize = 'A4';
        $orientation = 'P';
                
        // Check for overrides
                if (is_null($this->getSheetIndex())) {
                        $orientation = $this->_phpExcel->getSheet(0)->getPageSetup()->getOrientation() == 'landscape' ? 'L' : 'P';
                } else {
                        $orientation = $this->_phpExcel->getSheet($this->getSheetIndex())->getPageSetup()->getOrientation() == 'landscape' ? 'L' : 'P';
                }

                // Create PDF
                $pdf = new TCPDF($orientation, 'pt', $paperSize);
                $pdf->setPrintHeader(false);
                $pdf->setPrintFooter(false);
                $pdf->AddPage();
                $pdf->SetFont('freesans');
                $pdf->writeHTML($html);

                // Document info
                $pdf->SetTitle($this->_phpExcel->getProperties()->getTitle());
                $pdf->SetAuthor($this->_phpExcel->getProperties()->getCreator());
                $pdf->SetSubject($this->_phpExcel->getProperties()->getSubject());
                $pdf->SetKeywords($this->_phpExcel->getProperties()->getKeywords());
                $pdf->SetCreator($this->_phpExcel->getProperties()->getCreator());

                // Write to file
                fwrite($fileHandle, $pdf->output($pFilename, 'S'));

                // Close file
                fclose($fileHandle);

                PHPExcel_Calculation::setArrayReturnType($saveArrayReturnType);
        }

        public function getTempDir() {
                return $this->_tempDir;
        }

        public function setTempDir($pValue = '') {
                if (is_dir($pValue)) {
                        $this->_tempDir = $pValue;
                } else {
                        throw new Exception("Directory does not exist: $pValue");
                }
                return $this;
        }
}