美文网首页java笔记
java生成Excel下拉框

java生成Excel下拉框

作者: 万里无风来 | 来源:发表于2019-10-17 15:17 被阅读0次
    public XSSFWorkbook exportExcel()throws Exception{
            XSSFWorkbook workbook = new XSSFWorkbook();
            XSSFSheet sheet = workbook.createSheet("下拉列表");
            String[] rank = new String[]{"高","中","低"};
            XSSFDataValidationHelper validationHelper = (XSSFDataValidationHelper) sheet.getDataValidationHelper();
            XSSFDataValidationConstraint  daConstraint = (XSSFDataValidationConstraint) validationHelper.createExplicitListConstraint(rank);
            CellRangeAddressList addressList = null;
            XSSFDataValidation validation = null;
            for(int i = 0;i < 100;i++){
                addressList = new CellRangeAddressList(i, i, 0, 0);
                validation = (XSSFDataValidation) validationHelper.createValidation(
                        daConstraint, addressList); 
                validation.setSuppressDropDownArrow(true);
                validation.setShowErrorBox(true); 
                sheet.addValidationData(validation);
            }
            return workbook;
        }
    

    相关文章

      网友评论

        本文标题:java生成Excel下拉框

        本文链接:https://www.haomeiwen.com/subject/jbtvmctx.html