导出数据到Excel：

1. 将数据查询出来返回给导出jsp页面。

//导出数据            @RequestMapping(value ="/chongLog_info_xls",produces="text/html;charset=UTF-8")            public String consume_info_xls(String q_start_date,String q_end_date,Model map,HttpServletRequest request,String user_type,String q_tel,String status){                String q_str="";                        if(q_tel!=null && !q_tel.equals("")){                    q_str+=" and a.tel like '%"+q_tel+"%'";                }                               if(StringUtils.isNotBlank(q_start_date)){                                        q_str+=" and to_char(a.insert_date,'yyyy-MM-dd') >='"+q_start_date+"'";                }                if(StringUtils.isNotBlank(q_end_date)){                                        q_str+=" and to_char(a.insert_date,'yyyy-MM-dd') <='"+q_end_date+"'";                }                String sql="select a.name a__name,a.tel a__tel,c.money c__money,c.insert_date c__insert_date,c.balance c__balance,c.balance+c.money c__after"                        + " from t_fg_user a,T_CHONG_LOG c where a.id=c.user_id "                + " and 1=1 "+q_str+" order by c.insert_date desc";                List list=proxy_jyyzService.findall(sql);                map.addAttribute("list", list);                return "bg/finance/chongLog_info_xls";            }

2. 导出功能jsp文件配置

chongLog_info_xls.jsp:

<%@ page contentType="application/x-msexcel;" pageEncoding="utf-8"%><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %><%@page import="java.util.*"%>           
                        <%            response.setHeader("Content-Disposition","filename=emp.xls");         String menu_id=request.getParameter("menu_id");        String cookie_menu=request.getParameter("cookie_menu");     %>    <%=AddExcelHead()%>    
         
     
     
                    
                     
                     
     
     
               
       
                         
                
         
          系统充值明细
         
            
                   
                       
                    
序号
                    
昵称
                    
手机号
                    
充值金额
                    
充值前金额
                    
充值后金额
                    
充值时间
                              
                                                              
                           
${status.index+1}                
        
${bk.a__name}                
        
${bk.a__tel}                
        
${bk.c__money}                
        
${bk.c__balance}                
        
${bk.c__after}                
        
${bk.c__insert_date}                                                          
       
       
                        
                    合计：共 ${t_amount} 个记录，充值总金额为 
            元。                                    
                   
          
     
   <%=AddExcelbottom()%><%!    private static String AddExcelHead(){         StringBuffer sb = new StringBuffer();        sb.append("");        sb.append(" ");        sb.append(" 
     ");         sb.append(" ");         sb.append("");        return sb.toString();     }    private static String AddExcelbottom(){        StringBuffer sb = new StringBuffer();        sb.append("");        sb.append("");        return sb.toString();    }%>