SpringMVC导出Excel IE8不支持

SpringMVC导出Excel IE8不支持

上一篇文章介绍了一下怎么通过返回ResponseEntity<byte[]>的方式进行导出文件，虽然感觉没有大问题，但是到了IE这个伙计，真的是醉了，好好的文件生成了，不能下载，说找不到站点。

找不到站点，我以为是我IE8权限设置的有问题，改了一通，没用。后来有个哥们的博客上这样写道：

果断把代码改成通过HttpServletResponse 返回输出流的方式。下面是代码：

package enht.soft.newhotelstn.controller;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellReference;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import javax.servlet.http.HttpServletResponse;
import java.io.*;

/**
 * Created by Administrator on 2016-09-02.
 */
@Controller
@RequestMapping(value = "/downloadFile", method = {RequestMethod.GET, RequestMethod.POST})
public class FileDownLoad {
    @RequestMapping("download")
    public void download(HttpServletResponse res,String filename,String ExcelData) throws IOException {
        if(filename==null || filename.equals("")){
            return;
        }
        OutputStream out = res.getOutputStream();
        System.out.println(ExcelData);
        res.reset();
        res.setHeader("Content-Disposition", "attachment; filename=" + filename + ".xls");
        res.setContentType("application/octet-stream; charset=utf-8");
        Workbook wb = new HSSFWorkbook();
        Sheet sh = wb.createSheet();
        for (int rownum = 0; rownum < 50; rownum++) {
            Row row = sh.createRow(rownum);
            for (int cellnum = 0; cellnum < 30; cellnum++) {
                Cell cell = row.createCell(cellnum);
                CellReference cr = new CellReference(cell);
                String address = cr.formatAsString();
                cell.setCellValue(address + "row:" + cr.getRow() +" col:" +cr.getRow());
            }
        }
        try {
            wb.write(out);
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        out.flush();
        try {
            out.close();
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}

运行结果：

总结一下，虽然是进行了侵入式的编程，但是木有办法哈。