HEADmaster

1 files changed, 0 insertions, 339 deletions

diff --git a/admin/survey/excel/PHPExcel/Writer/CSV.php b/admin/survey/excel/PHPExcel/Writer/CSV.php
deleted file mode 100644
index fdaf096..0000000
--- a/admin/survey/excel/PHPExcel/Writer/CSV.php
+++ /dev/null
@@ -1,339 +0,0 @@
-<?php

-/**

- * PHPExcel

- *

- * Copyright (c) 2006 - 2012 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

- * @copyright  Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)

- * @license	http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL

- * @version	1.7.8, 2012-10-12

- */

-

-

-/**

- * PHPExcel_Writer_CSV

- *

- * @category   PHPExcel

- * @package	PHPExcel_Writer

- * @copyright  Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)

- */

-class PHPExcel_Writer_CSV 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;

-

-	/**

-	 * Pre-calculate formulas

-	 *

-	 * @var boolean

-	 */

-	private $_preCalculateFormulas = true;

-

-	/**

-	 * 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	Exception

-	 */

-	public function save($pFilename = null) {

-		// Fetch sheet

-		$sheet = $this->_phpExcel->getSheet($this->_sheetIndex);

-

-		$saveDebugLog = PHPExcel_Calculation::getInstance()->writeDebugLog;

-		PHPExcel_Calculation::getInstance()->writeDebugLog = 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 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()->writeDebugLog = $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	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 Exception("Invalid data row passed to CSV writer.");

-		}

-	}

-

-	/**

-	 * Get Pre-Calculate Formulas

-	 *

-	 * @return boolean

-	 */

-	public function getPreCalculateFormulas() {

-		return $this->_preCalculateFormulas;

-	}

-

-	/**

-	 * Set Pre-Calculate Formulas

-	 *

-	 * @param boolean $pValue	Pre-Calculate Formulas?

-	 * @return PHPExcel_Writer_CSV

-	 */

-	public function setPreCalculateFormulas($pValue = true) {

-		$this->_preCalculateFormulas = $pValue;

-		return $this;

-	}

-}