spring MVC 导出excel

最新推荐文章于 2022-06-26 11:38:18 发布

iteye_3851

最新推荐文章于 2022-06-26 11:38:18 发布

阅读量108

点赞数

CC 4.0 BY-SA版权

文章标签： Excel MVC Spring EXT Ajax

本文链接：https://blog.youkuaiyun.com/iteye_3851/article/details/82046020

本文介绍了如何使用Java实现导出Excel的功能，并通过HTTP请求检查导出状态。包括了编码文件名、生成工作簿和工作表、设置响应头等关键步骤，以及通过定时器实现防止重复提交的逻辑。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


   // 导出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)
        {}
    }


/***********导出start************/
	var excel_flag = 0;
	var win_check;
    var exportExcelBtn = new Ext.Button({
        renderTo:'exportExcelBtn',
        text:"<span class='marL10'>"+'导出'+"</span>",
        height:24,
        iconCls:'findnew',
        width:110,
        bodyStyle:'padding:5px',
        handler: function()
        {
            excel_flag = 0;
            //禁用按钮
        	exportExcelBtn.disable();
        	location.href = "exportExcel";
        	//每隔一秒向后台发送请求
        	win_check = window.setInterval(check, 1000);  
        }
    });

    /**
     * 用于防止重复提交
     */
    function check()
    {
    	excel_flag ++;
    	if(excel_flag > 30)
    	{
    		//清空定时器
    		window.clearInterval(win_check);
    		//启用按钮
    		exportExcelBtn.enable();
    	}
    	Ext.Ajax.request(
        	{
            	url : 'check',
            	success : function (response, result)
            	{
            		if(response.responseText=="true")
            		{
            			//清空定时器
            			window.clearInterval(win_check);
            			//启用按钮
            			exportExcelBtn.enable();
            		}
            	}
        	})
    }
    /***********导出end*****************/