• 最近造了個poi導出 excel輪子
• 特點
  • java bean 一對多、多對一關系合并單元行
  • 支持圖片導出

Bean 一對多關系合并行

• 代碼

public class User { @Excel(name = "編號") private String serialNumber; @Excel(name = "國籍") private String citizenship; @Excel(name = "省份") private String province; @Excel(name = "城市") private String city; @Excel(name = "市區") private String area; /** * 一對多合并注解 */ @ExcelCollection private List userInfoList;}public class UserInfo { @Excel(name = "頭像") private String avatar; @Excel(name = "用戶名") private String name; @Excel(name = "年齡") private Integer age; @Excel(name = "性別") private Integer sex;}

• 關鍵是ExcelCollection注解

Bean 多對一關系合并行

• 代碼

public class ManyOneBean { @ExcelCollection private List manyOne;}public class ManyOne { @Excel(name = "產品名稱") private String productName; @Excel(name = "品牌名稱") private String breanName; @Excel(name = "金額") private Integer amount; @Excel(name = "產品原單價", manyOneMerge = true) private String originalUnitPrice; @Excel(name = "優惠單價", manyOneMerge = true) private String discountUnitPrice; @Excel(name = "總金額", manyOneMerge = true) private Integer totalAmount;}

• 關鍵是ExcelCollection注解以及Excel注解中的manyOneMerge設置值

最后

• 輪子初步實現以上功能，僅供自己玩耍。后續繼續完善，奧力給

總結

以上是生活随笔為你收集整理的@excel注解_java bean 一对多，多对一 poi导出excel表格的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。