$objPHPExcel = new \PHPExcel();
//定义配置
$topNumber = 2;//表头有几行占用
$xlsTitle = iconv('utf-8', 'gb2312', $title);//文件名称
$fileName = $title.date('_YmdHis');//文件名称
optionsString='1,2,3,4,5,6'
$objValidation = $objPHPExcel->setActiveSheetIndex(0)->getCell('A1')->getDataValidation();
$objValidation->setType(PHPExcel_Cell_DataValidation::TYPE_LIST)
-> setErrorStyle(PHPExcel_Cell_DataValidation::STYLE_INFORMATION)
-> setAllowBlank(true)
-> setShowInputMessage(true)
-> setShowErrorMessage(true)
-> setShowDropDown(true)
-> setOperator(\PHPExcel_Cell_DataValidation::OPERATOR_BETWEEN)
-> setFormula1('"'.$optionsString.'"');