JSP导出Excel身份证号码超出Excel最大限制,用科学计数法表示,但后三位为0,修改方式:
<style type="text/css">
.txt
{
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:宋体;
mso-generic-font-family:auto;
mso-font-charset:134;
mso-number-format:"@";
text-align:general;
vertical-align:middle;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;
}
</style>
<body>
<center>
<table borderColor="#000000" cellSpacing="0" align="center" border="1">
<thead>
<tr><td>身份证号</td></tr>
</thead>
<c:forEach items="${requestScope.vd301s }" var="vd301" varStatus="i">
<tr><td class="txt">${vd301.d30112 }</td></tr>
</c:forEach>
</table>
</center>
</body>