在你的jsp里加入下面粗体的代码即可:
<%@ page contentType="application/msexcel" %>
<%
String filename="测试导出excel报表"; //文件名
//独立打开excel软件
response.setHeader("Content-disposition","attachment; filename="+filename+".xls");
//嵌套在ie里打开excel
//response.setHeader("Content-disposition","inline; filename="+filename+".xls");
//Word只需要把contentType="application/msexcel"改为contentType="application/msword"
%>
<html>
<head>
<title>Excel档案呈现方式</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>
这样,访问这个jsp,回出现下面的窗口
点打开按钮