From 47cd9ecc0eff38ffe6b3b794b2bf197e958f4403 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期三, 14 五月 2025 15:50:57 +0800
Subject: [PATCH] bug：学员有状态不能修改问题
---
src/main/java/com/mindskip/xzs/excel/SelectExcel.java | 19 +++++++------------
1 files changed, 7 insertions(+), 12 deletions(-)
diff --git a/src/main/java/com/mindskip/xzs/excel/SelectExcel.java b/src/main/java/com/mindskip/xzs/excel/SelectExcel.java
index 0c91aeb..07d185b 100644
--- a/src/main/java/com/mindskip/xzs/excel/SelectExcel.java
+++ b/src/main/java/com/mindskip/xzs/excel/SelectExcel.java
@@ -2,16 +2,11 @@
import com.alibaba.excel.metadata.Head;
import com.alibaba.excel.metadata.data.WriteCellData;
-import com.alibaba.excel.write.handler.AbstractCellWriteHandler;
import com.alibaba.excel.write.handler.CellWriteHandler;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteTableHolder;
import org.apache.poi.ss.usermodel.*;
-import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.CellRangeAddressList;
-
-import java.util.ArrayList;
-import java.util.Arrays;
import java.util.List;
/**
@@ -45,7 +40,7 @@
Sheet sheet = writeSheetHolder.getSheet();
- // 鑾峰彇鏁版嵁鏍￠獙helper
+ // 鑾峰彇鏁版嵁鏍￠獙helper锛宔xcel鐨勪笅鎷夊氨鏄�氳繃鏁版嵁鏍￠獙璁剧疆
DataValidationHelper dataValidationHelper = sheet.getDataValidationHelper();
// 璁剧疆棰樼洰涓嬫媺鑼冨洿锛岀涓�鍒楋紝1500琛屽唴
@@ -63,12 +58,12 @@
DataValidation subjectValidation = dataValidationHelper.createValidation(subjectConstraint, subjectTypeRange);
sheet.addValidationData(subjectValidation);
- // 璁剧疆閫夐」涓嬫媺鑼冨洿锛岀4鍒楋紝1500琛屽唴
- CellRangeAddressList optionRange = new CellRangeAddressList(2, 1500, 3, 3);
- // 娣诲姞閫夐」涓嬫媺
- DataValidationConstraint optionConstraint = dataValidationHelper.createExplicitListConstraint(optionList);
- DataValidation optionValidation = dataValidationHelper.createValidation(optionConstraint, optionRange);
- sheet.addValidationData(optionValidation);
+// // 璁剧疆閫夐」涓嬫媺鑼冨洿锛岀4鍒楋紝1500琛屽唴
+// CellRangeAddressList optionRange = new CellRangeAddressList(2, 1500, 3, 3);
+// // 娣诲姞閫夐」涓嬫媺
+// DataValidationConstraint optionConstraint = dataValidationHelper.createExplicitListConstraint(optionList);
+// DataValidation optionValidation = dataValidationHelper.createValidation(optionConstraint, optionRange);
+// sheet.addValidationData(optionValidation);
// 璁剧疆閫夐」涓嬫媺鑼冨洿锛岀4鍒楋紝1500琛屽唴
CellRangeAddressList answerRange = new CellRangeAddressList(2, 1500, 5, 5);
--
Gitblit v1.8.0