Subversion Repositories eFlore/Applications.cel

Rev

Rev 2388 | Blame | Compare with Previous | Last modification | View Log | RSS feed

<?php
/**
 * PHPExcel
 *
 * Copyright (c) 2006 - 2013 PHPExcel
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 *
 * @category   PHPExcel
 * @package     PHPExcel_Writer_CSV
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license     http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt   LGPL
 * @version     ##VERSION##, ##DATE##
 */


/**
 * PHPExcel_Writer_CSV
 *
 * @category   PHPExcel
 * @package     PHPExcel_Writer_CSV
 * @copyright  Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
 */
class PHPExcel_Writer_CSV extends PHPExcel_Writer_Abstract implements PHPExcel_Writer_IWriter {
        /**
         * PHPExcel object
         *
         * @var PHPExcel
         */
        private $_phpExcel;

        /**
         * Delimiter
         *
         * @var string
         */
        private $_delimiter     = ',';

        /**
         * Enclosure
         *
         * @var string
         */
        private $_enclosure     = '"';

        /**
         * Line ending
         *
         * @var string
         */
        private $_lineEnding    = PHP_EOL;

        /**
         * Sheet index to write
         *
         * @var int
         */
        private $_sheetIndex    = 0;

        /**
         * Whether to write a BOM (for UTF8).
         *
         * @var boolean
         */
        private $_useBOM = false;

        /**
         * Whether to write a fully Excel compatible CSV file.
         *
         * @var boolean
         */
        private $_excelCompatibility = false;

        /**
         * Create a new PHPExcel_Writer_CSV
         *
         * @param       PHPExcel        $phpExcel       PHPExcel object
         */
        public function __construct(PHPExcel $phpExcel) {
                $this->_phpExcel        = $phpExcel;
        }

        /**
         * Save PHPExcel to file
         *
         * @param       string          $pFilename
         * @throws      PHPExcel_Writer_Exception
         */
        public function save($pFilename = null) {
                // Fetch sheet
                $sheet = $this->_phpExcel->getSheet($this->_sheetIndex);

                $saveDebugLog = PHPExcel_Calculation::getInstance($this->_phpExcel)->getDebugLog()->getWriteDebugLog();
                PHPExcel_Calculation::getInstance($this->_phpExcel)->getDebugLog()->setWriteDebugLog(FALSE);
                $saveArrayReturnType = PHPExcel_Calculation::getArrayReturnType();
                PHPExcel_Calculation::setArrayReturnType(PHPExcel_Calculation::RETURN_ARRAY_AS_VALUE);

                // Open file
                $fileHandle = fopen($pFilename, 'wb+');
                if ($fileHandle === false) {
                        throw new PHPExcel_Writer_Exception("Could not open file $pFilename for writing.");
                }

                if ($this->_excelCompatibility) {
                        // Write the UTF-16LE BOM code
                        fwrite($fileHandle, "\xFF\xFE");        //      Excel uses UTF-16LE encoding
                        $this->setEnclosure();                          //      Default enclosure is "
                        $this->setDelimiter("\t");                      //      Excel delimiter is a TAB
                } elseif ($this->_useBOM) {
                        // Write the UTF-8 BOM code
                        fwrite($fileHandle, "\xEF\xBB\xBF");
                }

                //      Identify the range that we need to extract from the worksheet
                $maxCol = $sheet->getHighestColumn();
                $maxRow = $sheet->getHighestRow();

                // Write rows to file
                for($row = 1; $row <= $maxRow; ++$row) {
                        // Convert the row to an array...
                        $cellsArray = $sheet->rangeToArray('A'.$row.':'.$maxCol.$row,'', $this->_preCalculateFormulas);
                        // ... and write to the file
                        $this->_writeLine($fileHandle, $cellsArray[0]);
                }

                // Close file
                fclose($fileHandle);

                PHPExcel_Calculation::setArrayReturnType($saveArrayReturnType);
                PHPExcel_Calculation::getInstance($this->_phpExcel)->getDebugLog()->setWriteDebugLog($saveDebugLog);
        }

        /**
         * Get delimiter
         *
         * @return string
         */
        public function getDelimiter() {
                return $this->_delimiter;
        }

        /**
         * Set delimiter
         *
         * @param       string  $pValue         Delimiter, defaults to ,
         * @return PHPExcel_Writer_CSV
         */
        public function setDelimiter($pValue = ',') {
                $this->_delimiter = $pValue;
                return $this;
        }

        /**
         * Get enclosure
         *
         * @return string
         */
        public function getEnclosure() {
                return $this->_enclosure;
        }

        /**
         * Set enclosure
         *
         * @param       string  $pValue         Enclosure, defaults to "
         * @return PHPExcel_Writer_CSV
         */
        public function setEnclosure($pValue = '"') {
                if ($pValue == '') {
                        $pValue = null;
                }
                $this->_enclosure = $pValue;
                return $this;
        }

        /**
         * Get line ending
         *
         * @return string
         */
        public function getLineEnding() {
                return $this->_lineEnding;
        }

        /**
         * Set line ending
         *
         * @param       string  $pValue         Line ending, defaults to OS line ending (PHP_EOL)
         * @return PHPExcel_Writer_CSV
         */
        public function setLineEnding($pValue = PHP_EOL) {
                $this->_lineEnding = $pValue;
                return $this;
        }

        /**
         * Get whether BOM should be used
         *
         * @return boolean
         */
        public function getUseBOM() {
                return $this->_useBOM;
        }

        /**
         * Set whether BOM should be used
         *
         * @param       boolean $pValue         Use UTF-8 byte-order mark? Defaults to false
         * @return PHPExcel_Writer_CSV
         */
        public function setUseBOM($pValue = false) {
                $this->_useBOM = $pValue;
                return $this;
        }

        /**
         * Get whether the file should be saved with full Excel Compatibility
         *
         * @return boolean
         */
        public function getExcelCompatibility() {
                return $this->_excelCompatibility;
        }

        /**
         * Set whether the file should be saved with full Excel Compatibility
         *
         * @param       boolean $pValue         Set the file to be written as a fully Excel compatible csv file
         *                                                              Note that this overrides other settings such as useBOM, enclosure and delimiter
         * @return PHPExcel_Writer_CSV
         */
        public function setExcelCompatibility($pValue = false) {
                $this->_excelCompatibility = $pValue;
                return $this;
        }

        /**
         * Get sheet index
         *
         * @return int
         */
        public function getSheetIndex() {
                return $this->_sheetIndex;
        }

        /**
         * Set sheet index
         *
         * @param       int             $pValue         Sheet index
         * @return PHPExcel_Writer_CSV
         */
        public function setSheetIndex($pValue = 0) {
                $this->_sheetIndex = $pValue;
                return $this;
        }

        /**
         * Write line to CSV file
         *
         * @param       mixed   $pFileHandle    PHP filehandle
         * @param       array   $pValues                Array containing values in a row
         * @throws      PHPExcel_Writer_Exception
         */
        private function _writeLine($pFileHandle = null, $pValues = null) {
                if (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
                        if ($this->_excelCompatibility) {
                                fwrite($pFileHandle, mb_convert_encoding($line,"UTF-16LE","UTF-8"));
                        } else {
                                fwrite($pFileHandle, $line);
                        }
                } else {
                        throw new PHPExcel_Writer_Exception("Invalid data row passed to CSV writer.");
                }
        }

}