Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically Create excel file
I need to export data in a GridView to excel without having office installed on the server. I need to do this with both freezing a row so it will show on every page when printed. This can be accomplished in excel 2007 using "Print Titles". The other thing that's required 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 HTML table. The second method involved using openXML. In both methods I used the ASP.NET response property. to clear the content(Response.ClearContent()), add the header Response.AddHeader("content-disposition", attachment; filename=someName.xls), content type(Response.ContentType = "application/ms-excel"), write out the HTML using Response.Write(tableHtml), 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Macro Dynamically | Excel Programming | |||
How to write a data in Excel file dynamically from C / VC++ | Excel Programming | |||
How to write a data in Excel file dynamically from C / VC++ | Excel Programming | |||
Dynamically create worksheets in Excel based off existing data? | Excel Discussion (Misc queries) | |||
dynamically create userform | Excel Programming |