1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153 |
- <?php
- if (!defined('PHPEXCEL_ROOT')) {
- define('PHPEXCEL_ROOT', dirname(__FILE__) . '/');
- require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
- }
- class PHPExcel
- {
-
- private $uniqueID;
-
- private $properties;
-
- private $security;
-
- private $workSheetCollection = array();
-
- private $calculationEngine;
-
- private $activeSheetIndex = 0;
-
- private $namedRanges = array();
-
- private $cellXfSupervisor;
-
- private $cellXfCollection = array();
-
- private $cellStyleXfCollection = array();
-
- private $hasMacros = false;
-
- private $macrosCode;
-
- private $macrosCertificate;
-
- private $ribbonXMLData;
-
- private $ribbonBinObjects;
-
- public function hasMacros()
- {
- return $this->hasMacros;
- }
-
- public function setHasMacros($hasMacros = false)
- {
- $this->hasMacros = (bool) $hasMacros;
- }
-
- public function setMacrosCode($MacrosCode = null)
- {
- $this->macrosCode=$MacrosCode;
- $this->setHasMacros(!is_null($MacrosCode));
- }
-
- public function getMacrosCode()
- {
- return $this->macrosCode;
- }
-
- public function setMacrosCertificate($Certificate = null)
- {
- $this->macrosCertificate=$Certificate;
- }
-
- public function hasMacrosCertificate()
- {
- return !is_null($this->macrosCertificate);
- }
-
- public function getMacrosCertificate()
- {
- return $this->macrosCertificate;
- }
-
- public function discardMacros()
- {
- $this->hasMacros=false;
- $this->macrosCode=null;
- $this->macrosCertificate=null;
- }
-
- public function setRibbonXMLData($Target = null, $XMLData = null)
- {
- if (!is_null($Target) && !is_null($XMLData)) {
- $this->ribbonXMLData = array('target' => $Target, 'data' => $XMLData);
- } else {
- $this->ribbonXMLData = null;
- }
- }
-
- public function getRibbonXMLData($What = 'all') //we need some constants here...
- {
- $ReturnData = null;
- $What = strtolower($What);
- switch ($What){
- case 'all':
- $ReturnData = $this->ribbonXMLData;
- break;
- case 'target':
- case 'data':
- if (is_array($this->ribbonXMLData) && array_key_exists($What, $this->ribbonXMLData)) {
- $ReturnData = $this->ribbonXMLData[$What];
- }
- break;
- }
- return $ReturnData;
- }
-
- public function setRibbonBinObjects($BinObjectsNames = null, $BinObjectsData = null)
- {
- if (!is_null($BinObjectsNames) && !is_null($BinObjectsData)) {
- $this->ribbonBinObjects = array('names' => $BinObjectsNames, 'data' => $BinObjectsData);
- } else {
- $this->ribbonBinObjects = null;
- }
- }
-
- private function getExtensionOnly($ThePath)
- {
- return pathinfo($ThePath, PATHINFO_EXTENSION);
- }
-
- public function getRibbonBinObjects($What = 'all')
- {
- $ReturnData = null;
- $What = strtolower($What);
- switch($What) {
- case 'all':
- return $this->ribbonBinObjects;
- break;
- case 'names':
- case 'data':
- if (is_array($this->ribbonBinObjects) && array_key_exists($What, $this->ribbonBinObjects)) {
- $ReturnData=$this->ribbonBinObjects[$What];
- }
- break;
- case 'types':
- if (is_array($this->ribbonBinObjects) &&
- array_key_exists('data', $this->ribbonBinObjects) && is_array($this->ribbonBinObjects['data'])) {
- $tmpTypes=array_keys($this->ribbonBinObjects['data']);
- $ReturnData = array_unique(array_map(array($this, 'getExtensionOnly'), $tmpTypes));
- } else {
- $ReturnData=array();
- }
- break;
- }
- return $ReturnData;
- }
-
- public function hasRibbon()
- {
- return !is_null($this->ribbonXMLData);
- }
-
- public function hasRibbonBinObjects()
- {
- return !is_null($this->ribbonBinObjects);
- }
-
- public function sheetCodeNameExists($pSheetCodeName)
- {
- return ($this->getSheetByCodeName($pSheetCodeName) !== null);
- }
-
- public function getSheetByCodeName($pName = '')
- {
- $worksheetCount = count($this->workSheetCollection);
- for ($i = 0; $i < $worksheetCount; ++$i) {
- if ($this->workSheetCollection[$i]->getCodeName() == $pName) {
- return $this->workSheetCollection[$i];
- }
- }
- return null;
- }
-
- public function __construct()
- {
- $this->uniqueID = uniqid();
- $this->calculationEngine = new PHPExcel_Calculation($this);
-
- $this->workSheetCollection = array();
- $this->workSheetCollection[] = new PHPExcel_Worksheet($this);
- $this->activeSheetIndex = 0;
-
- $this->properties = new PHPExcel_DocumentProperties();
-
- $this->security = new PHPExcel_DocumentSecurity();
-
- $this->namedRanges = array();
-
- $this->cellXfSupervisor = new PHPExcel_Style(true);
- $this->cellXfSupervisor->bindParent($this);
-
- $this->addCellXf(new PHPExcel_Style);
- $this->addCellStyleXf(new PHPExcel_Style);
- }
-
- public function __destruct()
- {
- $this->calculationEngine = null;
- $this->disconnectWorksheets();
- }
-
- public function disconnectWorksheets()
- {
- $worksheet = null;
- foreach ($this->workSheetCollection as $k => &$worksheet) {
- $worksheet->disconnectCells();
- $this->workSheetCollection[$k] = null;
- }
- unset($worksheet);
- $this->workSheetCollection = array();
- }
-
- public function getCalculationEngine()
- {
- return $this->calculationEngine;
- }
-
- public function getProperties()
- {
- return $this->properties;
- }
-
- public function setProperties(PHPExcel_DocumentProperties $pValue)
- {
- $this->properties = $pValue;
- }
-
- public function getSecurity()
- {
- return $this->security;
- }
-
- public function setSecurity(PHPExcel_DocumentSecurity $pValue)
- {
- $this->security = $pValue;
- }
-
- public function getActiveSheet()
- {
- return $this->getSheet($this->activeSheetIndex);
- }
-
- public function createSheet($iSheetIndex = null)
- {
- $newSheet = new PHPExcel_Worksheet($this);
- $this->addSheet($newSheet, $iSheetIndex);
- return $newSheet;
- }
-
- public function sheetNameExists($pSheetName)
- {
- return ($this->getSheetByName($pSheetName) !== null);
- }
-
- public function addSheet(PHPExcel_Worksheet $pSheet, $iSheetIndex = null)
- {
- if ($this->sheetNameExists($pSheet->getTitle())) {
- throw new PHPExcel_Exception(
- "Workbook already contains a worksheet named '{$pSheet->getTitle()}'. Rename this worksheet first."
- );
- }
- if ($iSheetIndex === null) {
- if ($this->activeSheetIndex < 0) {
- $this->activeSheetIndex = 0;
- }
- $this->workSheetCollection[] = $pSheet;
- } else {
-
- array_splice(
- $this->workSheetCollection,
- $iSheetIndex,
- 0,
- array($pSheet)
- );
-
- if ($this->activeSheetIndex >= $iSheetIndex) {
- ++$this->activeSheetIndex;
- }
- }
- if ($pSheet->getParent() === null) {
- $pSheet->rebindParent($this);
- }
- return $pSheet;
- }
-
- public function removeSheetByIndex($pIndex = 0)
- {
- $numSheets = count($this->workSheetCollection);
- if ($pIndex > $numSheets - 1) {
- throw new PHPExcel_Exception(
- "You tried to remove a sheet by the out of bounds index: {$pIndex}. The actual number of sheets is {$numSheets}."
- );
- } else {
- array_splice($this->workSheetCollection, $pIndex, 1);
- }
-
- if (($this->activeSheetIndex >= $pIndex) &&
- ($pIndex > count($this->workSheetCollection) - 1)) {
- --$this->activeSheetIndex;
- }
- }
-
- public function getSheet($pIndex = 0)
- {
- if (!isset($this->workSheetCollection[$pIndex])) {
- $numSheets = $this->getSheetCount();
- throw new PHPExcel_Exception(
- "Your requested sheet index: {$pIndex} is out of bounds. The actual number of sheets is {$numSheets}."
- );
- }
- return $this->workSheetCollection[$pIndex];
- }
-
- public function getAllSheets()
- {
- return $this->workSheetCollection;
- }
-
- public function getSheetByName($pName = '')
- {
- $worksheetCount = count($this->workSheetCollection);
- for ($i = 0; $i < $worksheetCount; ++$i) {
- if ($this->workSheetCollection[$i]->getTitle() === $pName) {
- return $this->workSheetCollection[$i];
- }
- }
- return null;
- }
-
- public function getIndex(PHPExcel_Worksheet $pSheet)
- {
- foreach ($this->workSheetCollection as $key => $value) {
- if ($value->getHashCode() == $pSheet->getHashCode()) {
- return $key;
- }
- }
- throw new PHPExcel_Exception("Sheet does not exist.");
- }
-
- public function setIndexByName($sheetName, $newIndex)
- {
- $oldIndex = $this->getIndex($this->getSheetByName($sheetName));
- $pSheet = array_splice(
- $this->workSheetCollection,
- $oldIndex,
- 1
- );
- array_splice(
- $this->workSheetCollection,
- $newIndex,
- 0,
- $pSheet
- );
- return $newIndex;
- }
-
- public function getSheetCount()
- {
- return count($this->workSheetCollection);
- }
-
- public function getActiveSheetIndex()
- {
- return $this->activeSheetIndex;
- }
-
- public function setActiveSheetIndex($pIndex = 0)
- {
- $numSheets = count($this->workSheetCollection);
- if ($pIndex > $numSheets - 1) {
- throw new PHPExcel_Exception(
- "You tried to set a sheet active by the out of bounds index: {$pIndex}. The actual number of sheets is {$numSheets}."
- );
- } else {
- $this->activeSheetIndex = $pIndex;
- }
- return $this->getActiveSheet();
- }
-
- public function setActiveSheetIndexByName($pValue = '')
- {
- if (($worksheet = $this->getSheetByName($pValue)) instanceof PHPExcel_Worksheet) {
- $this->setActiveSheetIndex($this->getIndex($worksheet));
- return $worksheet;
- }
- throw new PHPExcel_Exception('Workbook does not contain sheet:' . $pValue);
- }
-
- public function getSheetNames()
- {
- $returnValue = array();
- $worksheetCount = $this->getSheetCount();
- for ($i = 0; $i < $worksheetCount; ++$i) {
- $returnValue[] = $this->getSheet($i)->getTitle();
- }
- return $returnValue;
- }
-
- public function addExternalSheet(PHPExcel_Worksheet $pSheet, $iSheetIndex = null)
- {
- if ($this->sheetNameExists($pSheet->getTitle())) {
- throw new PHPExcel_Exception("Workbook already contains a worksheet named '{$pSheet->getTitle()}'. Rename the external sheet first.");
- }
-
- $countCellXfs = count($this->cellXfCollection);
-
- foreach ($pSheet->getParent()->getCellXfCollection() as $cellXf) {
- $this->addCellXf(clone $cellXf);
- }
-
- $pSheet->rebindParent($this);
-
- foreach ($pSheet->getCellCollection(false) as $cellID) {
- $cell = $pSheet->getCell($cellID);
- $cell->setXfIndex($cell->getXfIndex() + $countCellXfs);
- }
- return $this->addSheet($pSheet, $iSheetIndex);
- }
-
- public function getNamedRanges()
- {
- return $this->namedRanges;
- }
-
- public function addNamedRange(PHPExcel_NamedRange $namedRange)
- {
- if ($namedRange->getScope() == null) {
-
- $this->namedRanges[$namedRange->getName()] = $namedRange;
- } else {
-
- $this->namedRanges[$namedRange->getScope()->getTitle().'!'.$namedRange->getName()] = $namedRange;
- }
- return true;
- }
-
- public function getNamedRange($namedRange, PHPExcel_Worksheet $pSheet = null)
- {
- $returnValue = null;
- if ($namedRange != '' && ($namedRange !== null)) {
-
- if (isset($this->namedRanges[$namedRange])) {
- $returnValue = $this->namedRanges[$namedRange];
- }
-
- if (($pSheet !== null) && isset($this->namedRanges[$pSheet->getTitle() . '!' . $namedRange])) {
- $returnValue = $this->namedRanges[$pSheet->getTitle() . '!' . $namedRange];
- }
- }
- return $returnValue;
- }
-
- public function removeNamedRange($namedRange, PHPExcel_Worksheet $pSheet = null)
- {
- if ($pSheet === null) {
- if (isset($this->namedRanges[$namedRange])) {
- unset($this->namedRanges[$namedRange]);
- }
- } else {
- if (isset($this->namedRanges[$pSheet->getTitle() . '!' . $namedRange])) {
- unset($this->namedRanges[$pSheet->getTitle() . '!' . $namedRange]);
- }
- }
- return $this;
- }
-
- public function getWorksheetIterator()
- {
- return new PHPExcel_WorksheetIterator($this);
- }
-
- public function copy()
- {
- $copied = clone $this;
- $worksheetCount = count($this->workSheetCollection);
- for ($i = 0; $i < $worksheetCount; ++$i) {
- $this->workSheetCollection[$i] = $this->workSheetCollection[$i]->copy();
- $this->workSheetCollection[$i]->rebindParent($this);
- }
- return $copied;
- }
-
- public function __clone()
- {
- foreach ($this as $key => $val) {
- if (is_object($val) || (is_array($val))) {
- $this->{$key} = unserialize(serialize($val));
- }
- }
- }
-
- public function getCellXfCollection()
- {
- return $this->cellXfCollection;
- }
-
- public function getCellXfByIndex($pIndex = 0)
- {
- return $this->cellXfCollection[$pIndex];
- }
-
- public function getCellXfByHashCode($pValue = '')
- {
- foreach ($this->cellXfCollection as $cellXf) {
- if ($cellXf->getHashCode() == $pValue) {
- return $cellXf;
- }
- }
- return false;
- }
-
- public function cellXfExists($pCellStyle = null)
- {
- return in_array($pCellStyle, $this->cellXfCollection, true);
- }
-
- public function getDefaultStyle()
- {
- if (isset($this->cellXfCollection[0])) {
- return $this->cellXfCollection[0];
- }
- throw new PHPExcel_Exception('No default style found for this workbook');
- }
-
- public function addCellXf(PHPExcel_Style $style)
- {
- $this->cellXfCollection[] = $style;
- $style->setIndex(count($this->cellXfCollection) - 1);
- }
-
- public function removeCellXfByIndex($pIndex = 0)
- {
- if ($pIndex > count($this->cellXfCollection) - 1) {
- throw new PHPExcel_Exception("CellXf index is out of bounds.");
- } else {
-
- array_splice($this->cellXfCollection, $pIndex, 1);
-
- foreach ($this->workSheetCollection as $worksheet) {
- foreach ($worksheet->getCellCollection(false) as $cellID) {
- $cell = $worksheet->getCell($cellID);
- $xfIndex = $cell->getXfIndex();
- if ($xfIndex > $pIndex) {
-
- $cell->setXfIndex($xfIndex - 1);
- } elseif ($xfIndex == $pIndex) {
-
- $cell->setXfIndex(0);
- }
- }
- }
- }
- }
-
- public function getCellXfSupervisor()
- {
- return $this->cellXfSupervisor;
- }
-
- public function getCellStyleXfCollection()
- {
- return $this->cellStyleXfCollection;
- }
-
- public function getCellStyleXfByIndex($pIndex = 0)
- {
- return $this->cellStyleXfCollection[$pIndex];
- }
-
- public function getCellStyleXfByHashCode($pValue = '')
- {
- foreach ($this->cellStyleXfCollection as $cellStyleXf) {
- if ($cellStyleXf->getHashCode() == $pValue) {
- return $cellStyleXf;
- }
- }
- return false;
- }
-
- public function addCellStyleXf(PHPExcel_Style $pStyle)
- {
- $this->cellStyleXfCollection[] = $pStyle;
- $pStyle->setIndex(count($this->cellStyleXfCollection) - 1);
- }
-
- public function removeCellStyleXfByIndex($pIndex = 0)
- {
- if ($pIndex > count($this->cellStyleXfCollection) - 1) {
- throw new PHPExcel_Exception("CellStyleXf index is out of bounds.");
- } else {
- array_splice($this->cellStyleXfCollection, $pIndex, 1);
- }
- }
-
- public function garbageCollect()
- {
-
- $countReferencesCellXf = array();
- foreach ($this->cellXfCollection as $index => $cellXf) {
- $countReferencesCellXf[$index] = 0;
- }
- foreach ($this->getWorksheetIterator() as $sheet) {
-
- foreach ($sheet->getCellCollection(false) as $cellID) {
- $cell = $sheet->getCell($cellID);
- ++$countReferencesCellXf[$cell->getXfIndex()];
- }
-
- foreach ($sheet->getRowDimensions() as $rowDimension) {
- if ($rowDimension->getXfIndex() !== null) {
- ++$countReferencesCellXf[$rowDimension->getXfIndex()];
- }
- }
-
- foreach ($sheet->getColumnDimensions() as $columnDimension) {
- ++$countReferencesCellXf[$columnDimension->getXfIndex()];
- }
- }
-
-
- $countNeededCellXfs = 0;
- $map = array();
- foreach ($this->cellXfCollection as $index => $cellXf) {
- if ($countReferencesCellXf[$index] > 0 || $index == 0) {
- ++$countNeededCellXfs;
- } else {
- unset($this->cellXfCollection[$index]);
- }
- $map[$index] = $countNeededCellXfs - 1;
- }
- $this->cellXfCollection = array_values($this->cellXfCollection);
-
- foreach ($this->cellXfCollection as $i => $cellXf) {
- $cellXf->setIndex($i);
- }
-
- if (empty($this->cellXfCollection)) {
- $this->cellXfCollection[] = new PHPExcel_Style();
- }
-
- foreach ($this->getWorksheetIterator() as $sheet) {
-
- foreach ($sheet->getCellCollection(false) as $cellID) {
- $cell = $sheet->getCell($cellID);
- $cell->setXfIndex($map[$cell->getXfIndex()]);
- }
-
- foreach ($sheet->getRowDimensions() as $rowDimension) {
- if ($rowDimension->getXfIndex() !== null) {
- $rowDimension->setXfIndex($map[$rowDimension->getXfIndex()]);
- }
- }
-
- foreach ($sheet->getColumnDimensions() as $columnDimension) {
- $columnDimension->setXfIndex($map[$columnDimension->getXfIndex()]);
- }
-
- $sheet->garbageCollect();
- }
- }
-
- public function getID()
- {
- return $this->uniqueID;
- }
- }
|