/**//// <summary>
/// 將gridview匯出到Excel
/// </summary>
#region
protected void ToExcel()
{
//屏蔽掉不需要匯出的列
gvList.Columns[0].Visible = false;
gvList.Columns[2].Visible = false;
gvList.Columns[6].Visible = false;
gvList.Columns[7].Visible = false;
gvList.Columns[9].Visible = false;
gvList.Columns[10].Visible = false;
gvList.Columns[11].Visible = false;
gvList.Columns[13].Visible = false;
//匯出
string FileName = "test";
Response.Clear();
Response.AddHeader("content-disposition",
"attachment;filename="+FileName+".xls");
Response.Charset = "gb2312";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite =
new HtmlTextWriter(stringWrite);
gvList.AllowPaging = false;
ListGridViewDataBind();
gvList.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
gvList.AllowPaging = true;
ListGridViewDataBind();
}
public override void VerifyRenderingInServerForm(Control control)
{
// Confirms that an HtmlForm control is rendered for
}
protected void paging(object sender, GridViewPageEventArgs e)
{
gvList.PageIndex = e.NewPageIndex;
ListGridViewDataBind();
}
protected void gvList_RowDataBound( object sender, GridViewRowEventArgs e )
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[1].Attributes.Add("style", "vnd.ms-excel.numberformat:@;");
}
}
#endregion
需要注意的是要在頁面中加入紅色部分,這樣才不會報錯
<%@ Page Language="C#" EnableEventValidation="false" MasterPageFile="~/site.master"
AutoEventWireup="true" CodeFile="WorkList.aspx.cs" Inherits="TspSystem_DemandManagerModule_WorkList"
Title="Untitled Page" %>
