poi导出excel 损坏_XSSFSheet 创建excel文件导出提示文件存在部分问题需要修复问题解决...

@GetMapping("finance/exportExcel")

@ResponseBody

public ResultJson exportExcel(ReviewIExcelReq req, HttpServletResponse response) {

try {

byte[] file=financeReviewService.exportExcel(

req.getTeamId(),

req.getReviewStatus(),

req.getUserName(),

req.getClientName(),

req.getPaymentTimeStart(),

req.getPaymentTimeEnd()

);

String fileName = new String(("复核收款记录-"+DateUtil.formatDate(new Date(),"yyyyMMddhhmmss")+".xlsx").getBytes("gb2312"), "ISO8859-1");

response.setCharacterEncoding("UTF-8");

response.setContentType("multipart/form-data;charset=UTF-8");

response.setHeader("Content-Disposition", "attachment;fileName=\"" + fileName + "\"");

//解决Excel打开文件提示：xxx文件中部分内容有问题。是否让我们尽量尝试恢复

ByteArrayInputStream tempIn = new ByteArrayInputStream(file);

response.setHeader("Content-Length", String.valueOf(tempIn.available()));

OutputStream os=response.getOutputStream();

os.write(file);

os.flush();

return ResultJson.success("success");

} catch (Exception e) {

return ResultJson.fail(e.getMessage());

}

}