PHPOffice / PhpSpreadsheet

     *

     * @return Cell

     */

    public function setDataValidation(DataValidation $pDataValidation = null)

    {

        if (!isset($this->parent)) {

            throw new Exception('Cannot set data validation for cell that is not bound to a worksheet');

        }

        $this->getWorksheet()->setDataValidation($this->getCoordinate(), $pDataValidation);

        return $this->updateInCollection();

    }

    /**

     *    Does this cell contain a Hyperlink?

     *

     * @return Cell

     */

    public function setHyperlink(Hyperlink $pHyperlink = null)

    {

        if (!isset($this->parent)) {

            throw new Exception('Cannot set hyperlink for cell that is not bound to a worksheet');

        }

        $this->getWorksheet()->setHyperlink($this->getCoordinate(), $pHyperlink);

        return $this->updateInCollection();

    }

    /**

     * Get cell collection.