有些时候要导出的东西比较复杂,并不是单单一个List,可能要自定义,这时候用jsp中table来编辑就比较好,这里介绍如果把jsp变成execl,操作确实很简单,看如下步骤:
java代码,用struts:
//清单导出
public ActionForward getExport(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response) {
InvoicesInfoForm f=(InvoicesInfoForm)form;
HttpSession session = request.getSession();
User user = (User) session.getAttribute("loginUser");
List list=dao.qryExeclDate(f);
//关键就是下面几句,设置下属性,其他jsp都不用变,该怎么操作就怎么操作
request.setAttribute("invoiceByContList", list);
response.setHeader("Expires","-1");
response.setHeader("Pragma","no-cache");
response.setHeader("Cache-control","no-cache");
response.setHeader("Content-Type", "application/msexcel; charset=utf-8");
response.setHeader("Content-Disposition", "attachment;filename=reportbyContID.xls");
return mapping.findForward("printByContId");
}
jsp页面:
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.List"%>
<%@page import="java.util.HashMap"%>
<%@page import="java.util.Map"%>
<%@page import="com.rcs.util.db.DBResult"%>
<%@page import="com.rcs.util.db.DBUtil"%>
<%@page import="com.rcs.util.db.DBUtilImpl"%>
<%@page import="com.rcs.util.common.Constants"%>
<%@ page contentType="text/html; charset=GBK" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
DBUtil dbutil = new DBUtilImpl();
List invoiceByContList = (List)request.getAttribute("invoiceByContList");
%>
<html>
<head>
<script language="javascript" type="text/javascript">
var ctp = "<%=path%>";
</script>
<style media=print>
.noprint{display:none;} .pagenext{page-break-after: always;}
</style>
</head>
<body>
<h2 align="center"><%="测试。。。"%></h2>
<div class="">
<%
for(int i = 0;i < invoiceByContList.size();i++) {
Map oneMap = (HashMap)invoiceByContList.get(i);
List<HashMap<String, String>> resList = new ArrayList<HashMap<String, String>>();
String sql = "SELECT PROD_NAME, PROD_FORMAT, ORG_PRICE, AGIO, SENDED_COUNT, REMARK FROM INVOICES_DETAIL WHERE STATE = 1 AND SHEET_ID = " + oneMap.get("sheet_id");
DBResult dbres = dbutil.executeSql(sql, Constants.SQL_TIMEOUT_MAX);
%>
<table style="width: 100%;font-size: 15px;" cellpadding="0" cellspacing="1" border="1">
<tr style="margin-top:10px;"><td>
<table style="width: 100%;font-size: 15px;" cellpadding="0" cellspacing="1" border="1">
<tr>
<td style="padding:5px;">发货单编号</td>
<td >发货单名称</td>
<td >客户名称</td>
<td >合同名称</td>
<td >发货数量</td>
<td >总金额</td>
<td >发货日期</td>
</tr>
<tr>
<td style="padding:5px;"><%=i+1 %></td>
<td style="background-color: white"><%=oneMap.get("sheet_name") %></td>
<td style="background-color: white"><%=oneMap.get("cust_name") %></td>
<td style="background-color: white"><%=oneMap.get("cont_name") %></td>
<td style="background-color: white"><%=oneMap.get("sum_count") %></td>
<td style="background-color: white"><%=oneMap.get("sum_money") %></td>
<td style="background-color: white"> <%=oneMap.get("shipped_date")%></td>
</tr>
</table>
<table style="width: 100%;font-size: 15px;" cellpadding="0" cellspacing="1" border="1">
<tr>
<td style="padding:5px;">产品编号</td>
<td >产品名称</td>
<td >产品规格</td>
<td >产品单价</td>
<td >发货数量</td>
<td >金额</td>
<td >备注</td>
</tr>
<%
for(int j = 0;j < dbres.iSum;j++) {
%>
<tr>
<td ><%=j+1 %></td>
<td style="background-color: white"><%=dbres.aaOut[j][0] %></td>
<td style="background-color: white"><%=dbres.aaOut[j][1] %></td>
<td style="background-color: white">¥<%=Float.parseFloat((String)dbres.aaOut[j][2])*Float.parseFloat((String)dbres.aaOut[j][3]) %></td>
<td style="background-color: white"><%=dbres.aaOut[j][4] %></td>
<td style="background-color: white">¥<%=Float.parseFloat((String)dbres.aaOut[j][2])*Float.parseFloat((String)dbres.aaOut[j][3])*Float.parseFloat((String)dbres.aaOut[j][4]) %></td>
<td style="background-color: white"> <%=dbres.aaOut[j][5]%></td>
</tr>
<%
}
%>
</table>
</td>
</tr>
</table>
<br style='mso-data-placement:same-cell;'/>
<br style='mso-data-placement:same-cell;'/>
<%
}
%>
</div>
</body>
</html>
效果如下,敏感信息我涂掉了,但是效果还是能看出的啦