excel文件下载下来损坏 js_java – React excel文件下载损坏

我试图通过调用

Spring REST端点在Reactjs中下载Excel文件,但我遇到了损坏文件的问题.

反应电话……

getFile(){

axios.get('get/download')

.then((response) => {

var blob = new Blob([response.data], {type:'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'});

filesaver.saveAs(blob, "excel.xlsx");

});

}

弹簧控制器……

@RequestMapping(value = "/download", method = RequestMethod.GET)

public void downloadExcelFile(final HttpServletResponse response) throws IOException {

response.setHeader("Content-Encoding", "UTF-8");

response.setHeader("Content-Disposition", "attachment; filename="file.xlsx");

response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");

final File xls = service.createExcelFile(response);

final FileInputStream in = new FileInputStream(xls);

final OutputStream out = response.getOutputStream();

final byte[] buffer = new byte[8192];

int length;

while ((length = in.read(buffer)) > 0) {

out.write(buffer, 0, length);

}

in.close();

out.close();

}

服务…

public File createExcelFile(final HttpServletResponse response) {

XSSFWorkbook xssfWorkbook = null;

final File xls = new File("excel.xlsx");

try {

final FileOutputStream fos = new FileOutputStream(xls);

xssfWorkbook = new XSSFWorkbook();

//setup excel file...

xssfWorkbook.write(fos);

xssfWorkbook.close();

}

catch (final Exception e) {

LOGGER.error(String.format("Something went wrong"));

}

return xls;

}

当我执行上面的代码时,我得到一个excel文件o.k …但是看看response.data看起来像……

"PKs��J_rels/.rels���j�0��}↵�{㴃1F�^Ơ�2��l%1I,c�[�

打开我得到的文件…由于数据不可读而无法打开文件.在服务器上打开文件是可以的

欢迎任何想法

干杯