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 | 44 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 44 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..61cc2a7
--- /dev/null
+++ b/src/main/java/com/zy/common/utils/excel/ExcelUtils.java
@@ -0,0 +1,44 @@
+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");
+ data.setStr2("榧庤儨閾濅笟棣欐腐_椹潵瑗夸簹UPT");
+ list.add(data);
+ }
+ return list;
+ }
+
+
+}
--
Gitblit v1.9.1