excel下载前后端代码，防下载中文乱码

信念之力λ-drive

已于 2022-04-11 15:55:21 修改

阅读量895

点赞数

分类专栏： Java web 文章标签：后端前端 js

于 2021-11-23 12:06:42 首次发布

本文链接：https://blog.csdn.net/weixin_48860638/article/details/121490259

版权

Java 同时被 2 个专栏收录

63 篇文章 0 订阅

订阅专栏

web

43 篇文章 0 订阅

订阅专栏

前端按钮chick()事件js模仿a标签点击

function dakai(){
	window.open('localhost:8080/project/excelDown');
}

后端

/**
 * 下载excel
 * @param response
 * @param dr 参数对象
 */
@RequestMapping(value = "/excelDown", method = RequestMethod.GET, produces = "application/json;charset=utf-8")
public void createExcelToDisk(HttpServletResponse response,DetailReportQuery dr) {
    try {
        response.reset(); // 清除buffer缓存
        // 文件名
        String fname = "未命名";
        String houzui = ".xlsx";
        // 要下载的excel对象
        XSSFWorkbook workbook = null;
        switch (dr.getId()){
            case 1:
                fname = "屋明细账"+System.currentTimeMillis()+houzui;
                workbook = detailReportService.excelExportStoried(dr);
                break;
            case 2:
                fname = "物明细账"+System.currentTimeMillis()+houzui;
                workbook = detailReportService.excelExportStructure(dr);
                break;
            case 3:
                fname = "地明细账"+System.currentTimeMillis()+houzui;
                workbook = detailReportService.excelExportGround(dr);
                break;
            case 4:
                break;
            case 5:
                break;
            case 6:
                break;
            case 7:
                break;
        }

        // 设置前端响应
        response.setHeader("Content-Disposition", "attachment;filename=" + new String(fname.getBytes("gb2312"), "ISO8859-1")); // 防止文件名乱码
        response.setContentType("application/vnd.ms-excel;charset=UTF-8");
        response.setHeader("Pragma", "no-cache");
        response.setHeader("Cache-Control", "no-cache");
        response.setDateHeader("Expires", 0);

        OutputStream output = response.getOutputStream();
        BufferedOutputStream bufferedOutPut = new BufferedOutputStream(output);
        bufferedOutPut.flush();
        workbook.write(bufferedOutPut);
        bufferedOutPut.close();
    }catch (Exception e){
        e.getMessage();
    }
}

防止乱码2

response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("utf-8");
// 这里URLEncoder.encode可以防止中文乱码 当然和easyexcel没有关系
String fileName = URLEncoder.encode("自动统计导出", "UTF-8")
        .replaceAll("\\+", "%20");
response.setHeader("Content-disposition", "attachment;filename*=utf-8''" +
        fileName + ".xlsx");