From 09eaf721ff967b3e10d70ee981269bd5d5439ccc Mon Sep 17 00:00:00 2001
From: tangxiaobao <303826152@qq.com>
Date: 星期三, 14 七月 2021 14:15:30 +0800
Subject: [PATCH] 基础数据库改版变动
---
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/excel/CustomSheetWriteHandler.java | 18 +++++++++++++-----
1 files changed, 13 insertions(+), 5 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/excel/CustomSheetWriteHandler.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/excel/CustomSheetWriteHandler.java
index 64e1849..526b10e 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/excel/CustomSheetWriteHandler.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/excel/CustomSheetWriteHandler.java
@@ -29,19 +29,27 @@
LOGGER.info("第{}个Sheet写入成功。", writeSheetHolder.getSheetNo());
// 区间设置 第一列第一行和第二行的数据。由于第一行是头，所以第一、二行的数据实际上是第二三行
- CellRangeAddressList cellRangeAddressList = new CellRangeAddressList(1, 2000, 1, 1);
- CellRangeAddressList cellRangeAddressList1 = new CellRangeAddressList(1, 2000, 3 ,3);
- CellRangeAddressList cellRangeAddressList2 = new CellRangeAddressList(1, 2000, 10 ,10);
+ CellRangeAddressList cellRangeAddressList = new CellRangeAddressList(1, 2000, 11, 11);
+ CellRangeAddressList cellRangeAddressList1 = new CellRangeAddressList(1, 2000, 4 ,4);
+ CellRangeAddressList cellRangeAddressList2 = new CellRangeAddressList(1, 2000, 6 ,6);
+ CellRangeAddressList cellRangeAddressList3 = new CellRangeAddressList(1, 2000, 13 ,13);
+ CellRangeAddressList cellRangeAddressList4 = new CellRangeAddressList(1, 2000, 14 ,14);
DataValidationHelper helper = writeSheetHolder.getSheet().getDataValidationHelper();
- DataValidationConstraint constraint = helper.createExplicitListConstraint(new String[] {"是", "否"});
+ DataValidationConstraint constraint = helper.createExplicitListConstraint(new String[] {"男", "女","未知"});
DataValidationConstraint constraint1 = helper.createExplicitListConstraint(new String[] {"中共党员","中共预备党员","共青团员","民革党员","民盟盟员","民建会员","农工党党员","致公党党员","九三学社社员","台盟盟员","无党派人士","群众"});
- DataValidationConstraint constraint2 = helper.createExplicitListConstraint(new String[] {"男", "女","未知"});
+ DataValidationConstraint constraint2 = helper.createExplicitListConstraint(new String[] {"本地", "外地"});
+ DataValidationConstraint constraint3 = helper.createExplicitListConstraint(new String[] {"未婚", "已婚", "初婚", "再婚", "复婚", "丧偶", "离婚", "未说明的婚育状况"});
+ DataValidationConstraint constraint4 = helper.createExplicitListConstraint(new String[] {"很好", "较好", "一般", "较差", "很差"});
DataValidation dataValidation = helper.createValidation(constraint2, cellRangeAddressList);
DataValidation dataValidation1 = helper.createValidation(constraint, cellRangeAddressList1);
DataValidation dataValidation2= helper.createValidation(constraint1, cellRangeAddressList2);
+ DataValidation dataValidation3 = helper.createValidation(constraint3, cellRangeAddressList3);
+ DataValidation dataValidation4= helper.createValidation(constraint4, cellRangeAddressList4);
writeSheetHolder.getSheet().addValidationData(dataValidation);
writeSheetHolder.getSheet().addValidationData(dataValidation1);
writeSheetHolder.getSheet().addValidationData(dataValidation2);
+ writeSheetHolder.getSheet().addValidationData(dataValidation3);
+ writeSheetHolder.getSheet().addValidationData(dataValidation4);
}
}
--
Gitblit v1.7.1