easyPoi处理文件下载文件名为空问题----请求头信息

傷城~ 2022-05-16 12:56 130阅读 0赞

导包:[同上一篇导出封装请求参数][Link 1]

定义注解:

import cn.afterturn.easypoi.excel.entity.enmus.ExcelType;
    
    import java.lang.annotation.*;
    
    /**
     * 导出Excel注解.
     */
    @Documented
    @Retention(RetentionPolicy.RUNTIME)
    @Target(ElementType.METHOD)
    public @interface ExportExcel {
    
        // 导出文件名.
        String fileName();
    
        // Excel类型.默认03、07格式.
        ExcelType excelType() default ExcelType.HSSF;
    }

定义切面方法:匹配注解进行切面环绕设置请求头信息

import cn.afterturn.easypoi.excel.entity.enmus.ExcelType;
    import com.ahies.system.sso.annotation.ExportExcel;
    import org.apache.commons.lang3.StringUtils;
    import org.aspectj.lang.ProceedingJoinPoint;
    import org.aspectj.lang.annotation.Around;
    import org.aspectj.lang.annotation.Aspect;
    import org.springframework.core.annotation.Order;
    import org.springframework.stereotype.Component;
    import org.springframework.web.context.request.RequestContextHolder;
    import org.springframework.web.context.request.ServletRequestAttributes;
    
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    import java.net.URLEncoder;
    
    /**
     * 导出Excel切面.
     *
     * @author Hohn
     */
    @Aspect
    @Order
    @Component
    public class ExcelExportAspect {
    
       @Around(value = "@annotation(excel)")
       public Object processTx(ProceedingJoinPoint joinPoint, ExportExcel excel)
             throws Throwable {
          Object[] args = joinPoint.getArgs();
          // Http请求.
          HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
          // Http响应.
          HttpServletResponse response = null;
          // 最终的文件名(处理中文兼容问题).
          String finalFileName = excel.fileName();
          // 文件后缀名.
          String suffix = excel.excelType().equals(ExcelType.HSSF) ? ".xls" : ".xlsx";
          for (int i = 0; i < args.length; i++) {
             final String userAgent = request.getHeader("USER-AGENT");
             // IE浏览器(IE11特殊处理).
             if (StringUtils.contains(userAgent, "MSIE") || StringUtils.contains(userAgent, "rv:11")) {
                finalFileName = URLEncoder.encode(excel.fileName(), "UTF8");
             }
             // Google,火狐浏览器
             else if (StringUtils.contains(userAgent, "Mozilla")) {
                finalFileName = new String(excel.fileName().getBytes(), "ISO8859-1");
             }
             // 其他浏览器.
             else {
                finalFileName = URLEncoder.encode(excel.fileName(), "UTF8");
             }
             if (args[i] instanceof HttpServletResponse) {
                response = (HttpServletResponse) args[i];
                // 告诉浏览器用什么软件可以打开此文件.
                response.setHeader("content-Type", "application/vnd.ms-excel");
                // 下载文件的默认名称.
                response.setHeader("Content-Disposition", "attachment;filename=" + finalFileName + suffix);
                // 编码.
                response.setCharacterEncoding("UTF-8");
             }
          }
          Object result = null;
          try {
             result = joinPoint.proceed();
          } catch (Throwable e) {
             e.printStackTrace();
          }
          return result;
       }
    }

[Link 1]: https://blog.csdn.net/s573626822/article/details/81903427