package com.moral.api.util; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.format.DateTimeFormat; import com.alibaba.excel.annotation.write.style.ColumnWidth; import lombok.Data; import java.io.Serializable; import java.math.BigDecimal; import java.util.Date; /** * @ClassName DeviceExcelDTO * @Description TODO * @Author @cjl * @Date 2024-01-24 11:13 * @Version 1.0 */ @Data public class DeviceExcelDTO implements Serializable { @ExcelProperty(value = "设备名称") private String name; @ExcelProperty(value = "时间") @DateTimeFormat(value = "yyyy-MM-dd HH:mm") private Date time; @ExcelProperty(value = "PM2.5") private BigDecimal a34004; @ExcelProperty(value = "温度") private BigDecimal a01001; @ExcelProperty(value = "湿度") private BigDecimal a01002; @ExcelProperty(value = "噪音") private BigDecimal a00e13; @ExcelProperty(value = "二氧化碳") private BigDecimal a00e19; @ExcelProperty(value = "甲醛") private BigDecimal a31001; @ExcelProperty(value = "TVOC") private BigDecimal a99054; }