HEADmaster

1 files changed, 0 insertions, 452 deletions

diff --git a/admin/survey/excel/PHPExcel/Writer/Excel2007/Workbook.php b/admin/survey/excel/PHPExcel/Writer/Excel2007/Workbook.php
deleted file mode 100644
index 45b853b..0000000
--- a/admin/survey/excel/PHPExcel/Writer/Excel2007/Workbook.php
+++ /dev/null
@@ -1,452 +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_Excel2007

- * @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_Excel2007_Workbook

- *

- * @category   PHPExcel

- * @package    PHPExcel_Writer_Excel2007

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

- */

-class PHPExcel_Writer_Excel2007_Workbook extends PHPExcel_Writer_Excel2007_WriterPart

-{

-	/**

-	 * Write workbook to XML format

-	 *

-	 * @param 	PHPExcel	$pPHPExcel

-	 * @param	boolean		$recalcRequired	Indicate whether formulas should be recalculated before writing

-	 * @return 	string 		XML Output

-	 * @throws 	Exception

-	 */

-	public function writeWorkbook(PHPExcel $pPHPExcel = null, $recalcRequired = FALSE)

-	{

-		// Create XML writer

-		$objWriter = null;

-		if ($this->getParentWriter()->getUseDiskCaching()) {

-			$objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());

-		} else {

-			$objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);

-		}

-

-		// XML header

-		$objWriter->startDocument('1.0','UTF-8','yes');

-

-		// workbook

-		$objWriter->startElement('workbook');

-		$objWriter->writeAttribute('xml:space', 'preserve');

-		$objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');

-		$objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');

-

-			// fileVersion

-			$this->_writeFileVersion($objWriter);

-

-			// workbookPr

-			$this->_writeWorkbookPr($objWriter);

-

-			// workbookProtection

-			$this->_writeWorkbookProtection($objWriter, $pPHPExcel);

-

-			// bookViews

-			if ($this->getParentWriter()->getOffice2003Compatibility() === false) {

-				$this->_writeBookViews($objWriter, $pPHPExcel);

-			}

-

-			// sheets

-			$this->_writeSheets($objWriter, $pPHPExcel);

-

-			// definedNames

-			$this->_writeDefinedNames($objWriter, $pPHPExcel);

-

-			// calcPr

-			$this->_writeCalcPr($objWriter,$recalcRequired);

-

-		$objWriter->endElement();

-

-		// Return

-		return $objWriter->getData();

-	}

-

-	/**

-	 * Write file version

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter $objWriter 		XML Writer

-	 * @throws 	Exception

-	 */

-	private function _writeFileVersion(PHPExcel_Shared_XMLWriter $objWriter = null)

-	{

-		$objWriter->startElement('fileVersion');

-		$objWriter->writeAttribute('appName', 'xl');

-		$objWriter->writeAttribute('lastEdited', '4');

-		$objWriter->writeAttribute('lowestEdited', '4');

-		$objWriter->writeAttribute('rupBuild', '4505');

-		$objWriter->endElement();

-	}

-

-	/**

-	 * Write WorkbookPr

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter $objWriter 		XML Writer

-	 * @throws 	Exception

-	 */

-	private function _writeWorkbookPr(PHPExcel_Shared_XMLWriter $objWriter = null)

-	{

-		$objWriter->startElement('workbookPr');

-

-		if (PHPExcel_Shared_Date::getExcelCalendar() == PHPExcel_Shared_Date::CALENDAR_MAC_1904) {

-			$objWriter->writeAttribute('date1904', '1');

-		}

-

-		$objWriter->writeAttribute('codeName', 'ThisWorkbook');

-

-		$objWriter->endElement();

-	}

-

-	/**

-	 * Write BookViews

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter 	$objWriter 		XML Writer

-	 * @param 	PHPExcel					$pPHPExcel

-	 * @throws 	Exception

-	 */

-	private function _writeBookViews(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel $pPHPExcel = null)

