引入依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>1.1.2-beta5</version>
</dependency>
写一个样式类实现Easy-Excel写回调
public class ExcelBuilder {
/** EasyExcel Writer */
private ExcelWriter writer;
/** 保存每个sheet的头数据 */
private Map<Integer, List<List<String>>> headMap = new ConcurrentHashMap<>(2);
/** 保存每个Sheet的内容数据 */
private Map<Integer, List<List<Object>>> bodyMap = new ConcurrentHashMap<>(2);
/** Sheet索引 */
private int sheetIndex = 0;
/**
* 创建一个ExcelBuilder对象
*
* @param os 输出流
* @return ExcelBuilder
*/
public ExcelBuilder create(OutputStream os) {
writer =
EasyExcelFactory.getWriterWithTempAndHandler(
null,
os,
ExcelTypeEnum.XLS,
tr