Migrating from Cold Fusion to ASP.NET

Re: Excell Spreed Sheet on the fly

akulla3D — Tue, 17 Feb 2009 14:43:18 GMT

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

Re: Excell Spreed Sheet on the fly

Mikesdotnetting — Fri, 13 Feb 2009 21:50:01 GMT

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

Excell Spreed Sheet on the fly

akulla3D — Fri, 13 Feb 2009 18:39:53 GMT

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