EasyExcel导出(模板模式)

private void export(HttpServletResponse response, List<? extends Object> data, String fileName, Class clazz, String template){
  ServletOutPutStream out = null;
  InputStream in = null;
  try {     fileName = URLEncoder.encode(fileName, "utf-8");     response.addHeader("Content-Disposition", "attachment;filename=" + fileName);     response.setContentType("application/vnd.ms-excel;charset=utf-8");     Resource resource = new ClassPathResource(template);   out = response.getOutputStream(); in = resource.getInputStream();   } catch(Exception e){     log.info("导出失败:{}", e);     throw new Exception();   } finally {     if(ObjectUtil.isNotNull(out)){       try {         out.close();       } catch (IOException e){         log.info("OutputStream关闭失败:{}", e);       }     }     if(ObjectUtil.isNotNull(in)){       try{         in.close();       } catch (IOException e){         log.info("InputStream关闭失败:{}", e);       }   } }

 

posted @ 2023-03-03 10:05  疯靡  阅读(553)  评论(0)    收藏  举报