求GridView导出到excel,javascript源码?

liujunsummer 2010-02-26 11:10:44

求GridView导出到excel,javascript源码?xiexie

...全文

157 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

polarissky 2010-02-26

打赏
举报

摘自：李天平整理 ASP.NET知识库第4版.chm ASP.NET2.0中Gridview中数据操作技巧 Gridview中的内容导出到Excel
default.aspx

<form id="form1" runat="server">

<div>

<asp:GridView ID="GridView1" runat="server">

</asp:GridView>

</div>

<br/>

<asp:Button ID="BtnExport" runat="server" OnClick="BtnExport_Click" Text="Export to Excel" />

</form>

default.aspx.cs中

protected void Page_Load(object sender, EventArgs e)

{

　if (!Page.IsPostBack)

　{

　　BindData();

　}

}

private void BindData()

{

　string query = "SELECT * FROM customers";

　SqlConnection myConnection = new SqlConnection(ConnectionString);

　SqlDataAdapter ad = new SqlDataAdapter(query, myConnection);

　DataSet ds = new DataSet();

　ad.Fill(ds, "customers");

　GridView1.DataSource = ds;

　GridView1.DataBind();

}



public override void VerifyRenderingInServerForm(Control control)

{

　// Confirms that an HtmlForm control is rendered for

}



protected void Button1_Click(object sender, EventArgs e)

{

　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);



　GridView1.AllowPaging = false;

　BindData();

　GridView1.RenderControl(htmlWrite);



　Response.Write(stringWrite.ToString());

　Response.End();

　GridView1.AllowPaging = true;

　BindData();

}

protected void paging(object sender,GridViewPageEventArgs e)

{

　GridView1.PageIndex = e.NewPageIndex;

　BindData();

}

先将gridview绑定到指定的数据源中，然后在button1的按钮（用来做导出到EXCEL的）的事件中，写入相关的代码。这里使用Response.AddHeader("content-disposition","attachment;filename=exporttoexcel.xls");中的filename来指定将要导出的excel的文件名，这里是exporttoexcel.xls。要注意的是，由于gridview的内容可能是分页显示的，因此，这里在每次导出excel时，先将gridview的allowpaging属性设置为false,然后通过页面流的方式导出当前页的gridview到excel中，最后再重新设置其allowpaging属性。另外要注意的是，要写一个空的VerifyRenderingInServerForm方法（必须写），以确认在运行时为指定的ASP.NET 服务器控件呈现HtmlForm 控件。

cpp2017 2010-02-26

打赏
举报

 public static void ExportExcel(ref System.Web.UI.WebControls.GridView gv, string strFileName)

        {

            strFileName = System.Web.HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8);





            System.Web.HttpContext.Current.Response.Clear();

            System.Web.HttpContext.Current.Response.Buffer = true;

            System.Web.HttpContext.Current.Response.Charset = "UTF-8";

            System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "online; filename=" + strFileName + ".xls");

            System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;

            System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";

            //System.Web.HttpContext.Current.EnableViewState = false;

            System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("zh-CN", true);

            System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);

            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

            



            oHtmlTextWriter.Write("<style>.txt{MSO-NUMBER-FORMAT:\\@}</style>");

            gv.RenderControl(oHtmlTextWriter);



          

            System.Web.HttpContext.Current.Response.Write(oStringWriter.ToString().Replace("<td", "<td class='txt'"));

            System.Web.HttpContext.Current.Response.Buffer = false;

            System.Web.HttpContext.Current.Response.End();

        }