Export to Excel from Gridview in ASP.net Form

Aamir Khan

15y1.9k.NET

Dear Frnds,
I want a form in which i have a Gridview, i want to export all the records or data in that Gridview to Excel.
please help me.
Thanks

aamir

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tulasi15y ago
Response.Clear()

        ' Set the type and filename
        Response.AddHeader("content-disposition", "attachment;filename=FileName.xls")
        Response.Charset = ""
        Response.ContentType = "application/vnd.xls"

        ' Add the HTML from the GridView to a StringWriter so we can write it out later
        Dim sw As System.IO.StringWriter = New System.IO.StringWriter
        Dim hw As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(sw)
        GridView1.RenderControl(hw)

        ' Write out the data
        Response.Write(sw.ToString)
        Response.End()
check the below link
http://www.codeproject.com/KB/office/office_automation.aspx
Please mark the answer as Accepted if it helps you.
0
Hemant Kumar15y ago
Hi You need to add this lines of Code in the button Click of Export to Excel
Response.Clear();

        Response.AddHeader("content-disposition", "attachment;
        filename=FileName.xls");

        Response.Charset = "";

        // If you want the option to open the Excel file without saving than

        // comment out the line below

        // Response.Cache.SetCacheability(HttpCacheability.NoCache);

        Response.ContentType = "application/vnd.xls";

        System.IO.StringWriter stringWrite = new System.IO.StringWriter();

        System.Web.UI.HtmlTextWriter htmlWrite =
        new HtmlTextWriter(stringWrite);

        GridView1.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());

        Response.End();
0