package com.wms_admin.excel; import com.alibaba.excel.annotation.ExcelIgnore; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.write.style.ColumnWidth; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; @Data @AllArgsConstructor @NoArgsConstructor @ColumnWidth(18) // excel表头宽度 public class ExcelSendAndStoringUtil { @ExcelIgnore private Integer id; @ExcelProperty("产品编码") private String productCode; @ExcelProperty("产品名称") private String productName; @ExcelProperty("规格型号") private String productModel; @ExcelProperty("单位") private String productUnit; @ExcelProperty("期初库存") private String beginningInventory; @ExcelProperty("本期入库") private String currentPeriod; @ExcelProperty("本期出库") private String issueInCurrentPeriod; @ExcelProperty("期末库存") private String closingInventory; }