jxls2在springboot中通过HttpServletResponse导出excel文件乱码

Question

各位好，本人尝试采用Jxls2通过spring mvc方式导出并下载Excel文件，文件能下载，但是下载下来的文件提示文件已损坏，点击进去出现内容乱码。但是尝试

OutputStream os = new FileOutputStream(new File("D:"+File.separator+"test111.xls"));

是能正常导出excel数据的，不知是否有人遇到过同样的问题，代码如下

package com.example.demo;

import org.jxls.common.Context;
import org.jxls.util.JxlsHelper;
import org.springframework.web.servlet.view.AbstractView;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.net.URLEncoder;
import java.util.Map;

public class JxlsExcelView extends AbstractView {
    private static final String CONTENT_TYPE = "application/vnd.ms-excel";

    private String templatePath;
    private String exportFileName;

    /**
     * @param templatePath   模版相对于当前classpath路径
     * @param exportFileName 导出文件名
     */
    public JxlsExcelView(String templatePath, String exportFileName) {
        this.templatePath = templatePath;
        if (exportFileName != null) {
            try {
                exportFileName = URLEncoder.encode(exportFileName, "UTF-8");
            } catch (UnsupportedEncodingException e) {
                e.printStackTrace();
            }
        }
        this.exportFileName = exportFileName;
        setContentType(CONTENT_TYPE);
    }

    @Override
    protected void renderMergedOutputModel(
            Map<String, Object> model,
            HttpServletRequest request,
            HttpServletResponse response) throws Exception {
        Context context = new Context(model);
        response.setContentType(getContentType());
        response.setHeader("content-disposition",
                "attachment;filename=" + exportFileName + ".xls");
        ServletOutputStream os = response.getOutputStream();
        //OutputStream os = new FileOutputStream(new File("D:"+File.separator+"test111.xls"));
        InputStream is = getClass().getClassLoader().getResourceAsStream(templatePath);
        JxlsHelper.getInstance().processTemplate(is, os, context);
        is.close();
    }
}

链接为测试代码源码

http://p59his853.bkt.clouddn.com/demo.zip

项目跑起来后打开http://localhost:8080/swagger-ui.html，点击接口try it out即可测试

Answer 1

楼主解决了吗 我的也是这个问题 呜呜呜

Answer 2

看看你的target里面的excel是否能打开,因为maven在你编译的 时候可能会把你的那个excle格式弄乱了.在maven的build里面加上类似于以下的代码

<resources>
	<resource>
		<directory>src/main/resources</directory>
		<filtering>true</filtering>
		<excludes>
			<exclude>**/*.xlsx</exclude>
		</excludes>
	</resource>
	<resource>
		<directory>src/main/resources</directory>
		<filtering>false</filtering>
		<includes>
			<include>**/*.xlsx</include>
		</includes>
	</resource>
</resources>

然后再去试试