SpringBoot之下载Excel

我就是我 2022-02-25 18:58 287阅读 0赞

下载下来的Excel报如下错误

![20190402150147714.png][]

![20190402150230667.png][]

错误内容: Excel 已完成文件级验证和修复。此工作簿的某些部分可能已被修复或丢弃。

解决方案:

核心代码:

//加上设置大小下载下来的.xlsx文件打开时才不会报“Excel 已完成文件级验证和修复。此工作簿的某些部分可能已被修复或丢弃”
    res.addHeader("Content-Length", String.valueOf(excelFile.length()));

完整代码:

public Result downloadFile(HttpServletResponse res) {
    	String realFileName="example.xlsx";
    	File excelFile = new File(exampleFilePath);
    	res.setCharacterEncoding("UTF-8");
            res.setHeader("content-type", "application/octet-stream;charset=UTF-8");
            res.setContentType("application/octet-stream;charset=UTF-8");
            //加上设置大小下载下来的.xlsx文件打开时才不会报“Excel 已完成文件级验证和修复。此工作簿的某些部分可能已被修复或丢弃”
            res.addHeader("Content-Length", String.valueOf(excelFile.length()));
            try {
    			res.setHeader("Content-Disposition", "attachment;filename=" + java.net.URLEncoder.encode(realFileName.trim(), "UTF-8"));
            } catch (UnsupportedEncodingException e1) {
    			e1.printStackTrace();
    		}
    		byte[] buff = new byte[1024];
            BufferedInputStream bis = null;
            OutputStream os = null;
            try {
              os = res.getOutputStream();
              bis = new BufferedInputStream(new FileInputStream(new File(exampleFilePath)));
              int i = bis.read(buff);
              while (i != -1) {
                os.write(buff, 0, buff.length);
                os.flush();
                i = bis.read(buff);
              }
            } catch (IOException e) {
              e.printStackTrace();
            } finally {
              if (bis != null) {
                try {
                  bis.close();
                } catch (IOException e) {
                  log.error("【下载模板】{}",e);
                }
              }
            }
            log.info("【下载模板】成功,exampleFilePath={}",exampleFilePath);
            return ResultUtils.success();
    	}

[20190402150147714.png]: /images/20220225/a4d74dc2227143d0860fc6dfdb787434.png
[20190402150230667.png]: /images/20220225/b5eb31429cc94adab0fba66ef253fa2e.png