From 5d7b65670282a4fad015e37d567cfa171b162052 Mon Sep 17 00:00:00 2001
From: huliguo <2023611923@qq.com>
Date: 星期二, 20 五月 2025 12:25:19 +0800
Subject: [PATCH] 基础代码
---
pt-common/src/main/java/com/ruoyi/common/easyExcel/NumberConverter.java | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 57 insertions(+), 0 deletions(-)
diff --git a/pt-common/src/main/java/com/ruoyi/common/easyExcel/NumberConverter.java b/pt-common/src/main/java/com/ruoyi/common/easyExcel/NumberConverter.java
new file mode 100644
index 0000000..70a1393
--- /dev/null
+++ b/pt-common/src/main/java/com/ruoyi/common/easyExcel/NumberConverter.java
@@ -0,0 +1,57 @@
+package com.ruoyi.common.easyExcel;
+
+import com.alibaba.excel.converters.Converter;
+import com.alibaba.excel.converters.ReadConverterContext;
+import com.alibaba.excel.converters.WriteConverterContext;
+import com.alibaba.excel.enums.CellDataTypeEnum;
+import com.alibaba.excel.metadata.data.WriteCellData;
+
+
+public class NumberConverter implements Converter<Integer> {
+
+ @Override
+ public Class<?> supportJavaTypeKey() {
+ return String.class;
+ }
+
+ @Override
+ public CellDataTypeEnum supportExcelTypeKey() {
+ return CellDataTypeEnum.STRING;
+ }
+
+ /**
+ * 这里读的时候会调用
+ *
+ * @param context
+ * @return
+ */
+ @Override
+ public Integer convertToJavaData(ReadConverterContext<?> context) {
+ try {
+ // 检查是否是字符串类型的单元格
+ if (CellDataTypeEnum.STRING.equals(context.getReadCellData().getType())) {
+ return Integer.parseInt(context.getReadCellData().getStringValue());
+ }
+ // 检查是否是数字类型的单元格
+ else if (CellDataTypeEnum.NUMBER.equals(context.getReadCellData().getType())) {
+ // 获取数字值并转化为字符串
+ return context.getReadCellData().getNumberValue().intValue();
+ } else {
+ return null; // 返回null表示未能识别的单元格类型
+ }
+ }catch (Exception e){
+ return null;
+ }
+ }
+
+ /**
+ * 这里是写的时候会调用 不用管
+ *
+ * @return
+ */
+ @Override
+ public WriteCellData<?> convertToExcelData(WriteConverterContext<Integer> context) {
+ return new WriteCellData<>(String.valueOf(context.getValue()));
+ }
+}
+
--
Gitblit v1.7.1