spring MVC 导出excel

1. // 导出excel方法  
2.  @RequestMapping("exportExcel")  
3.  public void exportExcel(HttpServletRequest request, HttpServletResponse response)  
4.  {  
5.      HttpSession session = request.getSession();  
6.      session.setAttribute("state", null);  
7.      // 生成提示信息，  
8.      response.setContentType("application/vnd.ms-excel");  
9.      String codedFileName = null;  
10.      OutputStream fOut = null;  
11.      try  
12.      {  
13.          // 进行转码，使其支持中文文件名  
14.          codedFileName = java.net.URLEncoder.encode("中文", "UTF-8");  
15.          response.setHeader("content-disposition", "attachment;filename=" + codedFileName + ".xls");  
16.          // response.addHeader("Content-Disposition", "attachment;   filename=" + codedFileName + ".xls");  
17.          // 产生工作簿对象  
18.          HSSFWorkbook workbook = new HSSFWorkbook();  
19.          //产生工作表对象  
20.          HSSFSheet sheet = workbook.createSheet();  
21.          for (int i = 0; i <= 30000; i++)  
22.          {  
23.              HSSFRow row = sheet.createRow((int)i);//创建一行  
24.              HSSFCell cell = row.createCell((int)0);//创建一列  
25.              cell.setCellType(HSSFCell.CELL_TYPE_STRING);  
26.              cell.setCellValue("测试成功" + i);  
27.          }  
28.          fOut = response.getOutputStream();  
29.          workbook.write(fOut);  
30.      }  
31.      catch (UnsupportedEncodingException e1)  
32.      {}  
33.      catch (Exception e)  
34.      {}  
35.      finally  
36.      {  
37.          try  
38.          {  
39.              fOut.flush();  
40.              fOut.close();  
41.          }  
42.          catch (IOException e)  
43.          {}  
44.          session.setAttribute("state", "open");  
45.      }  
46.      System.out.println("文件生成...");  
47.  }  
48.  @RequestMapping("check")  
49.  public void check(HttpServletRequest request, HttpServletResponse response)  
50.  {  
51.      try  
52.      {  
53.          if ("open".equals(request.getSession().getAttribute("state")))  
54.          {  
55.              request.getSession().setAttribute("state", null);  
56.              response.getWriter().write("true");  
57.              response.getWriter().flush();  
58.          }  
59.          else  
60.          {  
61.              response.getWriter().write("false");  
62.              response.getWriter().flush();  
63.          }  
64.      }  
65.      catch (IOException e)  
66.      {}  
67.  }  

   // 导出excel方法
    @RequestMapping("exportExcel")
    public void exportExcel(HttpServletRequest request, HttpServletResponse response)
    {
        HttpSession session = request.getSession();
        session.setAttribute("state", null);
        // 生成提示信息，
        response.setContentType("application/vnd.ms-excel");
        String codedFileName = null;
        OutputStream fOut = null;
        try
        {
            // 进行转码，使其支持中文文件名
            codedFileName = java.net.URLEncoder.encode("中文", "UTF-8");
            response.setHeader("content-disposition", "attachment;filename=" + codedFileName + ".xls");
            // response.addHeader("Content-Disposition", "attachment;   filename=" + codedFileName + ".xls");
            // 产生工作簿对象
            HSSFWorkbook workbook = new HSSFWorkbook();
            //产生工作表对象
            HSSFSheet sheet = workbook.createSheet();
            for (int i = 0; i <= 30000; i++)
            {
                HSSFRow row = sheet.createRow((int)i);//创建一行
                HSSFCell cell = row.createCell((int)0);//创建一列
                cell.setCellType(HSSFCell.CELL_TYPE_STRING);
                cell.setCellValue("测试成功" + i);
            }
            fOut = response.getOutputStream();
            workbook.write(fOut);
        }
        catch (UnsupportedEncodingException e1)
        {}
        catch (Exception e)
        {}
        finally
        {
            try
            {
                fOut.flush();
                fOut.close();
            }
            catch (IOException e)
            {}
            session.setAttribute("state", "open");
        }
        System.out.println("文件生成...");
    }
    @RequestMapping("check")
    public void check(HttpServletRequest request, HttpServletResponse response)
    {
        try
        {
            if ("open".equals(request.getSession().getAttribute("state")))
            {
                request.getSession().setAttribute("state", null);
                response.getWriter().write("true");
                response.getWriter().flush();
            }
            else
            {
                response.getWriter().write("false");
                response.getWriter().flush();
            }
        }
        catch (IOException e)
        {}
    }

 

Js代码  

1. /***********导出start************/  
2.     var excel_flag = 0;  
3.     var win_check;  
4.     var exportExcelBtn = new Ext.Button({  
5.         renderTo:'exportExcelBtn',  
6.         text:"<span class='marL10'>"+'导出'+"</span>",  
7.         height:24,  
8.         iconCls:'findnew',  
9.         width:110,  
10.         bodyStyle:'padding:5px',  
11.         handler: function()  
12.         {  
13.             excel_flag = 0;  
14.             //禁用按钮  
15.             exportExcelBtn.disable();  
16.             location.href = "exportExcel";  
17.             //每隔一秒向后台发送请求  
18.             win_check = window.setInterval(check, 1000);    
19.         }  
20.     });  
21.       
22.     /** 
23.      * 用于防止重复提交 
24.      */  
25.     function check()  
26.     {  
27.         excel_flag ++;  
28.         if(excel_flag > 30)  
29.         {  
30.             //清空定时器  
31.             window.clearInterval(win_check);  
32.             //启用按钮  
33.             exportExcelBtn.enable();  
34.         }  
35.         Ext.Ajax.request(  
36.             {  
37.                 url : 'check',  
38.                 success : function (response, result)  
39.                 {  
40.                     if(response.responseText=="true")  
41.                     {  
42.                         //清空定时器  
43.                         window.clearInterval(win_check);  
44.                         //启用按钮  
45.                         exportExcelBtn.enable();  
46.                     }  
47.                 }  
48.             })  
49.     }  
50.     /***********导出end*****************/  

 欢迎访问我的技术群425783133