<%@ page language="java" pageEncoding="UTF-8"%>
<%@ include file="/common/taglib.jsp"%>
<%
String wjm="inforeport.xls";
wjm = new String("库房储位.xls".getBytes("GBK"),"ISO8859-1");
response.setContentType( "application/vnd.ms-excel;charset=UTF-8");
response.setHeader("content-disposition","attachment; filename=" +wjm );
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns:x="urn:schemas-microsoft-com:office:excel">
<head>
<!-- 显示网格线 -->
<!--[if gte mso 9]-->
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>库房储位</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo />
</x:Print>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml>
<!--[endif]-->
<!-- 显示网格线 -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>库房储位</title>
<style type="text/css">
td{height:25px;}
body{font-size:22px;}
</style>
</head>
<body>
<table border="2">
<thead>
<tr>
<th width="30"><span>序号</span></th>
<th align="center">系统系统编号</th>
<th align="center">储位编号</th>
<th align="center">手机号</th>
<th align="center">档案编号</th>
<th align="center">业务类型</th>
<th align="center">姓名</th>
<th align="center">身份证明号</th>
<th align="center">创建人</th>
<th align="center">创建时间</th>
<th align="center">录入时间</th>
<th align="center">档案状态</th>
<th align="center">提档时间</th>
</tr>
</thead>
<tbody>
<c:forEach var="info" items="${datalist}" varStatus="status">
<tr align="center">
<td align="center">${status.index+1}</td>
<td align="center" style="mso-number-format:\@">${info.arcSid}</td>
<td align="center" style="mso-number-format:\@">${info.storeNumber}</td>
<td align="center" style="mso-number-format:\@">${info.lsh}</td>
<td align="center" style="mso-number-format:\@">${info.dabh}</td>
<td align="center">${vs:driverYwlxName(info.ywlx)}</td>
<td align="center">${info.xm}</td>
<td align="center" style="mso-number-format:\@">${info.sfzmhm}</td>
<td align="center" style="mso-number-format:\@">${info.createPeopleName}(${info.createPeople})</td>
<td align="center"><fmt:formatDate value="${info.createTime}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
<td align="center"><fmt:formatDate value="${info.gdsj}" pattern="yyyy-MM-dd"/></td>
<td class="ali02" style="mso-number-format:\@">${vs:driverDaztName(info.recordState)}</td>
<td class="ali02"><fmt:formatDate value="${info.verifyTime}" pattern="yyyy-MM-dd"/></td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>
myeclipse根据数据list下载excel表格
最新推荐文章于 2021-02-28 12:31:45 发布