private void Othergrid()
{
//try
//{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=ExportGridData.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (System.IO.StringWriter StringWriter = new System.IO.StringWriter())
{
HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);
Othersgridview.AllowPaging = false;
this.oThertext();
Othersgridview.CssClass = "rounded_corners";
foreach (GridViewRow row in Othersgridview.Rows)
{
foreach (TableCell cell in row.Cells)
{
cell.Attributes.CssStyle["text-align"] = "center";
List <Control> controls = new List <Control>();
//Add controls to be removed to Generic List
foreach (Control control in cell.Controls)
{
controls.Add(control);
}
//Loop through the controls to be removed and replace then with Literal
foreach (Control control in controls)
{
switch (control.GetType().Name)
{
case "Label":
cell.Controls.Add(new Literal {
Text = (control as Label).Text
});
break;
}
cell.Controls.Remove(control);
}
}
}
Othersgridview.RenderControl(HtmlTextWriter);
Response.Write(StringWriter.ToString());
Response.End();
}
//}
//catch (Exception ex)
//{
// throw ex;
//}
}
