【poi】java向Excel里面添加下拉框

    // 添加下拉框
    public static void addValidationData(XSSFSheet sheet, String[] data, int firstRow, int lastRow, int firstCol, int lastCol) {
    	XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper(sheet);
		// 下拉框可选的数据，作为约束
		XSSFDataValidationConstraint dvConstraint = 
				(XSSFDataValidationConstraint) dvHelper.createExplicitListConstraint(data);
		// 设置为下拉框的范围
		CellRangeAddressList addressList = 
				new CellRangeAddressList(firstRow, lastRow, firstCol, lastCol);
		// 创建 DataValidation 对象
		XSSFDataValidation validation = 
				(XSSFDataValidation)dvHelper.createValidation(dvConstraint, addressList);
		validation.setShowErrorBox(true);
		// 作用于指定工作表
		sheet.addValidationData(validation);
    }