From 1c3c68d3dc45e4d519088de17001284858de5eb9 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期六, 06 六月 2020 10:50:02 +0800
Subject: [PATCH] #导出
---
src/main/java/com/zy/common/utils/excel/ExcelUtils.java | 14 +++++++-------
1 files changed, 7 insertions(+), 7 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 d51ec8e..61cc2a7 100644
--- a/src/main/java/com/zy/common/utils/excel/ExcelUtils.java
+++ b/src/main/java/com/zy/common/utils/excel/ExcelUtils.java
@@ -14,13 +14,11 @@
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", MatCodeExcel.class, new MatCodeExcelListener());
- // 璇诲彇绗竴涓猻heet(琛�),鏂囦欢娴佷細鑷姩鍏抽棴
read.sheet().doRead();
}
@@ -32,13 +30,15 @@
List<MatCodeExcel> list = new ArrayList<>();
for (int i = 0; i<1000; i++) {
MatCodeExcel data = new MatCodeExcel();
- data.setMatNo("1");
- data.setBarcode("2");
- data.setMatName("3");
- data.setStr1("5");
- data.setStr2("6");
+ 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