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();
}
}
java POI 下拉选的实现
最新推荐文章于 2023-05-30 16:41:30 发布