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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值