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:
Unsolved 
