java导出excel并实现下载功能

59 阅读 0 评论 39 点赞

我是靠谱客的博主无聊手机，最近开发中收集的这篇文章主要介绍java导出excel并实现下载功能，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

java导出excel并实现下载功能

这里我们使用alibaba的依赖包


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

entity
这里如果不希望某个字段显示，就在该字段上加上@ExcelIgnore注解

package com.infoearth.modules.survey.entity;
import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import java.io.Serializable;
import java.util.Date;
/**
* 实体类
*
* @author BladeX
* @since 2021-02-24
*/
@Data
@TableName("SURVEYJMRECORD")
//@EqualsAndHashCode(callSuper = true)
@ApiModel(value = "Surveyjmrecord对象", description = "机民井统测记录表")
@ColumnWidth(value = 13)
public class Surveyjmrecord implements Serializable {
private static final long serialVersionUID = 1L;
/**
* 主键
(机民井统测记录表)
*/
@ExcelIgnore
@ApiModelProperty(value = "主键
(机民井统测记录表)")
@TableId("ID")
private String id;
/**
* 统测点号,外键，与水文地质点调查表ID关联
*/
@ExcelIgnore
@ApiModelProperty(value = "统测点号,外键，与水文地质点调查表ID关联")
@TableField("POINTID")
private String pointid;
/**
* 野外编号
*/
@ExcelProperty(value = "野外编号")
@ApiModelProperty(value = "野外编号")
@TableField("GCEABC")
private String gceabc;
/**
* 统测期次
*/
@ExcelProperty(value = "统测期次")
@ApiModelProperty(value = "统测期次")
@TableField("OBSERVE_PERIOD")
private String observePeriod;
/**
* 测点高程
*/
@ExcelProperty(value = "测点高程")
@ApiModelProperty(value = "测点高程")
@TableField("MEAPOINTELEV")
private Float meapointelev;
/**
* 测点距地面高度
*/
@ExcelProperty(value = "测点距地面高度")
@ApiModelProperty(value = "测点距地面高度")
@TableField("MEAGROHEIGHT")
private Float meagroheight;
}

serviceimpl
我这里是多个sheet导出，如果小伙伴要单sheet就写一个就可以了

public String exportExcelByCode(String code) throws IOException {
//这里的path是上传的服务器地址+编码(为了区别)
String path = baseFilePath + code + "survey.xlsx";
FileOutputStream outputStream = new FileOutputStream(path);
//导出多个sheet,getjmList（code）是查出来List数据集合
ExcelWriter excelWriter = EasyExcel.write(outputStream).build();
excelWriter.write(getjmList(code),EasyExcel.writerSheet(0,"机民井统测记录表").head(Surveyjmrecord.class).build());
excelWriter.write(getqdList(code),EasyExcel.writerSheet(1,"泉点统测记录表").head(Surveysprrecord.class).build());
excelWriter.write(getAnhList(code),EasyExcel.writerSheet(2,"地下暗河统测记录表").head(Surveyriverrecord.class).build());
excelWriter.write(gethkList(code),EasyExcel.writerSheet(3,"湖库统测记录表").head(Surveylakeresrecord.class).build());
excelWriter.write(gethlList(code),EasyExcel.writerSheet(4,"河流统测记录表").head(Surveyrivernairerecord.class).build());
excelWriter.finish();
return path;
}

controller层下载

@GetMapping(value = "/exportExcel",produces = "application/octet-stream")
@ApiOperation(value = "导出",notes = "")
public void exportExcel(@RequestParam String code,HttpServletResponse response) throws IOException {
String path = basicinfoService.exportExcelByCode(code);
File file = new File(path);
String fileName = file.getName();
InputStream is = new BufferedInputStream(new FileInputStream(file));
byte[] bytes = new byte[is.available()];
is.read(bytes);
is.close();
//清空response
response.reset();
// 设置response的Header,设置浏览器
response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
response.addHeader("Content-Length", "" + file.length());
OutputStream toClient = new BufferedOutputStream(
response.getOutputStream());
response.setContentType("application/octet-stream");
toClient.write(bytes);
toClient.flush();
toClient.close();
}