PHPOffice / PhpSpreadsheet

     */

    public function setPrintArea($value, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE)

    {

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

            throw new PhpSpreadsheetException('Cell coordinate must not specify a worksheet.');

        } elseif (strpos($value, ':') === false) {

            throw new PhpSpreadsheetException('Cell coordinate must be a range of cells.');

        } elseif (strpos($value, '$') !== false) {

            throw new PhpSpreadsheetException('Cell coordinate must not be absolute.');

        }

        $value = strtoupper($value);

        if ($method == self::SETPRINTRANGE_OVERWRITE) {

        // Uppercase coordinate

        $pCoordinate = strtoupper($pCoordinate);

        if (strpos($pCoordinate, ':') !== false || strpos($pCoordinate, ',') !== false) {

            throw new Exception('Cell coordinate can not be a range of cells.');

        } elseif (strpos($pCoordinate, '$') !== false) {

            throw new Exception('Cell coordinate must not be absolute.');

        }

        // Create new cell object, if required

        return $createIfNotExists ? $this->createNewCell($pCoordinate) : null;

        // Uppercase coordinate

        $pCellCoordinate = strtoupper($pCellCoordinate);

        if (strpos($pCellCoordinate, ':') !== false || strpos($pCellCoordinate, ',') !== false) {

            throw new Exception('Cell coordinate string can not be a range of cells.');

        } elseif (strpos($pCellCoordinate, '$') !== false) {

            throw new Exception('Cell coordinate string must not be absolute.');

        } elseif ($pCellCoordinate == '') {

            throw new Exception('Cell coordinate can not be zero-length string.');

        }

        // Check if we already have a comment for this cell.

        if (isset($this->comments[$pCellCoordinate])) {