From 5e49ed67e8980d649201aab001511aec4f03bfeb Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期二, 29 十月 2024 17:19:43 +0800
Subject: [PATCH] 演示
---
src/main/java/com/ycl/jxkg/excel/SelectExcel.java | 25 ++++++++++++++++++++++++-
1 files changed, 24 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/ycl/jxkg/excel/SelectExcel.java b/src/main/java/com/ycl/jxkg/excel/SelectExcel.java
index c4e8cde..2de1850 100644
--- a/src/main/java/com/ycl/jxkg/excel/SelectExcel.java
+++ b/src/main/java/com/ycl/jxkg/excel/SelectExcel.java
@@ -29,7 +29,7 @@
/**
* 閫夐」涓嬫媺鏁版嵁
*/
- private String[] optionList = {"A","B","C","D","E","F","G","H"};
+ private String[] optionList = {"A", "B", "C", "D", "E", "F", "G", "H"};
public SelectExcel(List subjectNameList) {
this.subjectNameList = subjectNameList;
@@ -49,6 +49,8 @@
// 娣诲姞棰樼洰涓嬫媺
DataValidationConstraint questionConstraint = dataValidationHelper.createExplicitListConstraint(questionTypeList);
DataValidation questionValidation = dataValidationHelper.createValidation(questionConstraint, questionTypeRange);
+
+ setValidation(questionValidation);
sheet.addValidationData(questionValidation);
@@ -57,6 +59,8 @@
// 娣诲姞璇剧洰涓嬫媺
DataValidationConstraint subjectConstraint = dataValidationHelper.createExplicitListConstraint(subjectNameList.toArray((new String[0])));
DataValidation subjectValidation = dataValidationHelper.createValidation(subjectConstraint, subjectTypeRange);
+
+ setValidation(subjectValidation);
sheet.addValidationData(subjectValidation);
// 璁剧疆閫夐」涓嬫媺鑼冨洿锛岀4鍒楋紝1500琛屽唴
@@ -64,6 +68,8 @@
// 娣诲姞閫夐」涓嬫媺
DataValidationConstraint optionConstraint = dataValidationHelper.createExplicitListConstraint(optionList);
DataValidation optionValidation = dataValidationHelper.createValidation(optionConstraint, optionRange);
+
+ setValidation(optionValidation);
sheet.addValidationData(optionValidation);
// 璁剧疆閫夐」涓嬫媺鑼冨洿锛岀4鍒楋紝1500琛屽唴
@@ -71,7 +77,24 @@
// 娣诲姞閫夐」涓嬫媺
DataValidationConstraint answerConstraint = dataValidationHelper.createExplicitListConstraint(optionList);
DataValidation answerValidation = dataValidationHelper.createValidation(answerConstraint, answerRange);
+ setValidation(answerValidation);
sheet.addValidationData(answerValidation);
+ // 闅鹃亾1-5
+ String[] difficultList = new String[]{"1", "2", "3", "4", "5"};
+ CellRangeAddressList difficultRange = new CellRangeAddressList(2, 1500, 8, 8);
+ // 娣诲姞閫夐」涓嬫媺
+ DataValidationConstraint difficultConstraint = dataValidationHelper.createExplicitListConstraint(difficultList);
+ DataValidation difficultValidation = dataValidationHelper.createValidation(difficultConstraint, difficultRange);
+ setValidation(difficultValidation);
+ sheet.addValidationData(difficultValidation);
+ }
+ private DataValidation setValidation(DataValidation dataValidation){
+ dataValidation.setEmptyCellAllowed(false);
+ dataValidation.setSuppressDropDownArrow(true);
+ dataValidation.setShowErrorBox(true);
+ //璁剧疆杈撳叆閿欒鎻愮ず淇℃伅
+ dataValidation.createErrorBox("閫夋嫨閿欒鎻愮ず", "浣犺緭鍏ョ殑鍊兼湭鍦ㄥ閫夊垪琛ㄤ腑锛岃涓嬫媺閫夋嫨鍚堥�傜殑鍊�!");
+ return dataValidation;
}
}
--
Gitblit v1.8.0