PHPOffice / PhpSpreadsheet

            foreach ($namedRanges as $namedRange) {

                // Create absolute coordinate

                $range = Cell::splitRange($namedRange->getRange());

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

                    $range[$i][0] = '\'' . str_replace("'", "''", $namedRange->getWorksheet()->getTitle()) . '\'!' . Cell::absoluteCoordinate($range[$i][0]);

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

                        $range[$i][1] = Cell::absoluteCoordinate($range[$i][1]);

                    }

                }

                $range = Cell::buildRange($range); // e.g. Sheet1!$A$1:$B$2

                // parse formula

        // Create absolute coordinate and write as raw text

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

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

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

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

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

            }

        }

        $range = Cell::buildRange($range);

        $objWriter->writeRawData($range);