Exprot to Excel in ASP.NET using C#

[amitabhwankhede]

Hi All,
I have an application where user can export the results of search action to an excel file so he can locally store it.. I have done this with very simple code which is

Response.ContentType = "application/vnd.ms-excel";
            Response.AppendHeader("content-disposition", "attachment; filename=StackRanking.xls");
            Response.Charset = "";
            System.IO.StringWriter sw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
           ........fils dataset..... hw.RenderBeginTag(System.Web.UI.HtmlTextWriterTag.Html);
        dg.RenderControl(hw);
            hw.RenderEndTag();
            Response.Write(sw);
            Response.End();

All work fine when end user has Excel 2003 but when he has Excel 2007 it gives a warning err message when he tries to open the rendered Excel File,
I guess i need framework 3.0 to Support the file format of Excel 2007. What in the code needs to be changed to have compatibility with Excel 2007 File.....:rolleyes: