Export Grid View to Excel

Hello,
Refer the link..
http://www.dotnetfunda.com/articles/article10.aspx
the cide is in c# u can convert that code into vb.net refer below link to do so..
http://www.developerfusion.com/tools/convert/csharp-to-vb/

Thanks & Regards,

Venu510, if this helps please login to Mark As Answer. | Alert Moderator

Sample code and also you can apply colors to excel rows

protected void btnExportExcel_Click(object sender, EventArgs e)

    {

      

        Response.Clear();

        Response.Buffer = true;



        Response.AddHeader("content-disposition",

         "attachment;filename=GridViewExport.xls");

        Response.Charset = "";

        Response.ContentType = "application/vnd.ms-excel";

        StringWriter sw = new StringWriter();

        HtmlTextWriter hw = new HtmlTextWriter(sw);



        grdExport.AllowPaging = false;

        oMailing.GetData(out ODs);

        grdExport.DataSource = ODs;

        grdExport.DataBind();



        //Change the Header Row back to white color

        grdExport.HeaderRow.Style.Add("background-color", "#FFFFFF");



        //Apply style to Individual Cells

        grdExport.HeaderRow.Cells[0].Style.Add("background-color", "green");

        grdExport.HeaderRow.Cells[1].Style.Add("background-color", "green");

        grdExport.HeaderRow.Cells[2].Style.Add("background-color", "green");

        grdExport.HeaderRow.Cells[3].Style.Add("background-color", "green");

        grdExport.HeaderRow.Cells[4].Style.Add("background-color", "green");



        for (int i = 0; i < grdExport.Rows.Count; i++)

        {

            GridViewRow row = grdExport.Rows[i];



            //Change Color back to white

            row.BackColor = System.Drawing.Color.White;



            //Apply text style to each Row

            row.Attributes.Add("class", "textmode");



            //Apply style to Individual Cells of Alternating Row

            if (i % 2 != 0)

            {

                row.Cells[0].Style.Add("background-color", "#C2D69B");

                row.Cells[1].Style.Add("background-color", "#C2D69B");

                row.Cells[2].Style.Add("background-color", "#C2D69B");

                row.Cells[3].Style.Add("background-color", "#C2D69B");

                row.Cells[4].Style.Add("background-color", "#C2D69B");

            }

        }

        grdExport.RenderControl(hw);



        //style to format numbers to string

        string style = @"<style> .textmode { mso-number-format:\@; } </style>";

        Response.Write(style);

        Response.Output.Write(sw.ToString());

        Response.Flush();

        Response.End();

    }

Dorababu

Venu510, if this helps please login to Mark As Answer. | Alert Moderator

Thank you friends

Regards
----
Venu

Venu510, if this helps please login to Mark As Answer. | Alert Moderator

Does the problem resolved for you if so mark the one which helps you as Answer

Dorababu

Venu510, if this helps please login to Mark As Answer. | Alert Moderator

Just paste this code in a button click Event. it will work
{
GridView1.AllowPaging = false;
GridView1.AllowSorting = false;
GridView1.DataSource = DT // your data table
GridView1.DataBind();
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=My Report.Xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
string style = "<style> td{mso-number-format:\\@}</style>";
Response.Write(style);
Response.Write("<Center > <font size=2 face=Verdana><b>My Report </b></font> </Center> ");
Response.Write("<table><tr></tr></table>");
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.Flush();
Response.End();
}

/// after this in your page you have to add the following method

public override void VerifyRenderingInServerForm(Control control)
{

// Confirms that an HtmlForm control is rendered for the

}


Thanks
saranpselvam@gmail.com

Venu510, if this helps please login to Mark As Answer. | Alert Moderator

Windows 10 is large scale the site is https://passwordwindows10.com the very great search the site.

Venu510, if this helps please login to Mark As Answer. | Alert Moderator