Tuesday, January 15, 2013

Export to Excel From Grid View in Asp.net


 protected void lnkbutExport_Click(object sender, ImageClickEventArgs e)
        {
            try
            {
                Response.Clear();
                Response.AddHeader("content-disposition", "attachment;filename=MyExcelFile.xls");
                Response.Charset = "";
                //Response.ContentType = "application/content.xls";
                StringWriter StringWriter = new System.IO.StringWriter();
                HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);
                gvForecast.RenderControl(HtmlTextWriter);
                Response.Write(StringWriter.ToString());
                Response.End();
            }
            catch(Exception ex)
            {
            }
        }

        public override void VerifyRenderingInServerForm(Control control)
        {

        }

No comments:

Post a Comment