CSV.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/Cell.php';

require_once PHPEXCEL_ROOT . 'PHPExcel/RichText.php';

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


class PHPExcel_Writer_CSV implements PHPExcel_Writer_IWriter {
        private $_phpExcel;

        private $_delimiter;

        private $_enclosure;

        private $_lineEnding;

        private $_sheetIndex;

        private $_preCalculateFormulas = true;

        private $_useBOM = false;

        public function __construct(PHPExcel $phpExcel) {
                $this->_phpExcel        = $phpExcel;
                $this->_delimiter       = ',';
                $this->_enclosure       = '"';
                $this->_lineEnding      = PHP_EOL;
                $this->_sheetIndex      = 0;
        }

        public function save($pFilename = null) {
                // Fetch sheet
                $sheet = $this->_phpExcel->getSheet($this->_sheetIndex);

                $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.");
                }

                if ($this->_useBOM) {
                        // Write the UTF-8 BOM code
                        fwrite($fileHandle, "\xEF\xBB\xBF");
                }

                // Convert sheet to array
                $cellsArray = $sheet->toArray('', $this->_preCalculateFormulas);

                // Write rows to file
                foreach ($cellsArray as $row) {
                        $this->_writeLine($fileHandle, $row);
                }

                // Close file
                fclose($fileHandle);

                PHPExcel_Calculation::setArrayReturnType($saveArrayReturnType);
        }

        public function getDelimiter() {
                return $this->_delimiter;
        }

        public function setDelimiter($pValue = ',') {
                $this->_delimiter = $pValue;
                return $this;
        }

        public function getEnclosure() {
                return $this->_enclosure;
        }

        public function setEnclosure($pValue = '"') {
                if ($pValue == '') {
                        $pValue = null;
                }
                $this->_enclosure = $pValue;
                return $this;
        }

        public function getLineEnding() {
                return $this->_lineEnding;
        }

        public function setLineEnding($pValue = PHP_EOL) {
                $this->_lineEnding = $pValue;
                return $this;
        }

        public function getUseBOM() {
                return $this->_useBOM;
        }

        public function setUseBOM($pValue = false) {
                $this->_useBOM = $pValue;
                return $this;
        }

        public function getSheetIndex() {
                return $this->_sheetIndex;
        }

        public function setSheetIndex($pValue = 0) {
                $this->_sheetIndex = $pValue;
                return $this;
        }

        private function _writeLine($pFileHandle = null, $pValues = null) {
                if (!is_null($pFileHandle) && is_array($pValues)) {
                        // No leading delimiter
                        $writeDelimiter = false;

                        // Build the line
                        $line = '';

                        foreach ($pValues as $element) {
                                // Escape enclosures
                                $element = str_replace($this->_enclosure, $this->_enclosure . $this->_enclosure, $element);

                                // Add delimiter
                                if ($writeDelimiter) {
                                        $line .= $this->_delimiter;
                                } else {
                                        $writeDelimiter = true;
                                }

                                // Add enclosed string
                                $line .= $this->_enclosure . $element . $this->_enclosure;
                        }

                        // Add line ending
                        $line .= $this->_lineEnding;

                        // Write to file
                        fwrite($pFileHandle, $line);
                } else {
                        throw new Exception("Invalid parameters passed.");
                }
        }

    public function getPreCalculateFormulas() {
        return $this->_preCalculateFormulas;
    }

    public function setPreCalculateFormulas($pValue = true) {
        $this->_preCalculateFormulas = $pValue;
        return $this;
    }
}