easyExcel多sheet页Excel文件导出

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;
}

---