原因是使用easypoi自帶的下拉預選值無效，并且還帶來了版本沖突的問題，所以只能自己來解決， easypoi的使用請參考： http://doc.wupaas.com/docs/easypoi/easypoi-1c0u9dt0lqnpl
這里是說明使用easypoi生成的Workbook之后如何給單元格設定下拉預選值，但是也有缺點，就是前提必須要知道設定下拉預選值單元格的范圍，也就是需要指定范圍，行列的范圍，原理其實是創建sheet頁，這是poi的寫法，也就是一整個模板，代碼如下：
// poi匯出，生成Workbook
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("生活老師匯入","Sheet0", ExcelType.XSSF), ExportDormDTO.class, list);
// 設定下拉預選值
String[] dropDownValue = https://www.cnblogs.com/wadmwz/p/new String[]{"A", "B", "C", "D"};
String dropDownSheetName= "生活評價";
XSSFDataValidationHelper dropDownValidationHelper = createXSSFDataValidationHelper(workbook, dropDownSheetName, dropDownValue);
DataValidationConstraint dropDOwnValidationConstraint = dropDownValidationHelper.createFormulaListConstraint(dropDownSheetName + "!$A$1:$A$" + dropDownValue.length);
Sheet firstSheet = workbook.getSheet("Sheet0");
CellRangeAddressList drowDownValueCoveringRowsAndCloumns = new CellRangeAddressList(2, firstSheet.getLastRowNum(), 5, 9);
XSSFDataValidation dropDownValidation =(XSSFDataValidation)dropDownValidationHelper.createValidation(dropDOwnValidationConstraint, drowDownValueCoveringRowsAndCloumns);
firstSheet.addValidationData(dropDownValidation);
downLoadExcel("生活老師評價匯入.xlsx", response, workbook);
-------------------------------------------------------------------------------
下面是固定寫法，是上面代碼中使用到的區域方法
// 流匯出
private static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) throws IOException {
response.reset();
response.setContentType("application/x-download");
response.setHeader("Content-Disposition",
"attachment; filename=" + new String(fileName.getBytes("utf-8"), "ISO-8859-1"));
workbook.write(response.getOutputStream());
}
// 生成預選值的sheet頁
private static XSSFDataValidationHelper createXSSFDataValidationHelper(Workbook workbook, String name, String[] strList) {
Sheet sheet = workbook.createSheet(name);
// 回圈往該sheet中設定添加下拉串列的值
for (int i = 0; i < strList.length; i++) {
Row row = sheet.createRow(i);
Cell cell = row.createCell((int) 0);
cell.setCellValue(strList[i]);
}
workbook.setSheetHidden(workbook.getSheetIndex(name), true);
XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper((XSSFSheet) workbook.getSheet(name));
dvHelper.createFormulaListConstraint(name + "!$A$1:$A$" + strList.length);
return dvHelper;
}
生面是xlsx的檔案的添加下拉預選值，至于xls的就不展示，大概一樣的道理，有問題的隨時聯系我，
wx：wz15713598138
qq: 2585700076
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/144234.html
標籤：Java