You can try
Export To Excel Utility
or
use this method
public static void PrepareGridViewForExport(Control gridView)
{
for (int i = 0; i < gridView.Controls.Count; i++)
{
Control currentControl = gridView.Controls[i];
if (currentControl is LinkButton)
{
gridView.Controls.Remove(currentControl);
gridView.Controls.AddAt(i, new LiteralControl((currentControl as LinkButton).Text));
}
else if (currentControl is ImageButton)
{
gridView.Controls.Remove(currentControl);
gridView.Controls.AddAt(i, new LiteralControl((currentControl as ImageButton).AlternateText));
}
else if (currentControl is HyperLink)
{
gridView.Controls.Remove(currentControl);
gridView.Controls.AddAt(i, new LiteralControl((currentControl as HyperLink).Text));
}
else if (currentControl is DropDownList)
{
gridView.Controls.Remove(currentControl);
gridView.Controls.AddAt(i, new LiteralControl((currentControl as DropDownList).SelectedItem.Text));
}
else if (currentControl is CheckBox)
{
gridView.Controls.Remove(currentControl);
gridView.Controls.AddAt(i, new LiteralControl((currentControl as CheckBox).Checked ? "True" : "False"));
}
if (currentControl.HasControls())
{
PrepareGridViewForExport(currentControl);
}
}
}
and on export button click event
call
PrepareGridViewForExport(gridView1);
and then export to excel code