Java表格下载

今天药忘吃喽~ 2023-10-02 14:41 4阅读 0赞

非常好用的表格下载

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5q-P5aSp6L-b5q2l5LiA54K554K577yM5byA5b-D5bCx5Lya5aSa5LiA54K5_size_20_color_FFFFFF_t_70_g_se_x_16]

首先加入依赖包到pom文件

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>easyexcel</artifactId>
                <version>2.1.6</version>        
     </dependency>

AutomaticNegationRes是接口响应的返回类

import io.swagger.annotations.ApiModel;
    import io.swagger.annotations.ApiModelProperty;
    import lombok.AllArgsConstructor;
    import lombok.Data;
    import lombok.NoArgsConstructor;
    import java.io.Serializable;
    
    @Data
    @AllArgsConstructor
    @NoArgsConstructor
    @ApiModel
    public class AutomaticNegationRes implements Serializable {
        
        @ApiModelProperty(notes = "主键id")
        private Long id;
    
        @ApiModelProperty(notes = "关键词id")
        private String keywordId;
    
        @ApiModelProperty(notes = "渠道")
        private String platform;
    
        @ApiModelProperty(notes = "账号")
        private String account;
    
        @ApiModelProperty(notes = "计划")
        private String plan;
    
        @ApiModelProperty(notes = "单元")
        private String unit;
    
        @ApiModelProperty(notes = "关键词")
        private String keyword;
    
        @ApiModelProperty(notes = "账面商机成本")
        private Double cost;
    
        @ApiModelProperty(notes = "日账面消费")
        private Double consume;
    
        @ApiModelProperty(notes = "商机数")
        private Integer business;
    
    
    
    }

KeywordResExcel是要下载的Excel的下载模板

import com.alibaba.excel.annotation.ExcelProperty;
    import io.swagger.annotations.ApiModel;
    import io.swagger.annotations.ApiModelProperty;
    import lombok.Data;
    
    @Data
    @ApiModel("关键字对象实体")
    public class KeywordResExcel {
        
    
    
        @ExcelProperty("渠道")
        @ApiModelProperty(notes = "渠道")
        private String platform;
    
        @ExcelProperty("账户")
        @ApiModelProperty(notes = "账户")
        private String account;
    
        @ExcelProperty("推广计划")
        @ApiModelProperty(notes = "推广计划")
        private String plan;
    
        @ExcelProperty("推广单元")
        @ApiModelProperty(notes = "推广单元")
        private String unit;
    
        @ExcelProperty("关键词")
        @ApiModelProperty(notes = "关键词")
        private String keyword;
    
        @ExcelProperty("账面商机成本")
        @ApiModelProperty(notes = "账面商机成本")
        private Double cost;
    
        @ExcelProperty("日账面消费")
        @ApiModelProperty(notes = "日账面消费")
        private Double consume;
    
        @ExcelProperty("商机数")
        @ApiModelProperty(notes = "商机数")
        private Integer business;
    }

在serviceImpl里写实现方法

@Override
        public RestfulResult downKeyword(List<String> ids, HttpServletResponse response) {
        
            List<AutomaticNegationRes> list = automaticNegationMapper.getByIds(ids);
            List<KeywordResExcel> excelList = new ArrayList<>();
            if (CollectionUtils.isNotEmpty(list)) {
        
                for (AutomaticNegationRes channelRevenuePo : list) {
        
                    KeywordResExcel keywordResExcel = new KeywordResExcel();
                    BeanUtils.copyProperties(channelRevenuePo, keywordResExcel);
                    excelList.add(keywordResExcel);
                }
            }
            String targetFilePath = String.valueOf(System.currentTimeMillis()).concat(".xlsx");
            response.setHeader("Content-Disposition", "attachment;filename=" + targetFilePath);
            try {
        
                EasyExcel.write(response.getOutputStream(), KeywordResExcel.class).sheet("关键词数据集合").doWrite(excelList);
            } catch (IOException e) {
        
                log.error("下载异常，{}",e.getMessage());
                return RestfulResult.failure(ResCode.KEYWORD_DATA_DOWNLOAD_EXCEPTION);
            }
            return RestfulResult.success();
        }

在controller中调用下载方法

/**
         * 下载导出选中的关键词集合
         *
         * @return 导出选中的关键词excel
         */
        @ApiOperation(value = "导出选中的关键词", notes = "导出选中的关键词")
        @GetMapping("/datas/download")
        public RestfulResult downKeyword(@RequestParam("ids")List<String> ids,  HttpServletResponse response) {
        
            return automaticNegationService.downKeyword(ids, response);
    
        }

excel导出功能就完成了，就是这么好用

![在这里插入图片描述][watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5q-P5aSp6L-b5q2l5LiA54K554K577yM5byA5b-D5bCx5Lya5aSa5LiA54K5_size_7_color_FFFFFF_t_70_g_se_x_16]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5q-P5aSp6L-b5q2l5LiA54K554K577yM5byA5b-D5bCx5Lya5aSa5LiA54K5_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/768c0aa25e634e1e8ce97b41fbb2be5f.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBA5q-P5aSp6L-b5q2l5LiA54K554K577yM5byA5b-D5bCx5Lya5aSa5LiA54K5,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA5q-P5aSp6L-b5q2l5LiA54K554K577yM5byA5b-D5bCx5Lya5aSa5LiA54K5_size_7_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/63f2c394b3ca4759b8d406b87c453d4f.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5q-P5aSp6L-b5q2l5LiA54K554K577yM5byA5b-D5bCx5Lya5aSa5LiA54K5,size_7,color_FFFFFF,t_70,g_se,x_16