-	{

-		// bookViews

-		$objWriter->startElement('bookViews');

-

-			// workbookView

-			$objWriter->startElement('workbookView');

-

-			$objWriter->writeAttribute('activeTab', $pPHPExcel->getActiveSheetIndex());

-			$objWriter->writeAttribute('autoFilterDateGrouping', '1');

-			$objWriter->writeAttribute('firstSheet', '0');

-			$objWriter->writeAttribute('minimized', '0');

-			$objWriter->writeAttribute('showHorizontalScroll', '1');

-			$objWriter->writeAttribute('showSheetTabs', '1');

-			$objWriter->writeAttribute('showVerticalScroll', '1');

-			$objWriter->writeAttribute('tabRatio', '600');

-			$objWriter->writeAttribute('visibility', 'visible');

-

-			$objWriter->endElement();

-

-		$objWriter->endElement();

-	}

-

-	/**

-	 * Write WorkbookProtection

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter 	$objWriter 		XML Writer

-	 * @param 	PHPExcel					$pPHPExcel

-	 * @throws 	Exception

-	 */

-	private function _writeWorkbookProtection(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel $pPHPExcel = null)

-	{

-		if ($pPHPExcel->getSecurity()->isSecurityEnabled()) {

-			$objWriter->startElement('workbookProtection');

-			$objWriter->writeAttribute('lockRevision',		($pPHPExcel->getSecurity()->getLockRevision() ? 'true' : 'false'));

-			$objWriter->writeAttribute('lockStructure', 	($pPHPExcel->getSecurity()->getLockStructure() ? 'true' : 'false'));

-			$objWriter->writeAttribute('lockWindows', 		($pPHPExcel->getSecurity()->getLockWindows() ? 'true' : 'false'));

-

-			if ($pPHPExcel->getSecurity()->getRevisionsPassword() != '') {

-				$objWriter->writeAttribute('revisionsPassword',	$pPHPExcel->getSecurity()->getRevisionsPassword());

-			}

-

-			if ($pPHPExcel->getSecurity()->getWorkbookPassword() != '') {

-				$objWriter->writeAttribute('workbookPassword',	$pPHPExcel->getSecurity()->getWorkbookPassword());

-			}

-

-			$objWriter->endElement();

-		}

-	}

-

-	/**

-	 * Write calcPr

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter	$objWriter		XML Writer

-	 * @param	boolean						$recalcRequired	Indicate whether formulas should be recalculated before writing

-	 * @throws 	Exception

-	 */

-	private function _writeCalcPr(PHPExcel_Shared_XMLWriter $objWriter = null, $recalcRequired = TRUE)

-	{

-		$objWriter->startElement('calcPr');

-

-		$objWriter->writeAttribute('calcId', 			'124519');

-		$objWriter->writeAttribute('calcMode', 			'auto');

-		//	fullCalcOnLoad isn't needed if we've recalculating for the save

-		$objWriter->writeAttribute('fullCalcOnLoad', 	($recalcRequired) ? '0' : '1');

-

-		$objWriter->endElement();

-	}

-

-	/**

-	 * Write sheets

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter 	$objWriter 		XML Writer

-	 * @param 	PHPExcel					$pPHPExcel

-	 * @throws 	Exception

-	 */

-	private function _writeSheets(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel $pPHPExcel = null)

-	{

-		// Write sheets

-		$objWriter->startElement('sheets');

-		$sheetCount = $pPHPExcel->getSheetCount();

-		for ($i = 0; $i < $sheetCount; ++$i) {

-			// sheet

-			$this->_writeSheet(

-				$objWriter,

-				$pPHPExcel->getSheet($i)->getTitle(),

-				($i + 1),

-				($i + 1 + 3),

-				$pPHPExcel->getSheet($i)->getSheetState()

-			);

-		}

-

-		$objWriter->endElement();

-	}

-

-	/**

-	 * Write sheet

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter 	$objWriter 		XML Writer

-	 * @param 	string 						$pSheetname 		Sheet name

-	 * @param 	int							$pSheetId	 		Sheet id

-	 * @param 	int							$pRelId				Relationship ID

-	 * @param   string                      $sheetState         Sheet state (visible, hidden, veryHidden)

-	 * @throws 	Exception

-	 */

-	private function _writeSheet(PHPExcel_Shared_XMLWriter $objWriter = null, $pSheetname = '', $pSheetId = 1, $pRelId = 1, $sheetState = 'visible')

