<%@ page contentType="application/msexcel" %>
<!-- 以上这行设定本网页为excel格式的网页 -->
<%
response.setHeader("Content-disposition","inline; filename=test1.xls");
//以上这行设定传送到前端浏览器时的档名为test1.xls
//就是靠这一行,让前端浏览器以为接收到一个excel档
%>
<html>
<head>
<title>Excel档案呈现方式</title>
<style>
.xlsText{mso-number-format:"/@";}
</style>
</head>
<body>
<table border="1" width="100%">
<tr>
<td>姓名</td><td>身份证字号</td><td>生日</td>
</tr>
<tr>
<td>李玟</td><td class="xlsText">00111111111</td><td>1900/11/12</td>
</tr>
<tr>
<td>梁静如</td><td>00222222222</td><td>1923/10/1</td>
</tr>
<tr>
<td>张惠妹</td><td>00333333333</td><td>1934/12/18</td>
</tr>
</table>
</body>
</html>
mso-number-format:"0" | NO Decimals |
mso-number-format:"0/.000" | 3 Decimals |
mso-number-format:"/#/,/#/#0/.000" | Comma with 3 dec |
mso-number-format:"mm//dd//yy" | Date7 |
mso-number-format:"mmmm/ d/,/ yyyy" | Date9 |
mso-number-format:"m//d//yy/ h/:mm/ AM//PM" | D -T AMPM |
mso-number-format:"Short Date" | 01/03/1998 |
mso-number-format:"Medium Date" | 01-mar-98 |
mso-number-format:"d/-mmm/-yyyy" | 01-mar-1998 |
mso-number-format:"Short Time" | 5:16 |
mso-number-format:"Medium Time" | 5:16 am |
mso-number-format:"Long Time" | 5:16:21:00 |
mso-number-format:"Percent" | Percent - two decimals |
mso-number-format:"0%" | Percent - no decimals |
mso-number-format:"0/.E+00" | Scientific Notation |
mso-number-format:"/@" | Text |
mso-number-format:"/#/ ???//???" | Fractions - up to 3 digits (312/943) |
mso-number-format:"/0022£/0022/#/,/#/#0/.00" | £12.76 |
mso-number-format:"/#/,/#/#0/.00_ /;/[Red/]/-/#/,/#/#0/.00/ " | 2 decimals, negative numbers in red and signed |