SpringMVC下高效Excel下载与命名解决方案

 @RequestMapping(value = "dzd", method = {RequestMethod.GET, RequestMethod.POST})
    public void t1Statements(HttpServletRequest request, HttpServletResponse response,MinShengSettleInDto) throws WriteException, IOException {
               try {
            String downlaodFilename = "文件名称.xls"
            HttpHeaders headers = new HttpHeaders();
            headers.setContentDispositionFormData("attachment", downlaodFilename);
            headers.setContentType(MediaType.APPLICATION_OCTET_STREAM);
            response.setHeader("Content-Disposition", "attachment;fileName=" + downlaodFilename);
            request.setCharacterEncoding("utf-8");
            response.setCharacterEncoding("utf-8");
            response.setContentType("application/vnd.ms-excel");
//此处获取将要处理的数据 我用的数组
//你可以用任意类型集合来处理，需要改变的是oneExcel内的数据处理
            String[] vals = minShengService.findT1Dzd(null,serialNo);
            String name="合作方标识,户入驻返回的商户编号,状态,响应码,响应描述,对账类型";//逗号分割每一列的名称
            Workbook workbook = ExcelUtil.oneExcel(vals,name);
            workbook.write(out);
            out.flush();
            logger.info(“”）;
        }catch (Exception e){
            logger.error("系统异常",e);
        }finally {
            out.close();
        }
    }



public class ExcelUtil {
    public static Workbook oneExcel(String[] val, String name) throws WriteException, IOException {