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

smileageHi

于 2023-09-26 10:00:14 发布

阅读量554

点赞数

文章标签： java excel 开发语言

本文链接：https://blog.csdn.net/weixin_48576311/article/details/133297431

版权

    // 添加下拉框
    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);
    }