Hi, my problem:
I need to export data in a GridView to excel without having office installed on the <nobr>server</nobr>. I need to do this with both freezing a row so it will show on every <nobr>page</nobr> when printed. This can be accomplished in excel 2007 using "Print Titles". The other thing that's <nobr>required</nobr> is that grouping(outlining ) is enabled with multiple levels. This can be accomplished in excel 2007 by going into the "Data" tab and clicking "Group".
I have tried to methods to accomplish this. The problem with the first is that I can't seem to freeze the header. The problem with the second is that I can't seem to enable outlining.
The first method involved using an <nobr>HTML</nobr> table. The second method involved using openXML. In both methods I used the ASP.NET response property. to clear the <nobr>content</nobr>(Response.ClearCont<wbr>ent()), add the header Response.AddHeader("conten<wbr>t-disposit<wbr>ion", attachment; filename=someName.xls), content type(Response.ContentType = "<nobr>application</nobr>/ms-excel"), write out the HTML using Response.Write(tableHtml),<wbr> and then finally end the response using Response.End.
So my question is how can I accomplish what I need without office being installed on the server and without using third party controls.
I need to export data in a GridView to excel without having office installed on the <nobr>server</nobr>. I need to do this with both freezing a row so it will show on every <nobr>page</nobr> when printed. This can be accomplished in excel 2007 using "Print Titles". The other thing that's <nobr>required</nobr> is that grouping(outlining ) is enabled with multiple levels. This can be accomplished in excel 2007 by going into the "Data" tab and clicking "Group".
I have tried to methods to accomplish this. The problem with the first is that I can't seem to freeze the header. The problem with the second is that I can't seem to enable outlining.
The first method involved using an <nobr>HTML</nobr> table. The second method involved using openXML. In both methods I used the ASP.NET response property. to clear the <nobr>content</nobr>(Response.ClearCont<wbr>ent()), add the header Response.AddHeader("conten<wbr>t-disposit<wbr>ion", attachment; filename=someName.xls), content type(Response.ContentType = "<nobr>application</nobr>/ms-excel"), write out the HTML using Response.Write(tableHtml),<wbr> and then finally end the response using Response.End.
So my question is how can I accomplish what I need without office being installed on the server and without using third party controls.
