exelx添加数据有效性

Sheet template

String hiddenSheetName = "hidden_sheet";
Sheet hiddenSheet = workbook.createSheet(hiddenSheetName);

String column =  "EA"
String formula = hiddenSheetName + "!$" + column + "$1:$" + column + "$" + validateList.size();
XSSFDataValidationConstraint dvConstraintAgent =
        (XSSFDataValidationConstraint) dataValidationHelper.createFormulaListConstraint(formula);
CellRangeAddressList addressListAgent =
        new CellRangeAddressList(1, 65535, i, i);
XSSFDataValidation validationAgent =
        (XSSFDataValidation) dataValidationHelper.createValidation(dvConstraintAgent, addressListAgent);
validationAgent.setShowErrorBox(true);
template.addValidationData(validationAgent);