操作excel 表格对单元格赋值后,把表格用文件流的形式给前端,导出用office的产品打卡会报此异常,导致这方面的问题会有很多,话不多说上代码
FileInputStream fileInputStream = new FileInputStream(path);
ServletOutputStream outputStream = response.getOutputStream();
response.setContentType("application/x-download;charset=utf-8");
response.addHeader("Content-Disposition",
"attachment;filename=" + URLEncoder.encode(FileName, "UTF-8"));
byte[] bytes = new byte[1024 * 2];
while ((fileInputStream.read(bytes) != -1)) {
outputStream.write(bytes);
}
经过一系列的研究探讨找到问题所在 原来的byte[] 数组给的大小是固定格式,导致文件过大或者过小会产生影响,换成 流的可用空间大小 可解决
if(reportFile.exists()) {
FileInputStream fis = null;
try {
fis = new FileInputStream(reportFile);
String filename = "报表文件.xlsx"; //解决中文文件名下载后乱码的问题
//filename = URLEncoder.encode(f.getName(),"utf-8");
byte[] b = new byte[fis.available()];
fis.read(b);
response.setCharacterEncoding("utf-8");
response.setHeader("Content-Disposition", "attachment; filename=" + filename + "");
//获取响应报文输出流对象
ServletOutputStream outputStream = response.getOutputStream();
//输出
outputStream.write(b);
outputStream.flush();
outputStream.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
再次导出问题解决,希望能给大伙带来帮助,提前祝大伙,五一快乐,拒绝内卷!