示例#1
0
 /**
  * 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;
 }
示例#2
0
 /**
  * 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);
 }