Util工具类 提供下载转码中文名称的excel

/** * 转码以提供中文名文件下载支持 * * @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);        }    }}