如何把JSP页面导出到Excel中
1个回答
展开全部
这里有个例子供参考：
<%
String fileName=(String)request.getAttribute("fileName");
fileName = new String(fileName.getBytes("GBK"), "iso-8859-1");
response.reset();
response.setContentType("application/vnd.ms-excel;charset=GBK");
response.addHeader("Content-Disposition","attachment; filename=" + fileName);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk"/>
</head>
<body>
<table width="100%" border="1" align="right" cellpadding="0" cellspacing="1">
<thead>
<tr>
<th>序号</th>
<th>编码</th>
<th>时间</th>
</tr>
</thead>
<tbody>
<c:forEach var="entity" items="${pageBean.dataList}" varStatus="s">
<tr>
<td><c:out value="${s.index+1}"/></td>
<td><c:out value="${entity.code}"/></td>
<td><fmt:formatDate value="${entity.returnDate}" pattern="yyyy-MM-dd HH:mm:ss" /></td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>
<%
String fileName=(String)request.getAttribute("fileName");
fileName = new String(fileName.getBytes("GBK"), "iso-8859-1");
response.reset();
response.setContentType("application/vnd.ms-excel;charset=GBK");
response.addHeader("Content-Disposition","attachment; filename=" + fileName);
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk"/>
</head>
<body>
<table width="100%" border="1" align="right" cellpadding="0" cellspacing="1">
<thead>
<tr>
<th>序号</th>
<th>编码</th>
<th>时间</th>
</tr>
</thead>
<tbody>
<c:forEach var="entity" items="${pageBean.dataList}" varStatus="s">
<tr>
<td><c:out value="${s.index+1}"/></td>
<td><c:out value="${entity.code}"/></td>
<td><fmt:formatDate value="${entity.returnDate}" pattern="yyyy-MM-dd HH:mm:ss" /></td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
