From f465076b186e7b815b596d12a7dfa219c68e1c85 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期三, 08 七月 2020 13:47:03 +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