java POI 下拉选的实现

来源：互联网发布：app程序员招聘要求编辑：程序博客网时间：2024/05/24 05:03

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();        }            }

0 0