123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 |
- package com.szwl.model.excel;
- import com.alibaba.excel.annotation.ExcelProperty;
- import com.alibaba.excel.annotation.write.style.ColumnWidth;
- import com.alibaba.excel.annotation.write.style.ContentFontStyle;
- import com.alibaba.excel.annotation.write.style.HeadFontStyle;
- import com.alibaba.excel.annotation.write.style.HeadRowHeight;
- import lombok.EqualsAndHashCode;
- import lombok.Getter;
- import lombok.Setter;
- import java.math.BigDecimal;
- @Getter
- @Setter
- @EqualsAndHashCode
- @HeadFontStyle(fontHeightInPoints = 14)
- @HeadRowHeight(20)
- @ContentFontStyle(fontHeightInPoints = 12)
- public class StatisticsClientIdTarget {
- @ColumnWidth(25)
- @ExcelProperty("账号")
- private String username;
- @ColumnWidth(30)
- @ExcelProperty("商家")
- private String name;
- @ColumnWidth(30)
- @ExcelProperty("电话")
- private String phone;
- @ColumnWidth(25)
- @ExcelProperty("地址")
- private String address;
- @ColumnWidth(30)
- @ExcelProperty("设备编号")
- private String clientId;
- @ColumnWidth(20)
- @ExcelProperty("机型")
- private String equipmentType;
- @ColumnWidth(25)
- @ExcelProperty("销售量")
- private Integer salesVolume;
- @ColumnWidth(30)
- @ExcelProperty("销售总金额")
- private BigDecimal priceTotal;
- }
|