EasyExcel单行或多行表头的简单Excel导出

一般Excel不需要复杂的数据格式导出，只是在表头上略有区别，下面展示单行和多行表头Excel导出

1、单行表头

例如：Excel表头只有单行，那就只需要使用注解@ExcelProperty即可实现

① 添加依赖

首先，在 pom.xml 中添加 EasyExcel 的依赖：

 <!-- EasyExcel 依赖 -->
<dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>3.3.3</version>
</dependency>

② 定义数据模型

在数据模型 EnergyTimeDetailVO需要导出的字段上添加注解信息@ExcelProperty

@Data
public class EnergyTimeDetailVO {@ApiModelProperty("时间")@ExcelProperty(value = "时间", index = 0)private String time;@ApiModelProperty("起始读数")@ExcelProperty(value = "起始读数", index = 1)private BigDecimal startRead;@ApiModelProperty("终止读数")@ExcelProperty(value = "终止读数", index = 2)private BigDecimal endRead;@ApiModelProperty("总用量")@ExcelProperty(value = "总用量", index = 3)private BigDecimal usage;
}

 ③ 编写导出逻辑

public class EasyExcelUtils {public static void downloadExcel(String fileName, String sheetName, Class clz, List list, HttpServletResponse response) throws IOException {response.setContentType("application/vnd.ms-excel");response.setCharacterEncoding("utf-8");fileName = URLEncoder.encode(fileName, "UTF-8");response.setHeader("Content-disposition", "attachment;filename=" + fileName + ";" + "filename*=utf-8''" + fileName + ".xlsx");EasyExcel.write(response.getOutputStream(), clz).sheet(sheetName).registerWriteHandler(new CustomCellWriteWidthStrategy()) /*自适应列宽*/.registerWriteHandler(new CustomCellWriteHeightStrategy()) /*自适应行高*/.doWrite(list);}
}

自适应列宽CustomCellWriteWidthStrategy类和自适应行高CustomCellWriteHeightStrategy类，在这篇文章中：Java使用EasyExcel自定义合并（横纵合并）、自定义行高列宽、自适应行高列宽工具、自定义样式Excel导出_easyexcel 横向合并-CSDN博客

④ Excel导出

public void exportEnergyDetail(UseEnergyComparedMeterDTO param, HttpServletResponse response) {String fileName = "用能明细" + DateUtil.format(new Date(), DatePattern.PURE_DATE_FORMAT);try {List<EnergyTimeDetailVO> detailList = this.energyComparedDetail(param);EasyExcelUtils.downloadExcel(fileName, "数据明细", EnergyTimeDetailVO.class, detailList, response);} catch (Exception e) {log.error("用能明细:{}", e.getMessage());}}

⑤ 效果展示：

2、多行表头

如果数据标头为多行，如下方：

 就只需要要修改导出的类EnergyTimeDetailVO上的注解信息@ExcelProperty：

@Data
public class EnergyTimeDetailVO {@ApiModelProperty("时间")@ExcelProperty(value = "时间", index = 0)private String time;@ApiModelProperty("起始读数")@ExcelProperty(value = {"读数", "起始读数"}, index = 1)private BigDecimal startRead;@ApiModelProperty("终止读数")@ExcelProperty(value = {"读数", "终止读数"}, index = 2)private BigDecimal endRead;@ApiModelProperty("总用量")@ExcelProperty(value = "总用量", index = 3)private BigDecimal usage;
}

其他代码不变，撒花✿✿ヽ(°▽°)ノ✿，完结……

如果是动态表头，就是非固定表头的Excel可以参照这篇文章：

Java使用EasyExcel生成动态表头和多Sheet数据的Excel_easyexcel 动态表头和动态数据-CSDN博客