protected void Page_Load(object sender, EventArgs e)
{
GridView1.DataSource = dt();
GridView1.DataBind();
}
public DataTable dt()
{
DataTable dt = new DataTable();
dt.Columns.Add("A");
dt.Columns.Add("B");
dt.Columns.Add("C");
DataRow dr = dt.NewRow();
dr[0] = "a"; dr[1] = "b"; dr[2] = "c";
dt.Rows.Add(dr); return dt; }
protected void Button1_Click(object sender, EventArgs e)
{
#region 导出页面GridView1数据,不包括button之类的 /
/Response.Clear();
//Response.Charset = "GB2312";
//输出是采用的gb2312(简体中文)
//Response.ContentEncoding = System.Text.Encoding.UTF8;
//设置输出流为UTF8
//Response.AppendHeader("Content-Disposition", "attachment;filename=Store Detail.xls");
//Response.ContentType = "application/vnd.ms-excel";
//this.EnableViewState = false;
//StringWriter tw = new StringWriter();
//HtmlTextWriter hw = new HtmlTextWriter(tw);
//GridView1.RenderControl(hw);
//Response.Write(tw.ToString());
//Response.End();
#endregion
#region 导出页面所有数据,包括button之类的
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment;filename=Store Detail.xls");
Response.Write(" ");
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.Flush(); Response.End();
#endregion
}
public override void VerifyRenderingInServerForm(Control control)
{
}