I'm using springboot2 + easypoi to export data to excel.
Everything is ok on my dev machine: open http://127.0.0.1:8080/tongji ,the excel file is ok.
But after deploy on production environment:nginx+tomcat+war file, open https://xxx/tongji ,the file is OKB.
@GetMapping("/tongji")
public void export(HttpServletResponse response) throws UnsupportedEncodingException {
try {
//generate data
List<UserTongjiVO> list = tongji();
ExportParams exportParams = new ExportParams();
exportParams.setType(ExcelType.HSSF);
exportParams.setSheetName("sheet");
Workbook workbook = ExcelExportUtil.exportExcel(exportParams, UserTongjiVO.class, list);
response.setCharacterEncoding("UTF-8");
response.setContentType("application/octet-stream");
response.setHeader("Content-Disposition",
"attachment;filename=" + URLEncoder
.encode("" + DateTime.now().toString("yyyyMMdd_HHmm")
+ ".xls", "utf-8"));
// response.setHeader("content-Type", "application/vnd.ms-excel");
response.flushBuffer();
workbook.write(response.getOutputStream());
response.getOutputStream().close();
} catch (Exception e) {
log.error("error");
log.error(e.getMessage(), e);
}
}