poi excel 下拉框单元格合并

最新推荐文章于 2023-12-07 16:09:45 发布

wking00000

最新推荐文章于 2023-12-07 16:09:45 发布

阅读量350

点赞数

分类专栏：笔记文章标签： java

本文链接：https://blog.csdn.net/qq_33443020/article/details/121967976

版权

// 下拉框
//String[] selectList = new String[]{"刘德华", "张学友", "黎明", "郭富城", "金城武", "梁朝伟"};
List<? extends IDataDictionary> selectList = CodeRepositoryUtil.getDictionary(jobj.getString("catalogCode"));
// 数据源sheet页不隐藏
HSSFSheet hidden = workbook.createSheet("sheet名称");
workbook.setSheetHidden(1, true);//隐藏sheet
// 将下拉列表的数据放在数据源sheet上
HSSFCell cellhidden = null;
for (int j = 0, length = selectList.size(); j < length; j++) {
    HSSFRow hiddenRow = hidden.createRow(j);
    cellhidden = hiddenRow.createCell(0);
    cellhidden.setCellValue(selectList.get(j).getDataValue());
}
// 指定下拉数据时，给定目标数据范围 hiddenSheetName!$A$1:$A5   sheet的A1到A5格的数据
DVConstraint constraint = DVConstraint.createFormulaListConstraint("sheet名称" + "!$A$1" + ":$A" + selectList.size());
CellRangeAddressList addressList = null;
HSSFDataValidation validation = n