- <%@ page contentType="application/msexcel" %>
- <%
- //独立打开excel软件
- response.setHeader("Content-disposition","attachment; filename=MyExcel.xls");
- //嵌套在ie里打开excel
- //response.setHeader("Content-disposition","inline; filename=MyExcel.xls");
- //Word只需要把contentType="application/msexcel"改为contentType="application/msword"
- %>
- <html>
- <head>
- <title>测试导出Excel和Word</title>
- </head>
- <body>
- <table width="500" border="1" align="center">
- <tr>
- <td colspan="4" align="center">电子产品测试统计</td>
- </tr>
- <tr>
- <td width="7%">条形码</td>
- <td width="7%">电压</td>
- <td width="18%">电流</td>
- <td width="68%">功率</td>
- </tr>
- <tr>
- <td>20061006</td>
- <td>xxx</td>
- <td>xxx</td>
- <td>xxxxx</td>
- </tr>
- <tr>
- <td>20061007</td>
- <td>xx</td>
- <td>xxx</td>
- <td>xxxxx</td>
- </tr>
- <tr>
- <td>20061008</td>
- <td>xx</td>
- <td>xxx</td>
- <td>xxxxx</td>
- </tr>
- </table>
- </body>
- </html>
参考网页:http://www.javaeye.com/topic/375929
类似网页:http://www.javaeye.com/topic/94817
http://www.topsemtips.com/2008/11/save-html-table-to-excel-using-jquery/
Struts2利用stream直接输出Excel: http://www.java3z.com/cwbwebhome/article/article2/21102.html?id=1890