EasyExcel和Apache POI实现Excel指定列浮点数范围限制 - 导出限制输入1-5的浮点数

要实现对指定列限制为只能输入1-5的浮点数，可以使用 EasyExcel 和 Apache POI 的结合。\n\n首先，使用 EasyExcel 创建一个 Excel 文件，并定义列的样式和限制条件。然后，使用 Apache POI 对指定列的单元格进行数据验证，限制输入的范围为1-5的浮点数。\n\n下面是一个示例代码：\n\njava\nimport com.alibaba.excel.EasyExcel;\nimport com.alibaba.excel.metadata.Sheet;\nimport com.alibaba.excel.metadata.Table;\nimport com.alibaba.excel.write.metadata.style.WriteCellStyle;\nimport com.alibaba.excel.write.style.HorizontalCellStyleStrategy;\nimport org.apache.poi.ss.usermodel.*;\n\nimport java.io.FileOutputStream;\nimport java.util.ArrayList;\nimport java.util.List;\n\npublic class ExcelExportExample {\n\n public static void main(String[] args) throws Exception {\n // 创建测试数据\n List<DemoData> data = new ArrayList<>();\n for (int i = 0; i < 10; i++) {\n DemoData demoData = new DemoData();\n demoData.setName("Name " + i);\n demoData.setValue(0);\n data.add(demoData);\n }\n\n // 创建 Excel 文件\n String fileName = "export.xlsx";\n FileOutputStream fileOutputStream = new FileOutputStream(fileName);\n\n // 设置列的样式和限制条件\n WriteCellStyle style = new WriteCellStyle();\n style.setDataFormat((short) BuiltinFormats.getBuiltinFormat("0.00")); // 设置数字格式为两位小数\n\n HorizontalCellStyleStrategy horizontalCellStyleStrategy = new HorizontalCellStyleStrategy(style, style);\n\n // 定义 Sheet 和 Table\n Sheet sheet = new Sheet(1, 0, DemoData.class);\n Table table = new Table(1);\n\n // 设置列的宽度\n sheet.setColumnWidth(1, 20 * 256);\n\n // 写入数据\n EasyExcel.write(fileOutputStream, DemoData.class)\n .registerWriteHandler(horizontalCellStyleStrategy)\n .sheet().doWrite(data);\n\n // 使用 Apache POI 对指定列的单元格进行数据验证\n Workbook workbook = WorkbookFactory.create(fileOutputStream);\n Sheet worksheet = workbook.getSheetAt(0);\n DataValidationHelper validationHelper = worksheet.getDataValidationHelper();\n DataValidationConstraint constraint = validationHelper.createDecimalConstraint(DataValidationConstraint.OperatorType.BETWEEN, "1", "5");\n CellRangeAddressList addressList = new CellRangeAddressList(1, worksheet.getLastRowNum(), 1, 1);\n DataValidation validation = validationHelper.createValidation(constraint, addressList);\n validation.setShowErrorBox(true);\n worksheet.addValidationData(validation);\n\n // 保存并关闭 Excel 文件\n workbook.write(fileOutputStream);\n fileOutputStream.close();\n workbook.close();\n\n System.out.println("Excel exported successfully.");\n }\n\n public static class DemoData {\n private String name;\n private Double value;\n\n // getters and setters\n\n public String getName() {\n return name;\n }\n\n public void setName(String name) {\n this.name = name;\n }\n\n public Double getValue() {\n return value;\n }\n\n public void setValue(Double value) {\n this.value = value;\n }\n }\n}\n\n\n在上面的示例代码中，首先创建了一个包含10行数据的 Excel 文件，并设置了列的样式和限制条件。然后使用 Apache POI 对第二列的单元格进行了数据验证，限制输入的范围为1-5的浮点数。\n\n最后保存并关闭 Excel 文件，输出成功信息。\n\n注意：需要在 pom.xml 文件中添加 EasyExcel 和 Apache POI 的依赖。\n\nxml\n<dependencies>\n <dependency>\n <groupId>com.alibaba</groupId>\n <artifactId>easyexcel</artifactId>\n <version>2.2.11</version>\n </dependency>\n <dependency>\n <groupId>org.apache.poi</groupId>\n <artifactId>poi</artifactId>\n <version>4.1.2</version>\n </dependency>\n</dependencies>\n\n\n希望对你有所帮助！