To export data to Excel:
1. Return the data query to the Export JSP page.
//Exporting Data@RequestMapping (value = "/chonglog_info_xls", produces= "Text/html;charset=utf-8") Publicstring 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. Export function jsp file configuration
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 "%><% @pageImport= "java.util.*"%>td{vnd.ms-excel.numberformat:@; border:0. 5pt solid #c5c5c5; height:30px; Word- Break: Break-All ; Word-wrap: Break-Word; } #tab_title Td{background: #f5f5f5;} </style> Response.setheader ("Content-disposition", "Filename=emp.xls"); String menu_id=request.getparameter ("menu_id"); String Cookie_menu=request.getparameter ("Cookie_menu"); %><body> <%=addexcelhead ()%> <!--content Panel – Start-to-<table cellpadding= "0" cellspacing= "0" bo Rder= "1" style= "border:0px Red solid;table-layout:fixed;" > <tr valign= "middle" > <td style= "Font-size:18px;font-weight:700;border:none" width= "3 0 "height=" align= "center" colspan= "7" > <div> system Recharge details </div> </td> </tr> <tr id= "Tab_title" > <td width= ' + ' > serial number </td> <TD WI Dth= ' > Nickname </td> <td width= ' + ' > Phone number </td> <td width= ' > ' Reload amount </td> <TD width= ' > Pre-Recharge amount </td> <td width= ' + ' > Recharge amount </td> <td Widt H= ' > Recharge time </td> </tr> <c:set value= "0" var= "T_money" ></c:set> <c:set value= "0" var= "T_amount" ></c:set> <c:foreach var= "BK" items= "${list}" varstatus= "status" > <c:set value= "${t_money+ Bk.c__mon EY} "var=" T_money "></c:set> <c:set value=" ${t_amount+ 1} "var=" T_amount "></c:set> <tr> <td>${status.index+1} <td>${bk.a__name}<td>${bk.a__tel}<td>${bk.c__money}<td>${bk.c__balance}<td>${bk.c__after}<td>${bk.c__insert_date}</c:forEach> <tr> <td colspan= ' 7 ' width= ' style= ' text-align:left;font-size : 14px; " >Total: Total<span style= "color:red" >${t_amount}</span> records, the total amount of the recharge is <span style= "color:red" ><FMT: FormatNumber type= "number" value= "${t_money}" pattern= "0.00" maxfractiondigits= "2"/> </span>Yuan. </td> </tr> </table> <%=addexcelbottom ()%></body>Private StaticString Addexcelhead () {StringBuffer sb=NewStringBuffer (); Sb.append ("); Sb.append ("); Sb.append ("<!--[if GTE MSO 9]><xml>]); Sb.append ("<x:ExcelWorkbook>"); Sb.append ("<x:ExcelWorksheets>"); Sb.append ("<x:ExcelWorksheet>"); Sb.append ("<x:Name>Sheet</x:Name>"); Sb.append ("<x:WorksheetOptions>"); Sb.append ("<x:Print>"); Sb.append ("<x:validprinterinfo/>"); Sb.append ("</x:Print>"); Sb.append ("</x:WorksheetOptions>"); Sb.append ("</x:ExcelWorksheet>"); Sb.append ("</x:ExcelWorksheets>"); Sb.append ("</x:ExcelWorkbook>"); Sb.append ("</xml>"); Sb.append ("<! [endif]--> "); Sb.append ("); Sb.append ("<body>"); returnsb.tostring (); } Private StaticString Addexcelbottom () {StringBuffer sb=NewStringBuffer (); Sb.append ("</body>"); Sb.append ("); returnsb.tostring (); }%>
Java Background Excel table export