关于POI导出EXCEL写入多个数据有效性验证

建立多个HSSFDataValidation

//POI 导出EXCEL且多个有效数据性验证
HSSFDataValidation dataValidation1 =  new HSSFDataValidation(new CellRangeAddressList(...), DVConstraint.createExplicitListConstraint(new String[]{""}));
 HSSFDataValidation dataValidation2 =  new HSSFDataValidation(new CellRangeAddressList(...), DVConstraint.createExplicitListConstraint(new String[]{""}));
HSSFDataValidation dataValidation3 =  new HSSFDataValidation(new CellRangeAddressList(...), DVConstraint.createExplicitListConstraint(new String[]{""}));
List<HSSFDataValidation> dataValidationList = new ArrayList<HSSFDataValidation>();
dataValidationList.add(dataValidation1);
dataValidationList.add(dataValidation2);
dataValidationList.add(dataValidation3);

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Powered by POI");
for(HSSFDataValidation dataValidation : dataValidationList)
   sheet.addValidationData(dataValidation);