workbook = ExcelExportUtil.exportExcel(exportParams, entitys, dataList);
Sheet sheet = workbook.getSheet(sheetName);
DataValidationHelper validationHelper = sheet.getDataValidationHelper(); CellRangeAddressList addressList = new CellRangeAddressList(起始行, 结束行, 起始列,结束列); DataValidationConstraint constraint = validationHelper.createExplicitListConstraint(split); DataValidation validation = validationHelper.createValidation(constraint, addressList); sheet.addValidationData(validation);