$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.'"');