java_0">一、java

1、添加依赖：

<dependency>
    <groupId>cn.hutool</groupId>
    <artifactId>hutool-all</artifactId>
    <version>5.8.16</version>
</dependency>

2、封装方法

java">word">import cn.hutool.core.io.IoUtil;
word">import cn.hutool.core.util.IdUtil;
word">import cn.hutool.poi.excel.BigExcelWriter;
word">import cn.hutool.poi.excel.ExcelUtil;

word">import javax.servlet.ServletOutputStream;
word">import javax.servlet.http.HttpServletResponse;
word">import java.io.File;
word">import java.io.IOException;
word">import java.util.List;
word">import java.util.Map;

word">public word">class ExcelUtils {
    /**
     * 导出excel
     */
    word">public word">static word">void downloadExcel(List<Map<String, Object>> list, HttpServletResponse response) word">throws IOException {
        String tempPath =System.getProperty("java.io.tmpdir") + IdUtil.fastSimpleUUID() + ".xlsx";
        File file = word">new File(tempPath);
        BigExcelWriter writer= ExcelUtil.getBigWriter(file);
        writer.write(list, true);
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
        //test.xls是弹出下载对话框的文件名，不能为中文，中文请自行编码
        response.setHeader("Content-Disposition","attachment;filename=file.xlsx");
        ServletOutputStream out=response.getOutputStream();
        // 终止后删除临时文件
        file.deleteOnExit();
        writer.flush(out, true);
        //关闭输出Servlet流
        IoUtil.close(out);
    }
}

2、接口

java">@PostMapping("/exportList")
word">public word">void exportListData(@RequestBody List<Map<String,Object>> list,HttpServletResponse response){
    word">try {
        ExcelUtils.downloadExcel(list, response);
    } word">catch (IOException e) {
        word">throw word">new RuntimeException(e);
    }
}

二、vue（代码块，仅参考）

1、前端API写法：

export function exportList(data) {
  return request({
    url: '/xxx/xxx/exportList/',
    method: 'post',
    responseType: "blob",
    data: data
  })
}

2、页面调用方法和导出文件

exportList(this.data).then(rsp => {
	  let blob = new Blob([rsp], {
	    type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
	  });
	  let url = window.URL.createObjectURL(blob);
	  window.location.href = url;
	  this.$message({
	    showClose: true,
	    message: "文件下载成功",
	    type: "success",
	  });
	});