3
hi there,i am able to export the gridview data to excel sheet successfully but my gridview has 3 buttonfields like details etc etc which when clicked give the details,but i dont want those buttonfields to be in my excel sheet.plz help me.or alter the code below so that i can limit the columns to be exported to my excel sheet.
protected void BtnExport_Click(object sender, EventArgs e)
{
string attachment = "attachment; filename=Contacts.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
this.ClearControls(devViewGrid1);
devViewGrid1.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}
private void ClearControls(Control control)
{
for (int i = control.Controls.Count-1 ; i >= 0; i--)
{
ClearControls(control.Controls[i]);
}
if (!(control is TableCell))
{
if (control.GetType().GetProperty("SelectedItem") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
try
{
literal.Text = (string)control.GetType().GetProperty("SelectedIte m").GetValue(control, null);
}
catch
{
}
control.Parent.Controls.Remove(control);
}
else
if (control.GetType().GetProperty("Text") != null)
{
LiteralControl literal = new LiteralControl();
literal.Text = (string)control.GetType().GetProperty("Text").GetV alue(control, null);
if (literal.Text != "Top n")
control.Parent.Controls.Add(literal);
control.Parent.Controls.Remove(control);
}
return;
}
}
