excel文件下载下来损坏 js_使用Java / javascript和apache POI导出.xls文件时获取损坏的文件...

我正在尝试从Web应用程序下载浏览器中的.xls文件。下面是相同的代码。

try(FileInputStream inputStream = new FileInputStream("C:\\Users\\Desktop\\Book1.xls")){

response.setContentType("application/vnd.ms-excel");

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

response.setHeader("Content-Disposition", "attachment; filename=Book1.xls");

outputStream = response.getOutputStream();

byte[] buffer = new byte[BUFFERSIZE];

int bytesRead = -1;

while ((bytesRead = inputStream.read(buffer)) != -1) {

outputStream.write(buffer, 0, bytesRead);

}

}

以下是用于下载文件内容的JavaScript代码。

success: function(response, status, xhr) {

let type = xhr.getResponseHeader('Content-Type');

let blob = new Blob([response], { type: type });

if (typeof window.navigator.msSaveBlob !== 'undefined') {

// IE workaround for "HTML7007: One or more blob URLs were revoked by closing the blob for which they were created.

//These URLs will no longer resolve as the data backing the URL has been freed."

window.navigator.msSaveBlob(blob, filename);

} else {

let URL = window.URL || window.webkitURL;

let downloadUrl = URL.createObjectURL(blob);

if (filename) {

// use HTML5 a[download] attribute to specify filename

let a = document.createElement("a");

// safari doesn't support this yet

if (typeof a.download === 'undefined') {

window.location = downloadUrl;

} else {

a.href = downloadUrl;

a.download = filename;

document.body.appendChild(a);

a.click();

}

} else {

window.location = downloadUrl;

}

setTimeout(function () {

URL.revokeObjectURL(downloadUrl);

}, 100); // cleanup

}

}

我可以下载文件，但是下载的文件内容不是可读格式。如果它是csv文件，则我可以在我的javascript响应对象中看到内容，至于.xls文件，javascript响应对象包含无法读取的格式化数据。

有人可以帮我吗？