**1. 創建對應的實體類** ```java @Data @AllArgsConstructor //頭背景設置成紅色 IndexedColors.RED.getIndex() @HeadStyle(fillPatternType = FillPatternTypeEnum.SOLID_FOREGROUND, fillForegroundColor = 10) //頭字體大小設置成20，字體為雅黑 @HeadFontStyle(fontHeightInPoints = 20, fontName = "雅黑") //內容的背景設置成綠色 IndexedColors.GREEN.getIndex() @ContentStyle(fillPatternType = FillPatternTypeEnum.SOLID_FOREGROUND, fillForegroundColor = 17) //內容字體大小設置成20，字體為宋體 @ContentFontStyle(fontHeightInPoints = 20, fontName = "宋體") public class Computer { /** 上面的@XXXStyle注解也可以用在屬性上，來覆蓋上面設置的樣式 */ //name列的頭背景設置成粉紅 IndexedColors.PINK.getIndex() @HeadStyle(fillPatternType = FillPatternTypeEnum.SOLID_FOREGROUND, fillForegroundColor = 14) private String name; private Double price; @DateTimeFormat("yyyy-MM-dd HH:mm:ss") private Date createDate; } ``` **2. 寫入數據** ```java @Test public void write01() { List<Computer> dataList = Lists.newArrayList(); Computer computer01 = new Computer("電腦01", 8999.0, new Date()); Computer computer02= new Computer("電腦02", 9000.0, new Date()); dataList.add(computer01); dataList.add(computer02); EasyExcel.write("e:/upload/easyexcel/002.xlsx", Computer.class).sheet("Sheet1").doWrite(dataList); } ``` **** 更多用法參考官方文檔：https://easyexcel.opensource.alibaba.com/docs/current/quickstart/write