ECR导出

whycxzp

2023-02-21 7dd86ef601222b2fe86d5bb63e26681a22c69dfd

ECR导出

 src/main/java/com/whyc/service/ECRService.java

@@ -282,6 +282,7 @@
            values[i][8] = ecr.getSolution();
            values[i][9] = DateUtil.YYYY_MM_DD_HH_MM_SS.format(ecr.getCreateTime());
        }
        ExcelUtil.exportExcel("变更记录清单","清单",title,values,null,response);
        String dateFormat = DateUtil.YYYY_MM_DD_HH_MM_SS.format(new Date());
        ExcelUtil.exportExcel("变更记录清单_"+dateFormat,"清单",title,values,null,response);
    }
}

 src/main/java/com/whyc/util/ExcelUtil.java

@@ -79,7 +79,7 @@
        }
        try {
            //response.setCharacterEncoding("UTF-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes()) + ".xls");
            response.setHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"ISO8859-1") + ".xls");
            //不保存缓存信息与response.reset同样效果
            response.addHeader("Pragma", "no-cache");
            response.addHeader("Cache-Control", "no-cache");