PHP Dosya Yöneticisi

<?php

class PHPExcel_Cell
{
    private $value = NULL;
    private $calculatedValue = NULL;
    private $dataType = NULL;
    private $parent = NULL;
    private $xfIndex = 0;
    private $formulaAttributes = NULL;
    private static $valueBinder = NULL;
    const DEFAULT_RANGE = "A1:A1";
    public function notifyCacheController()
    {
        $this->parent->updateCacheData($this);
        return $this;
    }
    public function detach()
    {
        $this->parent = NULL;
    }
    public function attach(PHPExcel_CachedObjectStorage_CacheBase $parent)
    {
        $this->parent = $parent;
    }
    public function __construct($pValue = NULL, $pDataType = NULL, PHPExcel_Worksheet $pSheet = NULL)
    {
        $this->value = $pValue;
        $this->parent = $pSheet->getCellCacheController();
        if ($pDataType !== NULL) {
            if ($pDataType == PHPExcel_Cell_DataType::TYPE_STRING2) {
                $pDataType = PHPExcel_Cell_DataType::TYPE_STRING;
            }
            $this->dataType = $pDataType;
        } else {
            if (!self::getValueBinder()->bindValue($this, $pValue)) {
                throw new PHPExcel_Exception("Value could not be bound to cell.");
            }
        }
    }
    public function getColumn()
    {
        return $this->parent->getCurrentColumn();
    }
    public function getRow()
    {
        return $this->parent->getCurrentRow();
    }
    public function getCoordinate()
    {
        return $this->parent->getCurrentAddress();
    }
    public function getValue()
    {
        return $this->value;
    }
    public function getFormattedValue()
    {
        return (int) PHPExcel_Style_NumberFormat::toFormattedString($this->getCalculatedValue(), $this->getStyle()->getNumberFormat()->getFormatCode());
    }
    public function setValue($pValue = NULL)
    {
        if (!self::getValueBinder()->bindValue($this, $pValue)) {
            throw new PHPExcel_Exception("Value could not be bound to cell.");
        }
        return $this;
    }
    public function setValueExplicit($pValue = NULL, $pDataType = PHPExcel_Cell_DataType::TYPE_STRING)
    {
        switch ($pDataType) {
            case PHPExcel_Cell_DataType::TYPE_NULL:
                $this->value = $pValue;
                break;
            case PHPExcel_Cell_DataType::TYPE_STRING2:
                $pDataType = PHPExcel_Cell_DataType::TYPE_STRING;
                break;
            case PHPExcel_Cell_DataType::TYPE_STRING:
            case PHPExcel_Cell_DataType::TYPE_INLINE:
                $this->value = PHPExcel_Cell_DataType::checkString($pValue);
                break;
            case PHPExcel_Cell_DataType::TYPE_NUMERIC:
                $this->value = (int) $pValue;
                break;
            case PHPExcel_Cell_DataType::TYPE_FORMULA:
                $this->value = (int) $pValue;
                break;
            case PHPExcel_Cell_DataType::TYPE_BOOL:
                $this->value = (int) $pValue;
                break;
            case PHPExcel_Cell_DataType::TYPE_ERROR:
                $this->value = PHPExcel_Cell_DataType::checkErrorCode($pValue);
                $this->dataType = $pDataType;
                return $this->notifyCacheController();
                break;
            default:
                throw new PHPExcel_Exception("Invalid datatype: " . $pDataType);
        }
    }
    public function getCalculatedValue($resetLog = true)
    {
        while ($this->dataType == PHPExcel_Cell_DataType::TYPE_FORMULA) {
            if ($this->value instanceof PHPExcel_RichText) {
                return $this->value->getPlainText();
            }
            return $this->value;
        }
        try {
            $result = PHPExcel_Calculation::getInstance($this->getWorksheet()->getParent())->calculateCellValue($this, $resetLog);
            if (is_array($result)) {
                while (is_array($result)) {
                    $result = array_pop($result);
                }
            }
            if ($result === "#Not Yet Implemented") {
                return $this->calculatedValue;
            }
            return $result;
        } catch (PHPExcel_Exception $ex) {
            if ($ex->getMessage() === "Unable to access External Workbook" && $this->calculatedValue !== NULL) {
                return $this->calculatedValue;
            }
            $result = "#N/A";
            throw new PHPExcel_Calculation_Exception($this->getWorksheet()->getTitle() . "!" . $this->getCoordinate() . " -> " . $ex->getMessage());
        }
    }
    public function setCalculatedValue($pValue = NULL)
    {
        if ($pValue !== NULL) {
            $this->calculatedValue = is_numeric($pValue) ? (int) $pValue : $pValue;
        }
        return $this->notifyCacheController();
    }
    public function getOldCalculatedValue()
    {
        return $this->calculatedValue;
    }
    public function getDataType()
    {
        return $this->dataType;
    }
    public function setDataType($pDataType = PHPExcel_Cell_DataType::TYPE_STRING)
    {
        if ($pDataType == PHPExcel_Cell_DataType::TYPE_STRING2) {
            $pDataType = PHPExcel_Cell_DataType::TYPE_STRING;
        }
        $this->dataType = $pDataType;
        return $this->notifyCacheController();
    }
    public function isFormula()
    {
        return $this->dataType == PHPExcel_Cell_DataType::TYPE_FORMULA;
    }
    public function hasDataValidation()
    {
        if (!isset($this->parent)) {
            throw new PHPExcel_Exception("Cannot check for data validation when cell is not bound to a worksheet");
        }
        return $this->getWorksheet()->dataValidationExists($this->getCoordinate());
    }
    public function getDataValidation()
    {
        if (!isset($this->parent)) {
            throw new PHPExcel_Exception("Cannot get data validation for cell that is not bound to a worksheet");
        }
        return $this->getWorksheet()->getDataValidation($this->getCoordinate());
    }
    public function setDataValidation(PHPExcel_Cell_DataValidation $pDataValidation = NULL)
    {
        if (!isset($this->parent)) {
            throw new PHPExcel_Exception("Cannot set data validation for cell that is not bound to a worksheet");
        }
        $this->getWorksheet()->setDataValidation($this->getCoordinate(), $pDataValidation);
        return $this->notifyCacheController();
    }
    public function hasHyperlink()
    {
        if (!isset($this->parent)) {
            throw new PHPExcel_Exception("Cannot check for hyperlink when cell is not bound to a worksheet");
        }
        return $this->getWorksheet()->hyperlinkExists($this->getCoordinate());
    }
    public function getHyperlink()
    {
        if (!isset($this->parent)) {
            throw new PHPExcel_Exception("Cannot get hyperlink for cell that is not bound to a worksheet");
        }
        return $this->getWorksheet()->getHyperlink($this->getCoordinate());
    }
    public function setHyperlink(PHPExcel_Cell_Hyperlink $pHyperlink = NULL)
    {
        if (!isset($this->parent)) {
            throw new PHPExcel_Exception("Cannot set hyperlink for cell that is not bound to a worksheet");
        }
        $this->getWorksheet()->setHyperlink($this->getCoordinate(), $pHyperlink);
        return $this->notifyCacheController();
    }
    public function getParent()
    {
        return $this->parent;
    }
    public function getWorksheet()
    {
        return $this->parent->getParent();
    }
    public function isInMergeRange()
    {
        return (int) $this->getMergeRange();
    }
    public function isMergeRangeValueCell()
    {
        if ($mergeRange = $this->getMergeRange()) {
            $mergeRange = PHPExcel_Cell::splitRange($mergeRange);
            $startCell = $mergeRange[0][0];
            if ($this->getCoordinate() === $startCell) {
                return true;
            }
        }
        return false;
    }
    public function getMergeRange()
    {
        foreach ($this->getWorksheet()->getMergeCells() as $mergeRange) {
            if ($this->isInRange($mergeRange)) {
                return $mergeRange;
            }
        }
        return false;
    }
    public function getStyle()
    {
        return $this->getWorksheet()->getStyle($this->getCoordinate());
    }
    public function rebindParent(PHPExcel_Worksheet $parent)
    {
        $this->parent = $parent->getCellCacheController();
        return $this->notifyCacheController();
    }
    public function isInRange($pRange = "A1:A1")
    {
        list($rangeStart, $rangeEnd) = self::rangeBoundaries($pRange);
        $myColumn = self::columnIndexFromString($this->getColumn());
        $myRow = $this->getRow();
        return $rangeStart[0] <= $myColumn && $myColumn <= $rangeEnd[0] && $rangeStart[1] <= $myRow && $myRow <= $rangeEnd[1];
    }
    public static function coordinateFromString($pCoordinateString = "A1")
    {
        if (preg_match("/^([\$]?[A-Z]{1,3})([\$]?\\d{1,7})\$/", $pCoordinateString, $matches)) {
            return [$matches[1], $matches[2]];
        }
        if (strpos($pCoordinateString, ":") !== false || strpos($pCoordinateString, ",") !== false) {
            throw new PHPExcel_Exception("Cell coordinate string can not be a range of cells");
        }
        if ($pCoordinateString == "") {
            throw new PHPExcel_Exception("Cell coordinate can not be zero-length string");
        }
        throw new PHPExcel_Exception("Invalid cell coordinate " . $pCoordinateString);
    }
    public static function absoluteReference($pCoordinateString = "A1")
    {
        if (strpos($pCoordinateString, ":") === false && strpos($pCoordinateString, ",") === false) {
            $worksheet = "";
            $cellAddress = explode("!", $pCoordinateString);
            if (1 < count($cellAddress)) {
                list($worksheet, $pCoordinateString) = $cellAddress;
            }
            if ("" < $worksheet) {
                $worksheet .= "!";
            }
            if (ctype_digit($pCoordinateString)) {
                return $worksheet . "\$" . $pCoordinateString;
            }
            if (ctype_alpha($pCoordinateString)) {
                return $worksheet . "\$" . strtoupper($pCoordinateString);
            }
            return $worksheet . self::absoluteCoordinate($pCoordinateString);
        }
        throw new PHPExcel_Exception("Cell coordinate string can not be a range of cells");
    }
    public static function absoluteCoordinate($pCoordinateString = "A1")
    {
        if (strpos($pCoordinateString, ":") === false && strpos($pCoordinateString, ",") === false) {
            $worksheet = "";
            $cellAddress = explode("!", $pCoordinateString);
            if (1 < count($cellAddress)) {
                list($worksheet, $pCoordinateString) = $cellAddress;
            }
            if ("" < $worksheet) {
                $worksheet .= "!";
            }
            list($column, $row) = self::coordinateFromString($pCoordinateString);
            $column = ltrim($column, "\$");
            $row = ltrim($row, "\$");
            return $worksheet . "\$" . $column . "\$" . $row;
        }
        throw new PHPExcel_Exception("Cell coordinate string can not be a range of cells");
    }
    public static function splitRange($pRange = "A1:A1")
    {
        if (empty($pRange)) {
            $pRange = "A1:A1";
        }
        $exploded = explode(",", $pRange);
        $counter = count($exploded);
        for ($i = 0; $i < $counter; $i++) {
            $exploded[$i] = explode(":", $exploded[$i]);
        }
        return $exploded;
    }
    public static function buildRange($pRange)
    {
        if (!is_array($pRange) || empty($pRange) || !is_array($pRange[0])) {
            throw new PHPExcel_Exception("Range does not contain any information");
        }
        $imploded = [];
        $counter = count($pRange);
        for ($i = 0; $i < $counter; $i++) {
            $pRange[$i] = implode(":", $pRange[$i]);
        }
        $imploded = implode(",", $pRange);
        return $imploded;
    }
    public static function rangeBoundaries($pRange = "A1:A1")
    {
        if (empty($pRange)) {
            $pRange = "A1:A1";
        }
        $pRange = strtoupper($pRange);
        if (strpos($pRange, ":") === false) {
            $rangeA = $rangeB = $pRange;
        } else {
            list($rangeA, $rangeB) = explode(":", $pRange);
        }
        $rangeStart = self::coordinateFromString($rangeA);
        $rangeEnd = self::coordinateFromString($rangeB);
        $rangeStart[0] = self::columnIndexFromString($rangeStart[0]);
        $rangeEnd[0] = self::columnIndexFromString($rangeEnd[0]);
        return [$rangeStart, $rangeEnd];
    }
    public static function rangeDimension($pRange = "A1:A1")
    {
        list($rangeStart, $rangeEnd) = self::rangeBoundaries($pRange);
        return [$rangeEnd[0] - $rangeStart[0] + 1, $rangeEnd[1] - $rangeStart[1] + 1];
    }
    public static function getRangeBoundaries($pRange = "A1:A1")
    {
        if (empty($pRange)) {
            $pRange = "A1:A1";
        }
        $pRange = strtoupper($pRange);
        if (strpos($pRange, ":") === false) {
            $rangeA = $rangeB = $pRange;
        } else {
            list($rangeA, $rangeB) = explode(":", $pRange);
        }
        return [self::coordinateFromString($rangeA), self::coordinateFromString($rangeB)];
    }
    public static function columnIndexFromString($pString = "A")
    {
        if (isset($_indexCache[$pString])) {
            return $_indexCache[$pString];
        }
        if (isset($pString[0])) {
            if (!isset($pString[1])) {
                $_indexCache[$pString] = $_columnLookup[$pString];
                return $_indexCache[$pString];
            }
            if (!isset($pString[2])) {
                $_indexCache[$pString] = $_columnLookup[$pString[0]] * 26 + $_columnLookup[$pString[1]];
                return $_indexCache[$pString];
            }
            if (!isset($pString[3])) {
                $_indexCache[$pString] = $_columnLookup[$pString[0]] * 676 + $_columnLookup[$pString[1]] * 26 + $_columnLookup[$pString[2]];
                return $_indexCache[$pString];
            }
        }
        throw new PHPExcel_Exception("Column string index can not be " . (isset($pString[0]) ? "longer than 3 characters" : "empty"));
    }
    public static function stringFromColumnIndex($pColumnIndex = 0)
    {
        if (!isset($_indexCache[$pColumnIndex])) {
            if ($pColumnIndex < 26) {
                $_indexCache[$pColumnIndex] = chr(65 + $pColumnIndex);
            } else {
                if ($pColumnIndex < 702) {
                    $_indexCache[$pColumnIndex] = chr(64 + $pColumnIndex / 26) . chr(65 + $pColumnIndex % 26);
                } else {
                    $_indexCache[$pColumnIndex] = chr(64 + ($pColumnIndex - 26) / 676) . chr(65 + ($pColumnIndex - 26) % 676 / 26) . chr(65 + $pColumnIndex % 26);
                }
            }
        }
        return $_indexCache[$pColumnIndex];
    }
    public static function extractAllCellReferencesInRange($pRange = "A1")
    {
        $returnValue = [];
        $cellBlocks = explode(" ", str_replace("\$", "", strtoupper($pRange)));
        foreach ($cellBlocks as $cellBlock) {
            if (strpos($cellBlock, ":") === false && strpos($cellBlock, ",") === false) {
                $returnValue[] = $cellBlock;
            } else {
                $ranges = self::splitRange($cellBlock);
                foreach ($ranges as $range) {
                    if (!isset($range[1])) {
                        $returnValue[] = $range[0];
                    } else {
                        list($rangeStart, $rangeEnd) = $range;
                        sscanf($rangeStart, "%[A-Z]%d", $startCol, $startRow);
                        sscanf($rangeEnd, "%[A-Z]%d", $endCol, $endRow);
                        $endCol++;
                        $currentCol = $startCol;
                        $currentRow = $startRow;
                        while ($currentCol != $endCol) {
                            while ($currentRow <= $endRow) {
                                $returnValue[] = $currentCol . $currentRow;
                                $currentRow++;
                            }
                            $currentCol++;
                            $currentRow = $startRow;
                        }
                    }
                }
            }
        }
        $sortKeys = [];
        foreach (array_unique($returnValue) as $coord) {
            sscanf($coord, "%[A-Z]%d", $column, $row);
            $sortKeys[sprintf("%3s%09d", $column, $row)] = $coord;
        }
        ksort($sortKeys);
        return array_values($sortKeys);
    }
    public static function compareCells(PHPExcel_Cell $a, PHPExcel_Cell $b)
    {
        if ($a->getRow() < $b->getRow()) {
            return -1;
        }
        if ($b->getRow() < $a->getRow()) {
            return 1;
        }
        if (self::columnIndexFromString($a->getColumn()) < self::columnIndexFromString($b->getColumn())) {
            return -1;
        }
        return 1;
    }
    public static function getValueBinder()
    {
        if (self::$valueBinder === NULL) {
            self::$valueBinder = new PHPExcel_Cell_DefaultValueBinder();
        }
        return self::$valueBinder;
    }
    public static function setValueBinder(PHPExcel_Cell_IValueBinder $binder = NULL)
    {
        if ($binder === NULL) {
            throw new PHPExcel_Exception("A PHPExcel_Cell_IValueBinder is required for PHPExcel to function correctly.");
        }
        self::$valueBinder = $binder;
    }
    public function __clone()
    {
        $vars = get_object_vars($this);
        foreach ($vars as $key => $value) {
            if (is_object($value) && $key != "parent") {
                $this->{$key} = clone $value;
            } else {
                $this->{$key} = $value;
            }
        }
    }
    public function getXfIndex()
    {
        return $this->xfIndex;
    }
    public function setXfIndex($pValue = 0)
    {
        $this->xfIndex = $pValue;
        return $this->notifyCacheController();
    }
    public function setFormulaAttributes($pAttributes)
    {
        $this->formulaAttributes = $pAttributes;
        return $this;
    }
    public function getFormulaAttributes()
    {
        return $this->formulaAttributes;
    }
    public function __toString()
    {
        return (int) $this->getValue();
    }
}

İptal

📁 PHP Dosya Yöneticisi

📝 Cell.php

📝 Cell.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)