public static void testSheet(){
try (XSSFWorkbook workbook =
new XSSFWorkbook();
){
XSSFSheet sheet = workbook.createSheet(
"下拉列表测试");
String[] datas ={
"A",
"B",
"C",
"D"};
XSSFDataValidationHelper dvHelper =
new XSSFDataValidationHelper(sheet);
XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper.createExplicitListConstraint(datas);
CellRangeAddressList addressList =
new CellRangeAddressList(
0,
1000,
0,
0);
XSSFDataValidation validation = (XSSFDataValidation) dvHelper.createValidation(dvConstraint, addressList);
sheet.addValidationData(validation);
FileOutputStream stream =
new FileOutputStream(
"E:"+File.separator+
"success.xlsx");
workbook.write(stream);
addressList =
null;
validation =
null;
}
catch (Exception e) {
e.printStackTrace();
}
}
