From 5dd0071775a7252ed22e4c6bfd1c3ee7daeb012a Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期六, 06 六月 2020 09:36:26 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/utils/excel/ExcelUtils.java | 21 ++++++++++++---------
1 files changed, 12 insertions(+), 9 deletions(-)
diff --git a/src/main/java/com/zy/common/utils/excel/ExcelUtils.java b/src/main/java/com/zy/common/utils/excel/ExcelUtils.java
index 0532402..d51ec8e 100644
--- a/src/main/java/com/zy/common/utils/excel/ExcelUtils.java
+++ b/src/main/java/com/zy/common/utils/excel/ExcelUtils.java
@@ -2,6 +2,8 @@
import com.alibaba.excel.EasyExcel;
import com.alibaba.excel.read.builder.ExcelReaderBuilder;
+import com.zy.common.utils.excel.matcode.MatCodeExcel;
+import com.zy.common.utils.excel.matcode.MatCodeExcelListener;
import java.util.ArrayList;
import java.util.List;
@@ -17,23 +19,24 @@
}
public void simpleRead(){
- ExcelReaderBuilder read = EasyExcel.read("/Users/vincent/Desktop/3869.xls", EnInitData.class, new EnInitDataListener());
+ ExcelReaderBuilder read = EasyExcel.read("/Users/vincent/Desktop/3869.xls", MatCodeExcel.class, new MatCodeExcelListener());
// 璇诲彇绗竴涓猻heet(琛�),鏂囦欢娴佷細鑷姩鍏抽棴
read.sheet().doRead();
}
public void simpleWrite(){
- EasyExcel.write("/Users/vincent/Desktop/writeDemo.xls", EnInitData.class).sheet("lxt").doWrite(data());
+ EasyExcel.write("/Users/vincent/Desktop/writeDemo.xls", MatCodeExcel.class).sheet("lxt").doWrite(data());
}
- public static List<EnInitData> data(){
- List<EnInitData> list = new ArrayList<>();
+ public static List<MatCodeExcel> data(){
+ List<MatCodeExcel> list = new ArrayList<>();
for (int i = 0; i<1000; i++) {
- EnInitData data = new EnInitData();
- data.setEnName("娴嬭瘯");
- data.setCode("test");
- data.setOffice("鍥藉绋庡姟鎬诲眬鏉窞甯備綑鏉尯绋庡姟灞�浣欐澀绋庡姟鎵�");
- data.setMobile("15988786205");
+ MatCodeExcel data = new MatCodeExcel();
+ data.setMatNo("1");
+ data.setBarcode("2");
+ data.setMatName("3");
+ data.setStr1("5");
+ data.setStr2("6");
list.add(data);
}
return list;
--
Gitblit v1.9.1