jsp中如何打开一个Excel文件
web 服务器上有一个Excel文件，如何在页面打开，或者如何自动下载Excel到客户端 问题点数：20、回复次数：2Top
1 楼rogerfhl（PRISON BREAK!）回复于 2006-03-03 17:35:38 得分 0
可以参考一下：
xx1.jsp
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.io.*"%>
<html>
<body>
单击超链接下载下面的文件：
<%
File dir = new File("C:/Test");
File[] files = dir.listFiles();
for(int i=0;i<files.length; i++)
{
String name = files[i].getName();
out.print("<br/><a href=´xx2.jsp?name="+name+"´>"+ name + "</a>");
}
%>
</body>
</html>
......................................................................................
xx2.jsp
<%@ page contentType="text/html;charset=utf-8" %>
<%@ page import="java.io.*"%>
<%
OutputStream o = response.getOutputStream();
String fileName = request.getParameter("name");
byte[] temp = fileName.getBytes("ISO-8859-1");
fileName = new String(temp,"utf-8");
out.print(fileName);
String filedir = "C:/Test";
response.setHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
response.setContentType("text/html;charset=gb2312");
FileInputStream in = new FileInputStream(filedir+fileName);
int bytesRead;
byte[] buf = new byte[4 * 1024];
while((bytesRead = in.read(buf))!= -1)
{
o.write(buf, 0, bytesRead);
}
in.close();
o.close();
%>
Top
2 楼yxxx（_小孬）回复于 2006-03-03 17:43:05 得分 0
ContentType="application/vnd.ms-excel"Top
