Java Background Excel table export

Source: Internet
Author: User

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> &LT;TD WI             Dth= ' > Nickname </td> <td width= ' + ' > Phone number </td> <td width= ' > ' Reload amount </td> &LT;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" &GT;&LT;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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.