From 28722d8bd5fabef4493801c69ba1bbc1599afb6c Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期三, 27 一月 2021 14:30:25 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/common/utils/excel/matcode/MatCodeExcel.java | 165 +++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 124 insertions(+), 41 deletions(-)
diff --git a/src/main/java/com/zy/common/utils/excel/matcode/MatCodeExcel.java b/src/main/java/com/zy/common/utils/excel/matcode/MatCodeExcel.java
index 4e33277..0092f27 100644
--- a/src/main/java/com/zy/common/utils/excel/matcode/MatCodeExcel.java
+++ b/src/main/java/com/zy/common/utils/excel/matcode/MatCodeExcel.java
@@ -1,67 +1,150 @@
package com.zy.common.utils.excel.matcode;
+import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
+import lombok.Data;
+
/**
- * Created by vincent on 2020/6/6
+ * 0.A 1.B 2.C 3.D 4.E 5.F 6.G 7.H 8.I
+ * 9.J 10.K 11.L 12.M 13.N 14.O 15.P 16.Q 17.R 18.S
+ * 19.T 20.U 21.V 22.W 23.X 24.Y 25.Z
*/
+@Data
+@ExcelIgnoreUnannotated
public class MatCodeExcel {
- /**
- * 鐗╂枡缂栫爜
- */
- @ExcelProperty(value = "鐗╂枡缂栫爜", index = 0)
+ @ExcelProperty(value= "浜у搧浠ｅ彿*", index = 0)
private String matNo;
- /**
- * 鏉＄爜
- */
- @ExcelProperty(value = "鏉＄爜", index = 1)
+ // @ExcelProperty(value= "鏉″舰鐮�", index = 4)
private String barcode;
- /**
- * 鐗╂枡鍚嶇О
- */
- @ExcelProperty(value = "鐗╂枡鍚嶇О", index = 2)
+ @ExcelProperty(value= "浜у搧鍚嶇О", index = 3)
private String matName;
- /**
- * 鐗╂枡鍗曚綅
- */
- @ExcelProperty(value = "鐗╂枡鍗曚綅", index = 3)
+ @ExcelProperty(value= "鍩烘湰鍗曚綅", index = 12)
private String str1;
+ @ExcelProperty(value= "瑙勬牸鍨嬪彿", index = 5)
+ private String str2;
- public String getMatNo() {
- return matNo;
+ @ExcelProperty(value= "棰滆壊鍚嶇О", index = 28)
+ private String str3;
+
+ @ExcelProperty(value= "搴撲綅鍚嶇О", index = 14)
+ private String str4;
+
+ // @ExcelProperty(value= "鍔╄鐮�", index = 7)
+ private String str5;
+
+ // @ExcelProperty(value= "榛樿渚涘簲鍟�", index = 10)
+ private String str6;
+
+ // @ExcelProperty(value= "榛樿浠撳簱", index = 13)
+ private String str7;
+
+ // @ExcelProperty(value= "鍝佺墝", index = 9)
+ private String str8;
+
+ // @ExcelProperty(value= "閲囪喘鍛�", index = 11)
+ private String str9;
+
+ // @ExcelProperty(value= "浜у湴", index = 12)
+ private String str10;
+
+ // @ExcelProperty(value= "搴忓垪鍙风鐞�")
+ private String str11;
+
+ // @ExcelProperty(value= "鎵规绠＄悊")
+ private String str12;
+
+ // @ExcelProperty(value= "淇濊川鏈熷崟浣�")
+ private String str13;
+
+ // @ExcelProperty(value= "淇濊川鏈熺鐞�")
+ private String str14;
+
+ // @ExcelProperty(value= "淇濊川鏈�")
+ private String str15;
+
+ // @ExcelProperty(value= "鍙攢鍞�", index = 20)
+ private String str16;
+
+ // @ExcelProperty(value= "鍙噰璐�", index = 21)
+ private String str17;
+
+ // @ExcelProperty(value= "鍙负瀛愪欢", index = 22)
+ private String str18;
+
+ // @ExcelProperty(value= "鍙负缁勪欢", index = 23)
+ private String str19;
+
+ // @ExcelProperty(value= "杈呭姪灞炴�х鐞�")
+ private String str20;
+
+ // @ExcelProperty(value= "鎴愭湰璁＄畻鏂规硶", index = 29)
+ private String str21;
+
+ // @ExcelProperty(value= "閲囪喘鍗曚綅", index = 30)
+ private String str22;
+
+ // @ExcelProperty(value= "閿�鍞崟浣�", index = 31)
+ private String str23;
+
+ // @ExcelProperty(value= "閲嶉噺", index = 7)
+ private Double num1;
+
+ // @ExcelProperty(value= "鏈�浣庡簱瀛樻暟閲�")
+ private Double num2;
+
+ // @ExcelProperty(value= "鏈�楂樺簱瀛樻暟閲�")
+ private Double num3;
+
+ // @ExcelProperty(value= "瀹夊叏搴撳瓨")
+ private Double num4;
+
+ // @ExcelProperty(value= "绋庣巼")
+ private Double num5;
+
+ private Double num6;
+
+ public MatCodeExcel() {
}
- public void setMatNo(String matNo) {
+ public MatCodeExcel(String matNo, String barcode, String matName, String str1, String str2, String str3, String str4, String str5, String str6, String str7, String str8, String str9, String str10, String str11, String str12, String str13, String str14, String str15, String str16, String str17, String str18, String str19, String str20, String str21, String str22, String str23, Double num1, Double num2, Double num3, Double num4, Double num5, Double num6) {
this.matNo = matNo;
- }
-
- public String getBarcode() {
- return barcode;
- }
-
- public void setBarcode(String barcode) {
this.barcode = barcode;
- }
-
- public String getMatName() {
- return matName;
- }
-
- public void setMatName(String matName) {
this.matName = matName;
- }
-
- public String getStr1() {
- return str1;
- }
-
- public void setStr1(String str1) {
this.str1 = str1;
+ this.str2 = str2;
+ this.str3 = str3;
+ this.str4 = str4;
+ this.str5 = str5;
+ this.str6 = str6;
+ this.str7 = str7;
+ this.str8 = str8;
+ this.str9 = str9;
+ this.str10 = str10;
+ this.str11 = str11;
+ this.str12 = str12;
+ this.str13 = str13;
+ this.str14 = str14;
+ this.str15 = str15;
+ this.str16 = str16;
+ this.str17 = str17;
+ this.str18 = str18;
+ this.str19 = str19;
+ this.str20 = str20;
+ this.str21 = str21;
+ this.str22 = str22;
+ this.str23 = str23;
+ this.num1 = num1;
+ this.num2 = num2;
+ this.num3 = num3;
+ this.num4 = num4;
+ this.num5 = num5;
+ this.num6 = num6;
}
}
--
Gitblit v1.9.1