Kabiriel Anand Raj

Export gridview to Excel with Css in Visual webpart



{
protected void btnexcel_Click(object sender, EventArgs e)try{

}

{

}
}
//add this after page loadthis.bExport = true;catch (Exception ex)throw ex;
{

{

{

Page.Response.Clear();
Page.Response.Buffer =
Page.Response.ContentType =
Page.Response.AddHeader(
Page.Response.Charset =


System.IO.
System.Web.UI.
Grdshow.RenderControl(htw);
Page.Response.Write(sw.ToString());
Page.Response.End();
}
}

}protected override void Render(HtmlTextWriter writer)if (Page != null)if (bExport)this.bExport = false;true;"application/ms-excel";"content-disposition", "attachment; filename=AmexReport" + DateTime.Now + ".xls");"UTF-8";HttpContext.Current.Response.Write("Amex Report");this.EnableViewState = false;StringWriter sw = new System.IO.StringWriter();HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);base.Render(writer);