Java中使用Hutool动态给Excel中添加下拉框

1. 1

ExcelWriter writer = ExcelUtil.getWriter(new File("D:\\Users\\DELL\\Desktop\\test.xlsx"));
        writer.setColumnWidth(0, 0);
        Sheet sheet = writer.getSheet();
        int firstRow = 0,lastRow = 5000,firstCol = 1,lastCol = 5;
        // 单元格范围地址列表
        CellRangeAddressList addressList = new CellRangeAddressList(firstRow, lastRow, firstCol, lastCol);
        //单元格样式
        StyleSet styleSet = writer.getStyleSet();
        CellStyle cellStyle = styleSet.getCellStyle();
        cellStyle.setDataFormat((short) BuiltinFormats.getBuiltinFormat("text"));
        //数据验证助手
        String[] values = { "选择1", "选择2", "选择3" };
        DataValidationHelper helper = sheet.getDataValidationHelper();
        DataValidationConstraint constraint = helper.createExplicitListConstraint(values);
        //数据验证
        DataValidation dataValidation = helper.createValidation(constraint, addressList);
        writer.addValidationData(dataValidation);
        writer.flush();
        writer.close();

2. 2

 try (Workbook workbook = new XSSFWorkbook()) {
            Sheet sheet = workbook.createSheet("Dropdown Example");
            CellRangeAddressList addressList = new CellRangeAddressList(0, 0, 0, 0); // 指定单元格范围，这里是第一行第一列

            DataValidationHelper validationHelper = sheet.getDataValidationHelper();
            DataValidationConstraint dvConstraint = validationHelper.createExplicitListConstraint(new String[]{"Option 1", "Option 2", "Option 3"}); // 设置下拉框选项
            DataValidation dataValidation = validationHelper.createValidation(dvConstraint, addressList); // 创建数据验证对象
            sheet.addValidationData(dataValidation); // 添加验证对象到工作表

            FileOutputStream fileOut = new FileOutputStream("D:\\Users\\DELL\\Desktop\\test.xlsx");
            workbook.write(fileOut);
            fileOut.close();
        } catch (IOException e) {
            e.printStackTrace();
        }