poi设置下拉列表报错?-灵析社区

XSSFSheet refSheet = workbook.createSheet("refSheet"); for (int i = 0; i < departList.length; i++) { XSSFRow row = refSheet.createRow(i); XSSFCell cell = row.createCell(0); cell.setCellValue(departList[i]); } String formula = "refSheet!$A$1:$A$" + departList.length; DataValidationConstraint constraint = helper.createFormulaListConstraint(formula); // ...其余设置相同