Okay, sorry if this is not the right place, but I have a question about Excel spreadsheets. I work for a pretty big CF House in DC Metro, we create/maint. multiple data collection systems for various Fed Agencies. I am creating a small reporting intranet in .NET as per new requirements. Could one of you Guru's help me out with the below. Thanks in advance. In, CF you can create Excel Spreadsheets from and html table with column headers as the Cell header. All you have to to is output the table to the page, and wrap in with the following call This will create a excel spreadsheet for a client to download. Now heres my question. Is it this easy in C# .NET or is there a simple object to call to get this done? Or, am I doomed to some work around for this. Thanks

You can export a GridView to Excel: http://mattberseth.com/blog/2007/04/export_gridview_to_excel_1.html

 

Okay, I found this. If you are using Response.write for your output. (This is how I did it) Then the following code before you loop through the table works like the cf code I posted. Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("content-disposition","attachment;filename=myExcellspredsheet.xls"); Roger