DaniWeb Forum Index > Software Development > C#

C# RSS

Exprot to Excel in ASP.NET using C#

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2007

Posts: 1

Reputation: amitabhwankhede is an unknown quantity at this point

Solved Threads: 0

amitabhwankhede amitabhwankhede is offline

Offline

Newbie Poster

Exprot to Excel in ASP.NET using C#

Apr 10th, 2007

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

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
 
            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();
            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: