How to Export to an Excel 2007

[Amitabh Wankhed]

Hi All,

I have an web 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 (downloaded) Excel File,I guess i need framework 3.0 to Support the file format of Excel 2007.
We all know that it gives error message when we try to open an Excel 2003 file on excel 2007.

What in the code needs to be changed to have compatibility with Excel 2007 File.....

Should i completely change the code with some other alternative. If so, what is that alternative

I posted this query on many forums including Excel.Programming but with no success so far. Hope i get help here...

Thanks for reading my query...

[Wheres_the_Red]

Don't really know the difference, but all the websites i've gone to present data in a CSV file which will usually open in Excel (unless the user has changed their own PC settings)

Probably no use to you, as it ignores formatting etc, but just a thought. . .


james