problems exporting to xls from asp.net

degel

23y2.4k.NET

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!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

chrishornberger23y ago
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.
degel23y ago
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