PHPOffice / PhpSpreadsheet

            $pSheetName = $pSheet->getTitle();

//            echo 'Passed sheet name is '.$pSheetName.PHP_EOL;

//            echo 'Range reference is '.$pRange.PHP_EOL;

            if (strpos($pRange, '!') !== false) {

//                echo '$pRange reference includes sheet reference', PHP_EOL;

                list($pSheetName, $pRange) = Worksheet::extractSheetTitle($pRange, true);

//                echo 'New sheet name is '.$pSheetName, PHP_EOL;

//                echo 'Adjusted Range reference is '.$pRange, PHP_EOL;

                $pSheet = $this->spreadsheet->getSheetByName($pSheetName);

            }

            // Extract range

            $aReferences = Cell::extractAllCellReferencesInRange($pRange);

            $pSheetName = $pSheet->getTitle();

//            echo 'Current sheet name is '.$pSheetName.'<br />';

//            echo 'Range reference is '.$pRange.'<br />';

            if (strpos($pRange, '!') !== false) {

//                echo '$pRange reference includes sheet reference', PHP_EOL;

                list($pSheetName, $pRange) = Worksheet::extractSheetTitle($pRange, true);

//                echo 'New sheet name is '.$pSheetName, PHP_EOL;

//                echo 'Adjusted Range reference is '.$pRange, PHP_EOL;

                $pSheet = $this->spreadsheet->getSheetByName($pSheetName);

            }

            // Named range?

            $namedRange = NamedRange::resolveRange($pRange, $pSheet);