Export excel file 0KB on production environment, but OK on local machine

Viewed 90

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);
    }
}
0 Answers
Related