In relation to my last question, what I am trying to do is to export a result set to an excel spread sheet so that the user can save, sort, etc. I have done this with classic asp, I looped through the result set and inserted the values into a table, but first setting the content type to Excel. How would this be done using ASP.NET. I would like to do it the correct way instead of using the way I did it previously.

Any help would be great...
Thanks,

Jim

I am trying to export from .NET to Excel, not the other way around. Thanks

Jim,

The way you did it is no different for ASP.net. Remember that the end result is the same regardless of it being .net. Just like in ASP you would set the content type:

Response.ContentType = "application/vnd.ms-excel"

Do this in page load. You will probably want to purge the response buffer to clean it all out before you write your HTML table.

Here's a sample, and here's the code for it:

<%@ Page Language="vb" AutoEventWireup="true" %>
<script runat="server">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
    If Request("showPlainHTML") Is Nothing Then
        Response.ContentType = "application/vnd.ms-excel"
    End If
End Sub
</script>
<table border="1">
    <tr><td colspan="10"><h1>This is the header</h1></td></tr>
    <tr><td colspan="10" align="center"><a href="webToExcel.aspx?showPlainHTML=true">Show as plain HTML</a></td></tr>
    <tr><td colspan="10" align="center"><a href="webToExcel.aspx">Show in Excel</a></td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td><td>data</td></tr>
    <tr><td colspan="10"><h3>This is the footer</h3></td></tr>
</table>


Peter
------------------------------------------------------
Work smarter, not harder.

Peter thanks,

  I actually found a way to use the datagrid too. But I think your way will work better, more flexability. Thanks for you help!!!

Jim