protected void Button1_Click(object sender, EventArgs e)

    {

        Response.ClearContent();

        Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");

        Response.ContentType = "application/excel";

        Response.Write(GetGridTableHtml(Grid1));

        Response.End();

    }

    private string GetGridTableHtml(Grid grid)

    {

        StringBuilder sb = new StringBuilder();

        sb.Append("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");

        sb.Append("<tr>");

        foreach (GridColumn column in grid.Columns)

        {

            sb.AppendFormat("<td>{0}</td>", column.HeaderText);

        }

        sb.Append("</tr>");

        foreach (GridRow row in grid.Rows)

        {

            sb.Append("<tr>");

            foreach (object value in row.Values)

            {

                string html = value.ToString();

                sb.AppendFormat("<td>{0}</td>", html);

            }

            sb.Append("</tr>");

        }

        sb.Append("</table>");

        return sb.ToString();

    }