easyExcel多sheet页Excel文件导出
引入jar包
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>easyexcel</artifactId>
<version>2.2.6</version>
</dependency>
数据填充
//模板地址
String templatePath = "templates/enclosure.xlsx";
InputStream resourceAsStream = this.getClass().getClassLoader().getResourceAsStream(templatePath);
ExcelWriter excelWriter = EasyExcel.write(ExcelUtils.getOutputStream("附件一", response)).withTemplate(resourceAsStream).build();
//sheet0数据填充
WriteSheet writeSheet0 = EasyExcel.writerSheet(0).build();
List<FarmerCattleVo> cattleList = service.exportCattleExcel(desktopParam);
if(cattleList.size() > 0 && StringUtils.isNotBlank(cattleList.get(0).getAreaName())){
excelWriter.write(cattleList,writeSheet0);
}else{
excelWriter.write(Lists.newArrayList(),writeSheet0);
}
//sheet1数据填充
WriteSheet writeSheet1 = EasyExcel.writerSheet(1).build();
List<FarmerCattleVo> sheepList = service.exportSheepExcel(desktopParam);
if(sheepList.size() > 0 && StringUtils.isNotBlank(sheepList.get(0).getAreaName())){
excelWriter.write(sheepList, writeSheet1);
}else{
excelWriter.write(Lists.newArrayList(), writeSheet1);
}
//sheet2数据填充
WriteSheet writeSheet2 = EasyExcel.writerSheet(2).build();
List<FarmerCattleVo> pigList = service.exportPigExcel(desktopParam);
if(pigList.size() > 0 && StringUtils.isNotBlank(pigList.get(0).getAreaName())){
excelWriter.write(pigList, writeSheet2);
}else{
excelWriter.write(Lists.newArrayList(), writeSheet2);
}
//sheet3数据填充
WriteSheet writeSheet3 = EasyExcel.writerSheet(3).build();
List<FarmerCattleVo> birdsList = service.exportPigExcel(desktopParam);
if(birdsList.size() > 0 && StringUtils.isNotBlank(birdsList.get(0).getAreaName())){
excelWriter.write(birdsList, writeSheet3);
}else{
excelWriter.write(Lists.newArrayList(), writeSheet3);
}
//关闭流
excelWriter.finish();
填充数据实体类
@Data
public class FarmerCattleVo {
private String cityName;
private String areaName;
private String farmerName;
private Integer cattleNumber;
}