java生成Excel下拉框

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;
    }
最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。