EquipmentPointExcel.java 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. package com.persagy.proxy.report.model;
  2. import com.alibaba.excel.annotation.ExcelProperty;
  3. import com.alibaba.excel.annotation.write.style.ColumnWidth;
  4. import com.alibaba.excel.annotation.write.style.HeadFontStyle;
  5. import lombok.Getter;
  6. import lombok.Setter;
  7. import org.apache.poi.ss.usermodel.Font;
  8. /**
  9. * @author lvxianyun
  10. * @title: EquipmentPointExcel
  11. * @projectName adm-middleware
  12. * @description: 导出设备的静态或动态信息点
  13. * @date 2021/11/23 18:27
  14. */
  15. @Getter
  16. @Setter
  17. @HeadFontStyle(color = Font.COLOR_NORMAL)
  18. public class EquipmentPointExcel {
  19. @ColumnWidth(50)
  20. @ExcelProperty(value = "设备id", index=0)
  21. private String id;
  22. @ColumnWidth(20)
  23. @ExcelProperty(value = "本地编码", index=1)
  24. private String localId;
  25. @ColumnWidth(20)
  26. @ExcelProperty(value = "本地名称", index=2)
  27. private String localName;
  28. @ColumnWidth(20)
  29. @ExcelProperty(value = "设备类型编码", index=3)
  30. private String classCode;
  31. @ColumnWidth(20)
  32. @ExcelProperty(value = "设备类型名称", index=4)
  33. private String classCodeName;
  34. @ColumnWidth(20)
  35. @ExcelProperty(value = "一级标签", index=5)
  36. private String mapInputFirstName;
  37. @ColumnWidth(20)
  38. @ExcelProperty(value = "信息点名", index=6)
  39. private String infoName;
  40. @ColumnWidth(25)
  41. @ExcelProperty(value = "信息点编码", index=7)
  42. private String infoCode;
  43. @ColumnWidth(25)
  44. @ExcelProperty(value = "输入类型", index=8)
  45. private String inputType;
  46. @ColumnWidth(25)
  47. @ExcelProperty(value = "已交付值", index=9)
  48. private String inputValue;
  49. }