使用poi导出Excel文件并设置下拉数据
设置下拉框
String[] capacityAvi = {"是","否"};
Sheet sheet = writer.getSheet();
CellRangeAddressList capacityList = new CellRangeAddressList(3, 5000, 3, 3);
StyleSet styleSet = writer.getStyleSet();
CellStyle cellStyle = styleSet.getCellStyle();
cellStyle.setDataFormat((short)BuiltinFormats.getBuiltinFormat("text"));
DataValidationHelper helper = sheet.getDataValidationHelper();
DataValidationConstraint capacityConstraint = helper.createExplicitListConstraint(capacityAvi);
DataValidation capacityDataValidation = helper.createValidation(capacityConstraint, capacityList);
writer.addValidationData(capacityDataValidation);