/** * 转码以提供中文名文件下载支持 * * @param fileName * @return */ public static String getAttachFileNameForCn(String fileName) { StringBuffer sb = new StringBuffer(); try { sb.append("filename=").append(URLEncoder.encode(fileName, "UTF-8")) .append(";filename*=UTF-8''").append(URLEncoder.encode(fileName, "UTF-8")); } catch (UnsupportedEncodingException e) { logger.error(e.getMessage(), e); } return sb.toString(); }/** * 下载XSSFWorkbook格式的excel * * @param name * @param book * @param response * @throws IOException */ public static void exportExcel(String name, XSSFWorkbook book, HttpServletResponse response) { response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-disposition", "attachment;" + Util.getAttachFileNameForCn(name)); OutputStream os = null; try { os = response.getOutputStream(); book.write(os); os.flush(); os.close(); } catch (IOException e) { throw new BaseRuntimeException("export excel error", e); } finally { try { if (os != null){ os.close(); } } catch (IOException e) { logger.error(e.getMessage(), e); } } }
Util工具类 提供下载转码中文名称的excel
最新推荐文章于 2024-07-28 09:45:40 发布