@NoArgsConstructor
@AllArgsConstructor
@Data
@Builder
public class Title {@ExcelProperty(value = "字符串标题")private String stringTitle;@ExcelProperty(value = "日期标题")private Date dateTitle;@ExcelProperty(value = "数字标题")private String numTitle;@ExcelProperty(value = "英文标题")private String EnglishTitle; // 命名不规范
}
其他3个变量命名正确英文标题命名不正确
public class WriteToExcel {public static List<Title> getTitleData() {List<Title> titles = new ArrayList<>();for (int i = 0; i < 10; i++) {Title title = Title.builder().stringTitle("字符"+i).dateTitle(new Date()).numTitle("1" + i).EnglishTitle("Something"+i).build();titles.add(title);}return titles;}public static void main(String[] args) {System.out.println("开始创建Excel文件.....");String fileName = "title1.xlsx";String pathName = "D:\\";File file = new File(pathName + fileName);try {file.createNewFile();} catch (IOException e) {e.printStackTrace();}System.out.println("创建Excel文件成功");System.out.println("开始写入Excel.......");List<Title> titleData = getTitleData();for (int i = 0; i < titleData.size(); i++) {System.out.println(titleData.get(i));}EasyExcel.write(pathName + fileName, Title.class).sheet("标题").doWrite(titleData);System.out.println("Excel文件写入完成");}
}
结果如下:

