From bdf5047ae48457ad397bd87a524cafc7beba03b3 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期一, 22 六月 2020 08:50:29 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/utils/excel/ExcelUtils.java | 43 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 43 insertions(+), 0 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
new file mode 100644
index 0000000..561cb39
--- /dev/null
+++ b/src/main/java/com/zy/common/utils/excel/ExcelUtils.java
@@ -0,0 +1,43 @@
+package com.zy.common.utils.excel;
+
+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;
+
+/**
+ * Created by vincent on 2019-11-24
+ */
+public class ExcelUtils {
+
+ public static void main(String[] args) {
+ new ExcelUtils().simpleWrite();
+ }
+
+ public void simpleRead(){
+ 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", MatCodeExcel.class).sheet("lxt").doWrite(data());
+ }
+
+ public static List<MatCodeExcel> data(){
+ List<MatCodeExcel> list = new ArrayList<>();
+ for (int i = 0; i<1000; i++) {
+ MatCodeExcel data = new MatCodeExcel();
+ data.setMatNo("1902997-5/6");
+ data.setBarcode("80001854");
+ data.setMatName("閾濆甫|1100-O|0.33*475|");
+ data.setStr1("701010015907");
+ list.add(data);
+ }
+ return list;
+ }
+
+
+}
--
Gitblit v1.9.1