Function load has a Cognitive Complexity of 1540 (exceeds 5 allowed). Consider refactoring.

Open

    public function load($pFilename)
    {
        // Check if file exists
        if (!file_exists($pFilename)) {
            throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");

• Read up
  Read up

Method load has 1151 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function load($pFilename)
    {
        // Check if file exists
        if (!file_exists($pFilename)) {
            throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");

File Excel2007.php has 1594 lines of code (exceeds 250 allowed). Consider refactoring.

Open

<?php
/**
 * PHPExcel
 *
 * Copyright (c) 2006 - 2014 PHPExcel

Function _parseRichText has a Cognitive Complexity of 78 (exceeds 5 allowed). Consider refactoring.

Open

    private function _parseRichText($is = null) {
        $value = new PHPExcel_RichText();

        if (isset($is->t)) {
            $value->createText( PHPExcel_Shared_String::ControlCharacterOOXML2PHP( (string) $is->t ) );

• Read up
  Read up

Function _readStyle has a Cognitive Complexity of 63 (exceeds 5 allowed). Consider refactoring.

Open

    private static function _readStyle($docStyle, $style) {
        // format code
//        if (isset($style->numFmt)) {
//            if (isset($style->numFmt['formatCode'])) {
//                $docStyle->getNumberFormat()->setFormatCode((string) $style->numFmt['formatCode']);

• Read up
  Read up

Function listWorksheetInfo has a Cognitive Complexity of 32 (exceeds 5 allowed). Consider refactoring.

Open

    public function listWorksheetInfo($pFilename)
    {
        // Check if file exists
        if (!file_exists($pFilename)) {
            throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");

• Read up
  Read up

Method _readStyle has 104 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    private static function _readStyle($docStyle, $style) {
        // format code
//        if (isset($style->numFmt)) {
//            if (isset($style->numFmt['formatCode'])) {
//                $docStyle->getNumberFormat()->setFormatCode((string) $style->numFmt['formatCode']);

Function _readColor has a Cognitive Complexity of 18 (exceeds 5 allowed). Consider refactoring.

Open

    private static function _readColor($color, $background=FALSE) {
        if (isset($color["rgb"])) {
            return (string)$color["rgb"];
        } else if (isset($color["indexed"])) {
            return PHPExcel_Style_Color::indexedColor($color["indexed"]-7,$background)->getARGB();

• Read up
  Read up

Method listWorksheetInfo has 56 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function listWorksheetInfo($pFilename)
    {
        // Check if file exists
        if (!file_exists($pFilename)) {
            throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");

Function _readRibbon has a Cognitive Complexity of 16 (exceeds 5 allowed). Consider refactoring.

Open

    private function _readRibbon($excel, $customUITarget, $zip)
    {
        $baseDir = dirname($customUITarget);
        $nameCustomUI = basename($customUITarget);
        // get the xml file (ribbon)

• Read up
  Read up

Method _parseRichText has 50 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    private function _parseRichText($is = null) {
        $value = new PHPExcel_RichText();

        if (isset($is->t)) {
            $value->createText( PHPExcel_Shared_String::ControlCharacterOOXML2PHP( (string) $is->t ) );

Function canRead has a Cognitive Complexity of 13 (exceeds 5 allowed). Consider refactoring.

Open

    public function canRead($pFilename)
    {
        // Check if file exists
        if (!file_exists($pFilename)) {
            throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");

• Read up
  Read up

Method _readRibbon has 29 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    private function _readRibbon($excel, $customUITarget, $zip)
    {
        $baseDir = dirname($customUITarget);
        $nameCustomUI = basename($customUITarget);
        // get the xml file (ribbon)

Function toCSSArray has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

    private static function toCSSArray($style) {
        $style = str_replace(array("\r","\n"), "", $style);

        $temp = explode(';', $style);
        $style = array();

• Read up
  Read up

Method _castToFormula has 7 arguments (exceeds 4 allowed). Consider refactoring.

Open

    private function _castToFormula($c,$r,&$cellDataType,&$value,&$calculatedValue,&$sharedFormulas,$castBaseType) {

Avoid deeply nested control flow statements.

Open

                                    if (isset($tmpNumFmt["formatCode"])) {
                                        $numFmt = (string) $tmpNumFmt["formatCode"];
                                    }

Function listWorksheetNames has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

    public function listWorksheetNames($pFilename)
    {
        // Check if file exists
        if (!file_exists($pFilename)) {
            throw new PHPExcel_Reader_Exception("Could not open " . $pFilename . " for reading! File does not exist.");

• Read up
  Read up

Avoid deeply nested control flow statements.

Open

                                        if (isset($xmlSheet->sheetViews->sheetView->pane['xSplit'])) {
                                            $xSplit = 1 + intval($xmlSheet->sheetViews->sheetView->pane['xSplit']);
                                        }

Avoid deeply nested control flow statements.

Open

                                    if (isset($xmlSheet->sheetViews->sheetView->selection['sqref'])) {
                                        $sqref = (string)$xmlSheet->sheetViews->sheetView->selection['sqref'];
                                        $sqref = explode(' ', $sqref);
                                        $sqref = $sqref[0];
                                        $docSheet->setSelectedCells($sqref);

Avoid deeply nested control flow statements.

Open

                                        if (intval($col["max"]) == 16384) {
                                            break;
                                        }

Avoid deeply nested control flow statements.

Open

                                            if (($column !== NULL) && ($row !== NULL)) {
                                                // Set comment properties
                                                $comment = $docSheet->getCommentByColumnAndRow((string) $column, $row + 1);
                                                $comment->getFillColor()->setRGB( $fillColor );

Avoid deeply nested control flow statements.

Open

                                        if ($xmlDrawing->oneCellAnchor) {
                                            foreach ($xmlDrawing->oneCellAnchor as $oneCellAnchor) {
                                                if ($oneCellAnchor->pic->blipFill) {
                                                    $blip = $oneCellAnchor->pic->blipFill->children("http://schemas.openxmlformats.org/drawingml/2006/main")->blip;
                                                    $xfrm = $oneCellAnchor->pic->spPr->children("http://schemas.openxmlformats.org/drawingml/2006/main")->xfrm;

Avoid deeply nested control flow statements.

Open

                                        if ($col["style"] && !$this->_readDataOnly) {
                                            $docSheet->getColumnDimension(PHPExcel_Cell::stringFromColumnIndex($i))->setXfIndex(intval($col["style"]));
                                        }

Avoid deeply nested control flow statements.

Open

                                        if (self::boolean($col["bestFit"])) {
                                            //$docSheet->getColumnDimension(PHPExcel_Cell::stringFromColumnIndex($i))->setAutoSize(TRUE);
                                        }

Avoid deeply nested control flow statements.

Open

                                        if ($filterColumn->dynamicFilter) {
                                            $column->setFilterType(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_FILTERTYPE_DYNAMICFILTER);
                                            //    We should only ever have one dynamic filter
                                            foreach ($filterColumn->dynamicFilter as $filterRule) {
                                                $column->createRule()->setRule(

Avoid deeply nested control flow statements.

Open

                                        if ($ele["Type"] == "http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink") {
                                            $hyperlinks[(string)$ele["Id"]] = (string)$ele["Target"];
                                        }

Avoid deeply nested control flow statements.

Open

                                            if (isset($hyperlink['tooltip'])) {
                                                $cell->getHyperlink()->setTooltip( (string)$hyperlink['tooltip'] );
                                            }

Avoid deeply nested control flow statements.

Open

                                            if ($mapSheetId[(integer) $definedName['localSheetId']] !== null) {
                                                $range = explode('!', (string)$definedName);
                                                if (count($range) == 2) {
                                                    $range[0] = str_replace("''", "'", $range[0]);
                                                    $range[0] = str_replace("'", "", $range[0]);

Avoid deeply nested control flow statements.

Open

                                        if (self::boolean($col["hidden"])) {
                                        // echo PHPExcel_Cell::stringFromColumnIndex($i),': HIDDEN COLUMN',PHP_EOL;
                                            $docSheet->getColumnDimension(PHPExcel_Cell::stringFromColumnIndex($i))->setVisible(FALSE);
                                        }

Avoid deeply nested control flow statements.

Open

                                        if ($relsDrawing && $relsDrawing->Relationship) {
                                            foreach ($relsDrawing->Relationship as $ele) {
                                                if ($ele["Type"] == "http://schemas.openxmlformats.org/officeDocument/2006/relationships/image") {
                                                    $images[(string) $ele["Id"]] = self::dir_add($fileDrawing, $ele["Target"]);
                                                } elseif ($ele["Type"] == "http://schemas.openxmlformats.org/officeDocument/2006/relationships/chart") {

Avoid deeply nested control flow statements.

Open

                                        switch ((string)$definedName['name']) {

                                            case '_xlnm._FilterDatabase':
                                                if ((string)$definedName['hidden'] !== '1') {
                                                    $extractedRange = explode(',', $extractedRange);

Avoid deeply nested control flow statements.

Open

                                    if ($locatedSheet !== NULL) {
                                        $excel->addNamedRange( new PHPExcel_NamedRange((string)$definedName['name'], $locatedSheet, $extractedRange, false) );
                                    }

Avoid deeply nested control flow statements.

Open

                                            if (!$this->getReadFilter()->readCell($coordinates[0], $coordinates[1], $docSheet->getTitle())) {
                                                continue;
                                            }

Avoid deeply nested control flow statements.

Open

                                            if (isset($linkRel['id'])) {
                                                $hyperlinkUrl = $hyperlinks[ (string)$linkRel['id'] ];
                                                if (isset($hyperlink['location'])) {
                                                    $hyperlinkUrl .= '#' . (string) $hyperlink['location'];
                                                }

Avoid deeply nested control flow statements.

Open

                                if (isset($chartDetails[$chartPositionRef])) {
//                                    var_dump($chartDetails[$chartPositionRef]);

                                    $excel->getSheetByName($charts[$chartEntryRef]['sheet'])->addChart($objChart);
                                    $objChart->setWorksheet($excel->getSheetByName($charts[$chartEntryRef]['sheet']));

Avoid deeply nested control flow statements.

Open

                                                    if ($value instanceof PHPExcel_RichText) {
                                                        $value = clone $value;
                                                    }

Avoid deeply nested control flow statements.

Open

                                        if (self::boolean($col["collapsed"])) {
                                            $docSheet->getColumnDimension(PHPExcel_Cell::stringFromColumnIndex($i))->setCollapsed(TRUE);
                                        }

Avoid deeply nested control flow statements.

Open

                                                    if (isset($c->f['t'])) {
                                                        $att = array();
                                                        $att = $c->f;
                                                        $docSheet->getCell($r)->setFormulaAttributes($att);
                                                    }

Avoid deeply nested control flow statements.

Open

                                        if ($filterColumn->top10) {
                                            $column->setFilterType(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_FILTERTYPE_TOPTENFILTER);
                                            //    We should only ever have one top10 filter
                                            foreach ($filterColumn->top10 as $filterRule) {
                                                $column->createRule()->setRule(

Avoid deeply nested control flow statements.

Open

                                    if (isset($cellStyles[intval($cellStyle['xfId'])])) {
                                        // Set default style
                                        $style = new PHPExcel_Style;
                                        self::_readStyle($style, $cellStyles[intval($cellStyle['xfId'])]);

Avoid deeply nested control flow statements.

Open

                                            if (is_array($clientData) && !empty($clientData)) {
                                                $clientData   = $clientData[0];

                                                if ( isset($clientData['ObjectType']) && (string)$clientData['ObjectType'] == 'Note' ) {
                                                    $temp = $clientData->xpath('.//x:Row');

Avoid deeply nested control flow statements.

Open

                                        if ($ele["Type"] == "http://schemas.openxmlformats.org/officeDocument/2006/relationships/vmlDrawing") {
                                            $vmlComments[(string)$ele["Id"]] = (string)$ele["Target"];
                                        }

Avoid deeply nested control flow statements.

Open

                                    if ($zip->locateName(dirname("$dir/$fileWorksheet") . "/_rels/" . basename($fileWorksheet) . ".rels")) {
                                        $relsWorksheet = simplexml_load_string($this->securityScan($this->_getFromZipArchive($zip,  dirname("$dir/$fileWorksheet") . "/_rels/" . basename($fileWorksheet) . ".rels")), 'SimpleXMLElement', PHPExcel_Settings::getLibXmlLoaderOptions()); //~ http://schemas.openxmlformats.org/package/2006/relationships");
                                        $vmlRelationship = '';

                                        foreach ($relsWorksheet->Relationship as $ele) {

Avoid deeply nested control flow statements.

Open

                                        if (isset($xmlSheet->sheetViews->sheetView->pane['ySplit'])) {
                                            $ySplit = 1 + intval($xmlSheet->sheetViews->sheetView->pane['ySplit']);
                                        }

Avoid deeply nested control flow statements.

Open

                                        if ($ele["Type"] == "http://schemas.openxmlformats.org/officeDocument/2006/relationships/comments") {
                                            $comments[(string)$ele["Id"]] = (string)$ele["Target"];
                                        }

Avoid deeply nested control flow statements.

Open

                                    if (strpos( (string)$definedName, '!' ) !== false) {
                                        // Extract sheet name
                                        $extractedSheetName = PHPExcel_Worksheet::extractSheetTitle( (string)$definedName, true );
                                        $extractedSheetName = $extractedSheetName[0];

Avoid deeply nested control flow statements.

Open

                                            if ($value == (int)$value) $value = (int)$value;
                                            elseif ($value == (float)$value) $value = (float)$value;
                                            elseif ($value == (double)$value) $value = (double)$value;

Avoid deeply nested control flow statements.

Open

                                        if ($col["outlineLevel"] > 0) {
                                            $docSheet->getColumnDimension(PHPExcel_Cell::stringFromColumnIndex($i))->setOutlineLevel(intval($col["outlineLevel"]));
                                        }

Avoid deeply nested control flow statements.

Open

                                        if ($filterColumn->filters) {
                                            $column->setFilterType(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_FILTERTYPE_FILTER);
                                            $filters = $filterColumn->filters;
                                            if ((isset($filters["blank"])) && ($filters["blank"] == 1)) {
                                                $column->createRule()->setRule(

Avoid deeply nested control flow statements.

Open

                                        if ($filterColumn->customFilters) {
                                            $column->setFilterType(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_FILTERTYPE_CUSTOMFILTER);
                                            $customFilters = $filterColumn->customFilters;
                                            //    Custom filters can an AND or an OR join;
                                            //        and there should only ever be one or two entries

Avoid deeply nested control flow statements.

Open

                                        if ($xmlDrawing->twoCellAnchor) {
                                            foreach ($xmlDrawing->twoCellAnchor as $twoCellAnchor) {
                                                if ($twoCellAnchor->pic->blipFill) {
                                                    $blip = $twoCellAnchor->pic->blipFill->children("http://schemas.openxmlformats.org/drawingml/2006/main")->blip;
                                                    $xfrm = $twoCellAnchor->pic->spPr->children("http://schemas.openxmlformats.org/drawingml/2006/main")->xfrm;

Avoid too many return statements within this method.

Open

        return 'FF000000';

Identical blocks of code found in 2 locations. Consider refactoring.

Open

                                                    if ($outerShdw) {
                                                        $shadow = $objDrawing->getShadow();
                                                        $shadow->setVisible(true);
                                                        $shadow->setBlurRadius(PHPExcel_Shared_Drawing::EMUTopixels(self::array_item($outerShdw->attributes(), "blurRad")));
                                                        $shadow->setDistance(PHPExcel_Shared_Drawing::EMUTopixels(self::array_item($outerShdw->attributes(), "dist")));

• Read up
  Read up

Identical blocks of code found in 2 locations. Consider refactoring.

Open

                                                    if ($outerShdw) {
                                                        $shadow = $objDrawing->getShadow();
                                                        $shadow->setVisible(true);
                                                        $shadow->setBlurRadius(PHPExcel_Shared_Drawing::EMUTopixels(self::array_item($outerShdw->attributes(), "blurRad")));
                                                        $shadow->setDistance(PHPExcel_Shared_Drawing::EMUTopixels(self::array_item($outerShdw->attributes(), "dist")));

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

                            $cellStyle = (object) array(
                                "numFmt" => $numFmt,
                                "font" => $xmlStyles->fonts->font[intval($xf["fontId"])],
                                "fill" => $xmlStyles->fills->fill[intval($xf["fillId"])],
                                "border" => $xmlStyles->borders->border[intval($xf["borderId"])],

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

                            $style = (object) array(
                                "numFmt" => $numFmt,
                                "font" => $xmlStyles->fonts->font[intval($xf["fontId"])],
                                "fill" => $xmlStyles->fills->fill[intval($xf["fillId"])],
                                "border" => $xmlStyles->borders->border[intval($xf["borderId"])],

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

                    if (isset($run->rPr->vertAlign) && isset($run->rPr->vertAlign["val"])) {
                        $vertAlign = strtolower((string)$run->rPr->vertAlign["val"]);
                        if ($vertAlign == 'superscript') {
                            $objText->getFont()->setSuperScript(TRUE);
                        }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

            if (isset($style->font->vertAlign) && isset($style->font->vertAlign["val"])) {
                $vertAlign = strtolower((string)$style->font->vertAlign["val"]);
                if ($vertAlign == 'superscript') {
                    $docStyle->getFont()->setSuperScript(true);
                }

• Read up
  Read up

Identical blocks of code found in 2 locations. Consider refactoring.

Open

                                if (($spos = strpos($extractedRange,'!')) !== false) {
                                    $extractedRange = substr($extractedRange,0,$spos).str_replace('$', '', substr($extractedRange,$spos));
                                } else {
                                    $extractedRange = str_replace('$', '', $extractedRange);
                                }

• Read up
  Read up

Identical blocks of code found in 2 locations. Consider refactoring.

Open

                                    if (($spos = strpos($extractedRange,'!')) !== false) {
                                        $extractedRange = substr($extractedRange,0,$spos).str_replace('$', '', substr($extractedRange,$spos));
                                    } else {
                                        $extractedRange = str_replace('$', '', $extractedRange);
                                    }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

            if (isset($style->font->u) && !isset($style->font->u["val"])) {
                $docStyle->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
            } else if (isset($style->font->u) && isset($style->font->u["val"])) {
                $docStyle->getFont()->setUnderline((string)$style->font->u["val"]);
            }

• Read up
  Read up

Similar blocks of code found in 2 locations. Consider refactoring.

Open

                    if (isset($run->rPr->u) && !isset($run->rPr->u["val"])) {
                        $objText->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
                    } else if (isset($run->rPr->u) && isset($run->rPr->u["val"])) {
                        $objText->getFont()->setUnderline((string)$run->rPr->u["val"]);
                    }

• Read up
  Read up