页面源代码如下:<%@ page import="jxl.Workbook" %>
<%@ page import="jxl.write.Label" %>
<%@ page import="jxl.write.WritableSheet" %>
<%@ page import="jxl.write.WritableWorkbook" %>
<%@ page import="jxl.write.WriteException" %>
<%--
author: hyd
Date: 2006-3-29
Time: 17:26:47
--%>
<%
response.reset();
response.setHeader("Cache-Control", "no-store");
response.setHeader("Pragrma", "no-cache");
response.setDateHeader("Expires", 0);
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment; filename=telephonebook.xls"); //生成一个Excel文件并输出到流。
WritableWorkbook book = Workbook.createWorkbook(response.getOutputStream());
WritableSheet sheet = book.createSheet("工作表1", 0);
Label label1 = new Label(0, 0, "Hello!");
try {
sheet.addCell(label1);
} catch (WriteException e) {
e.printStackTrace();
}
book.write();
book.close();
%>用IE打开该页面,截图如下:
http://www.cnblogs.com/images/cnblogs_com/yidinghe/35591/o_export1.GIF
http://www.cnblogs.com/images/cnblogs_com/yidinghe/35591/o_export2.GIF不知道这是为什么?怎样才能用IE下载?谢谢!
<%@ page import="jxl.write.Label" %>
<%@ page import="jxl.write.WritableSheet" %>
<%@ page import="jxl.write.WritableWorkbook" %>
<%@ page import="jxl.write.WriteException" %>
<%--
author: hyd
Date: 2006-3-29
Time: 17:26:47
--%>
<%
response.reset();
response.setHeader("Cache-Control", "no-store");
response.setHeader("Pragrma", "no-cache");
response.setDateHeader("Expires", 0);
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment; filename=telephonebook.xls"); //生成一个Excel文件并输出到流。
WritableWorkbook book = Workbook.createWorkbook(response.getOutputStream());
WritableSheet sheet = book.createSheet("工作表1", 0);
Label label1 = new Label(0, 0, "Hello!");
try {
sheet.addCell(label1);
} catch (WriteException e) {
e.printStackTrace();
}
book.write();
book.close();
%>用IE打开该页面,截图如下:
http://www.cnblogs.com/images/cnblogs_com/yidinghe/35591/o_export1.GIF
http://www.cnblogs.com/images/cnblogs_com/yidinghe/35591/o_export2.GIF不知道这是为什么?怎样才能用IE下载?谢谢!
有问题配置web.xml就行了吧
<extension>xls</extension>
<mime-type>application/vnd.ms-excel</mime-type>
</mime-mapping>
response.setHeader("Pragrma", "no-cache");
response.setDateHeader("Expires", 0);Timsole(一陀智慧),恭喜你了!