-	{

-		if ($pSheetname != '') {

-			// Write sheet

-			$objWriter->startElement('sheet');

-			$objWriter->writeAttribute('name', 		$pSheetname);

-			$objWriter->writeAttribute('sheetId', 	$pSheetId);

-			if ($sheetState != 'visible' && $sheetState != '') {

-				$objWriter->writeAttribute('state', $sheetState);

-			}

-			$objWriter->writeAttribute('r:id', 		'rId' . $pRelId);

-			$objWriter->endElement();

-		} else {

-			throw new Exception("Invalid parameters passed.");

-		}

-	}

-

-	/**

-	 * Write Defined Names

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter	$objWriter 		XML Writer

-	 * @param 	PHPExcel					$pPHPExcel

-	 * @throws 	Exception

-	 */

-	private function _writeDefinedNames(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel $pPHPExcel = null)

-	{

-		// Write defined names

-		$objWriter->startElement('definedNames');

-

-		// Named ranges

-		if (count($pPHPExcel->getNamedRanges()) > 0) {

-			// Named ranges

-			$this->_writeNamedRanges($objWriter, $pPHPExcel);

-		}

-

-		// Other defined names

-		$sheetCount = $pPHPExcel->getSheetCount();

-		for ($i = 0; $i < $sheetCount; ++$i) {

-			// definedName for autoFilter

-			$this->_writeDefinedNameForAutofilter($objWriter, $pPHPExcel->getSheet($i), $i);

-

-			// definedName for Print_Titles

-			$this->_writeDefinedNameForPrintTitles($objWriter, $pPHPExcel->getSheet($i), $i);

-

-			// definedName for Print_Area

-			$this->_writeDefinedNameForPrintArea($objWriter, $pPHPExcel->getSheet($i), $i);

-		}

-

-		$objWriter->endElement();

-	}

-

-	/**

-	 * Write named ranges

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter	$objWriter 		XML Writer

-	 * @param 	PHPExcel					$pPHPExcel

-	 * @throws 	Exception

-	 */

-	private function _writeNamedRanges(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel $pPHPExcel)

-	{

-		// Loop named ranges

-		$namedRanges = $pPHPExcel->getNamedRanges();

-		foreach ($namedRanges as $namedRange) {

-			$this->_writeDefinedNameForNamedRange($objWriter, $namedRange);

-		}

-	}

-

-	/**

-	 * Write Defined Name for named range

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter	$objWriter 		XML Writer

-	 * @param 	PHPExcel_NamedRange			$pNamedRange

-	 * @throws 	Exception

-	 */

-	private function _writeDefinedNameForNamedRange(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_NamedRange $pNamedRange)

-	{

-		// definedName for named range

-		$objWriter->startElement('definedName');

-		$objWriter->writeAttribute('name',			$pNamedRange->getName());

-		if ($pNamedRange->getLocalOnly()) {

-			$objWriter->writeAttribute('localSheetId',	$pNamedRange->getScope()->getParent()->getIndex($pNamedRange->getScope()));

-		}

-

-		// Create absolute coordinate and write as raw text

-		$range = PHPExcel_Cell::splitRange($pNamedRange->getRange());

-		for ($i = 0; $i < count($range); $i++) {

-			$range[$i][0] = '\'' . str_replace("'", "''", $pNamedRange->getWorksheet()->getTitle()) . '\'!' . PHPExcel_Cell::absoluteReference($range[$i][0]);

-			if (isset($range[$i][1])) {

-				$range[$i][1] = PHPExcel_Cell::absoluteReference($range[$i][1]);

-			}

-		}

-		$range = PHPExcel_Cell::buildRange($range);

-

-		$objWriter->writeRawData($range);

-

-		$objWriter->endElement();

-	}

-

-	/**

-	 * Write Defined Name for autoFilter

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter	$objWriter 		XML Writer

-	 * @param 	PHPExcel_Worksheet			$pSheet

-	 * @param 	int							$pSheetId

-	 * @throws 	Exception

-	 */

-	private function _writeDefinedNameForAutofilter(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $pSheetId = 0)

