添加单元格数据验证的方法

/**
 * e.g.
 * addCellDataValidation($objPHPExcel->getActiveSheet(),'M4:M1000','"选择题,组合题,判断题,填空题,连线题,排序题,应用题"');
 *
 * 设置单元格公式（现在只用到数据验证）
 * @author ****
 * @dateTime 2018-09-27T14:06:27+0800
 * @param    PHPExcel_Worksheet $workSheet 工作表
 * @param    string $rangeCell e.g.   B3  A1:A9  A1:C9
 * @param    string $formula 公式
 * @param    string $errorTitle 错误提示标题
 * @param    string $errorMsg 错误提示信息
 * @param    string $prompTitle 标题
 */
public static function addCellDataValidation(
        PHPExcel_Worksheet $workSheet,
        $rangeCell,
        $formula,
        $errorTitle = '输入的值有误',
        $errorMsg = '您输入的值不在下拉框列表内',
        $prompTitle = '') {
    $cells = PHPExcel_Cell::extractAllCellReferencesInRange($rangeCell);
    if ($cells) {
        foreach ($cells as $key => $value) {
            $objValidation = $workSheet->getCell($value)->getDataValidation();
            $objValidation->setType(PHPExcel_Cell_DataValidation::TYPE_LIST)
                ->setErrorStyle(PHPExcel_Cell_DataValidation::STYLE_INFORMATION)
                ->setAllowBlank(false)
                ->setShowInputMessage(true)
                ->setShowErrorMessage(true)
                ->setShowDropDown(true)
                ->setErrorTitle($errorTitle)
                //->setError($errorMsg)
                ->setPromptTitle($prompTitle)
                ->setFormula1($formula);
        }
    }
}

Excel::addCellDataValidation($objPHPExcel->getSheet(0),'G2:G1000','"故事类,非故事类"');
Excel::addCellDataValidation($objPHPExcel->getSheet(0),'G2:G1000','sheet1!$A$2:$A$10');