problems exporting to xls from asp.net

Question

has anyone encountered problems exporting datagrids to xls when using office xp as opposed to office 97? i'm using the following sub: (it works great with office 97 but blows up with office xp) Private Overloads Sub btnExport_Click(ByVal sender As System.Object ByVal e As System.Web.UI.ImageClickEventArgs) Handles btnExport.Click 'export to excel Response.Clear() Response.Buffer = True Response.ContentType = application/vnd.ms-excel Response.Charset =  Me.EnableViewState = False Dim oStringWriter As New System.IO.StringWriter() Dim oHtmlTextWriter As New System.Web.UI.HtmlTextWriter(oStringWriter) Me.ClearControls(dg) dg.RenderControl(oHtmlTextWriter) Response.Write(oStringWriter.ToString()) Response.End() End Sub thanks!

chrishornberger · Answer

csv data is the defacto standard portable mothod of moving excel-like data around. You might want to declare your mime as text/plain and simply put it out as csv.

degel · Answer

oops... forgot where i was for a moment...! here's my subroutine in C# private void btnExport_Click(object sender System.EventArgs e) { //export to excel Response.Clear(); Response.Buffer= true; Response.ContentType = application/vnd.ms-excel; Response.Charset = ; this.EnableViewState = false; System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.ClearControls(dg); dg.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); End Sub