PHPOffice / PhpSpreadsheet

     *

     * @param string $pCellCoordinate    Cell coordinate to get hyperlink for

     */

    public function getHyperlink($pCellCoordinate = 'A1')

    {

        // return hyperlink if we already have one

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

            return $this->hyperlinkCollection[$pCellCoordinate];

        }

        // else create hyperlink

        $this->hyperlinkCollection[$pCellCoordinate] = new Cell\Hyperlink();

        return $this->hyperlinkCollection[$pCellCoordinate];

    }

    /**

     * Set hyperlnk

     *

     * @param string $pCellCoordinate Cell coordinate to get data validation for

     */

    public function getDataValidation($pCellCoordinate = 'A1')

    {

        // return data validation if we already have one

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

            return $this->dataValidationCollection[$pCellCoordinate];

        }

        // else create data validation

        $this->dataValidationCollection[$pCellCoordinate] = new Cell\DataValidation();

        return $this->dataValidationCollection[$pCellCoordinate];

    }

    /**

     * Set data validation