<%@ page language="java" contentType="application/msexcel; charset=utf-8"
pageEncoding="utf-8"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.Calendar"%>
<!-- 以上这行设定本网页为excel格式的网页 -->
<%
// SimpleDateFormat ft=new SimpleDateFormat("yyyy-MM-dd");
Calendar c=Calendar.getInstance();
c.setTime(new java.util.Date());
c.add(Calendar.DAY_OF_MONTH,-1);
String strd=""+(c.get(Calendar.MONTH)+1)+c.get(Calendar.DAY_OF_MONTH);
//String strd=ft.format(new java.util.Date());
String str="attachment; filename=test"+strd+".xls";
response.setHeader("Content-disposition",str);
response.setCharacterEncoding("gbk");
//以上这行设定传送到前端浏览器时的档名为test1.xls
//就是靠这一行,让前端浏览器以为接收到一个excel档
%>
线上浏览的方式: response.setHeader("Content-disposition","inline; filename=test1.xls");
下载的方式: response.setHeader("Content-disposition","attachment; filename=test2.xls");