public String sendExcl(SXSSFWorkbook wb, HttpServletResponse response, String mes, HttpServletRequest request) { try { String fileName = mes; response.reset(); OutputStream fos = response.getOutputStream(); String userAgent = request.getHeader("USER-AGENT"); if (StringUtils.contains(userAgent, "Mozilla")) { fileName = new String(fileName.getBytes(), "ISO8859-1"); } else { fileName = URLEncoder.encode(fileName, "utf8"); } response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx"); wb.write(fos); wb.dispose(); fos.close(); } catch (Exception ex) { logger.error(mes, ex); return "导出失败"; } return null; } 导出使用