-	{

-		// definedName for autoFilter

-		$autoFilterRange = $pSheet->getAutoFilter()->getRange();

-		if (!empty($autoFilterRange)) {

-			$objWriter->startElement('definedName');

-			$objWriter->writeAttribute('name',			'_xlnm._FilterDatabase');

-			$objWriter->writeAttribute('localSheetId',	$pSheetId);

-			$objWriter->writeAttribute('hidden',		'1');

-

-			// Create absolute coordinate and write as raw text

-			$range = PHPExcel_Cell::splitRange($autoFilterRange);

-			$range = $range[0];

-			//	Strip any worksheet ref so we can make the cell ref absolute

-			if (strpos($range[0],'!') !== false) {

-				list($ws,$range[0]) = explode('!',$range[0]);

-			}

-

-			$range[0] = PHPExcel_Cell::absoluteCoordinate($range[0]);

-			$range[1] = PHPExcel_Cell::absoluteCoordinate($range[1]);

-			$range = implode(':', $range);

-

-			$objWriter->writeRawData('\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!' . $range);

-

-			$objWriter->endElement();

-		}

-	}

-

-	/**

-	 * Write Defined Name for PrintTitles

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter	$objWriter 		XML Writer

-	 * @param 	PHPExcel_Worksheet			$pSheet

-	 * @param 	int							$pSheetId

-	 * @throws 	Exception

-	 */

-	private function _writeDefinedNameForPrintTitles(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $pSheetId = 0)

-	{

-		// definedName for PrintTitles

-		if ($pSheet->getPageSetup()->isColumnsToRepeatAtLeftSet() || $pSheet->getPageSetup()->isRowsToRepeatAtTopSet()) {

-			$objWriter->startElement('definedName');

-			$objWriter->writeAttribute('name',			'_xlnm.Print_Titles');

-			$objWriter->writeAttribute('localSheetId',	$pSheetId);

-

-			// Setting string

-			$settingString = '';

-

-			// Columns to repeat

-			if ($pSheet->getPageSetup()->isColumnsToRepeatAtLeftSet()) {

-				$repeat = $pSheet->getPageSetup()->getColumnsToRepeatAtLeft();

-

-				$settingString .= '\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!$' . $repeat[0] . ':$' . $repeat[1];

-			}

-

-			// Rows to repeat

-			if ($pSheet->getPageSetup()->isRowsToRepeatAtTopSet()) {

-				if ($pSheet->getPageSetup()->isColumnsToRepeatAtLeftSet()) {

-					$settingString .= ',';

-				}

-

-				$repeat = $pSheet->getPageSetup()->getRowsToRepeatAtTop();

-

-				$settingString .= '\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!$' . $repeat[0] . ':$' . $repeat[1];

-			}

-

-			$objWriter->writeRawData($settingString);

-

-			$objWriter->endElement();

-		}

-	}

-

-	/**

-	 * Write Defined Name for PrintTitles

-	 *

-	 * @param 	PHPExcel_Shared_XMLWriter	$objWriter 		XML Writer

-	 * @param 	PHPExcel_Worksheet			$pSheet

-	 * @param 	int							$pSheetId

-	 * @throws 	Exception

-	 */

-	private function _writeDefinedNameForPrintArea(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, $pSheetId = 0)

-	{

-		// definedName for PrintArea

-		if ($pSheet->getPageSetup()->isPrintAreaSet()) {

-			$objWriter->startElement('definedName');

-			$objWriter->writeAttribute('name',			'_xlnm.Print_Area');

-			$objWriter->writeAttribute('localSheetId',	$pSheetId);

-

-			// Setting string

-			$settingString = '';

-

-			// Print area

-			$printArea = PHPExcel_Cell::splitRange($pSheet->getPageSetup()->getPrintArea());

-

-			$chunks = array();

-			foreach ($printArea as $printAreaRect) {

-				$printAreaRect[0] = PHPExcel_Cell::absoluteReference($printAreaRect[0]);

-				$printAreaRect[1] = PHPExcel_Cell::absoluteReference($printAreaRect[1]);

-				$chunks[] = '\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!' . implode(':', $printAreaRect);

-			}

-

-			$objWriter->writeRawData(implode(',', $chunks));

-

-			$objWriter->endElement();

-		}

-	}

-}