jsp将数据导入Excel表

最新推荐文章于 2021-02-26 17:47:06 发布

yang472579211

最新推荐文章于 2021-02-26 17:47:06 发布

阅读量891

点赞数

分类专栏： java 文章标签： Excel JSP Ajax Struts 框架

java 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

<%@ page contentType="application/vnd.ms-excel;charset=GBK" %>
[color=red]<%
response.setHeader("Content-Disposition", "attachment;filename=query.xls");
%> [/color]
<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<body>
<s:form name="accident" action=""
id="frm">
[color=green]<table width="100%" border="0" align="center" cellpadding="3"
cellspacing="1" bgcolor="A4C2E8" style="border-collapse: collapse">
<tr><td colspan="14"><div align="center"><b>安全主任列表</b></div></td></tr>
<tr bgcolor="#FFFFFF">
<td width="3%"><div align="center">序号</div></td>
<td width="6%"><div align="center">姓名</div></td>
<td width="2%"><div align="center">性别</div></td>
<td width="2%"><div align="center">年龄</div></td>
<td width="10%"><div align="center">学历</div></td>
<td width="15%"><div align="center">工作单位</div></td>
<td width="10%"><div align="center">身份证号</div></td>
<td width="8%"><div align="center">手机</div></td>
<td width="3%"><div align="center">从事安全年限</div></td>
<td width="2%"><div align="center">成绩</div></td>
<td width="10%"><div align="center">证书号</div></td>
<td width="10%"><div align="center">注册编号</div></td>
<td width="10%"><div align="center">注册单位</div></td>
<td width="9%"><div align="center">注册时间</div></td>
</tr>
<s:iterator value="list" status="status">
<tr bgcolor="#FFFFFF">
<td><div align="center">87967</div></td>
<td><div align="center">43535</div></td>
<td><div align="center">${sex }</div></td>
<td><div align="center">${age}</div></td>
<td><div align="center">${culture}</div></td>
<td><div align="center">${entpName}</div></td>
<td><div align="center">${idcard}</div></td>
<td><div align="center">${tel}</div></td>
<td><div align="center">${yearOfSecurity}</div></td>
<td><div align="center">${theoryScore}</div></td>
<td><div align="center">${masterNo}</div></td>
<td><div align="center">${registerNo}</div></td>
<td><div align="center">${handlePerson}</div></td>
<td><div align="center">${registerTime}</div></td>
</tr>
</s:iterator>
</table> [/color]
</s:form>
</body>
</html>