/** * Set data validation * * @param string $pCellCoordinate Cell coordinate to insert data validation * @param PHPExcel_Cell_DataValidation $pDataValidation * @return PHPExcel_Worksheet */ public function setDataValidation($pCellCoordinate = 'A1', PHPExcel_Cell_DataValidation $pDataValidation = null) { if ($pDataValidation === null) { unset($this->_dataValidationCollection[$pCellCoordinate]); } else { $this->_dataValidationCollection[$pCellCoordinate] = $pDataValidation; $pDataValidation->setParent($this->getCell($pCellCoordinate)); } return $this; }
/** * Set Data validation * * @param PHPExcel_Cell_DataValidation $pDataValidation * @throws Exception */ public function setDataValidation(PHPExcel_Cell_DataValidation $pDataValidation = null) { $this->_dataValidation = $pDataValidation; $this->_dataValidation->setParent($this); }