From 9803cf843fc2d74ac7ace3ced936a448197f6e00 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期一, 08 六月 2020 14:52:59 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/utils/excel/ExcelUtils.java | 25 ++++++++++++++-----------
1 files changed, 14 insertions(+), 11 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..61cc2a7 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;
@@ -12,30 +14,31 @@
public class ExcelUtils {
public static void main(String[] args) {
-// new ExcelUtils().simpleRead();
new ExcelUtils().simpleWrite();
}
public void simpleRead(){
- ExcelReaderBuilder read = EasyExcel.read("/Users/vincent/Desktop/3869.xls", EnInitData.class, new EnInitDataListener());
- // 璇诲彇绗竴涓猻heet(琛�),鏂囦欢娴佷細鑷姩鍏抽棴
+ ExcelReaderBuilder read = EasyExcel.read("/Users/vincent/Desktop/3869.xls", MatCodeExcel.class, new MatCodeExcelListener());
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("1902997-5/6");
+ data.setBarcode("80001854");
+ data.setMatName("閾濆甫|1100-O|0.33*475|");
+ data.setStr1("701010015907");
+ data.setStr2("榧庤儨閾濅笟棣欐腐_椹潵瑗夸簹UPT");
list.add(data);
}
return list;
}
+
+
}
--
Gitblit v1.9.1