后端下载excle文件HttpMediaTypeNotAcceptableException报错处理

本文链接：https://blog.youkuaiyun.com/weixin_45460120/article/details/109613017

本文介绍了解决文件下载时出现的HttpMediaTypeNotAcceptableException错误的方法，主要原因是Content-Type与Accept字段不匹配。通过设置response的ContentType为application/vnd.ms-excel;charset=UTF-8，可以成功下载Excel文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错原因

HttpMediaTypeNotAcceptableException: Could not find acceptable representation

后台返回的响应报头[Response Headers]的Content-Type与前端的请求报头[Request Headers]中的Accept字段不匹配

查看Content-Type与Accept

浏览器F12查看
在这里插入图片描述

代码配置后端Content-Type

只要设置下response的ContentType即可
下载excle文件把Content-Type设置为

application/vnd.ms-excel;charset=UTF-8

或者

application/octet-stream;charset=UTF-8

response.setContentType("application/vnd.ms-excel;charset=UTF-8");
response.setHeader("Content-Disposition", "attachment;filename=" + URLUtil.encode(settingImportVO.getFileName()));

完整例子

@ApiOperation(value = "导入下载", produces="application/json")
    @PostMapping(value = "/downLoadImport")
    public void downLoadImport(@RequestParam(value = "id" ) Integer id, HttpServletResponse response) throws Exception{
        grossProfitImportService.downLoadImport(id,response);
    }

@Override
    public void downLoadImport(Integer id, HttpServletResponse response) throws Exception {
        SettingImportVO settingImportVO = grossProfitImportMapper.selectReportDownloadById(id);
        response.setContentType("application/vnd.ms-excel;charset=UTF-8");
        response.setHeader("Content-Disposition", "attachment;filename=" + URLUtil.encode(settingImportVO.getFileName()));
        fileService.load(settingImportVO.getFilePath(), response.getOutputStream());
    }