Scott Hanselman

Exporting tabular data to Excel from ASP.NET

April 21, '03 Comments [5] Posted in Web Services | ASP.NET | XML
Sponsored By

There's a number of ways to "export" data to Excel from an ASP.NET site - some more elegant than others.

  • Gross: You can use ASP.NET to generate a CSV file of Mime Type text/plain or text/csv and write it back to the browser.
  • NOT Gross: You can use ASP.NET to generate an XML-SS (Excel XML Spreadsheet) document and write it back to the browser.
  • Really Easy but not Really XMLy: You can take advantage of the ASP.NET DataGrid's ability to generate HTML tables quickly and return the page with a Mime Type of application/  Here's a great example on how to create these reports
  • Easy but uses 3rd Party Control: Use ExcelWriter on the server side to create the Report.
  • Disgusting: Automate Excel on the ServerSideDon't do this for Pete's Sake.

About Scott

Scott Hanselman is a former professor, former Chief Architect in finance, now speaker, consultant, father, diabetic, and Microsoft employee. He is a failed stand-up comic, a cornrower, and a book author.

facebook twitter subscribe
About   Newsletter
Sponsored By
Hosting By
Dedicated Windows Server Hosting by SherWeb
Tuesday, 22 April 2003 07:03:17 UTC
OK, Scott, why do you find the XML approach "less gross"? It seems like the cleanest solution to me.
Tuesday, 22 April 2003 15:42:13 UTC
Oops...I meant to write NOT Gross.
Thursday, 11 March 2004 13:53:19 UTC
You say not to use automation. How am I supposed to create multiple worksheets and manipulate them? Automation seems to be the only way to do it and I have an application that needs to create a workbook and add three different worksheets from three different datasets. If you could explain how to do this without having to use automation and NOT using 3rd-party controls, I would appreciate it.

Ivan Samuelson
Thursday, 03 June 2004 03:27:32 UTC
How did you know that I need to do this? There must be a hole in my tin-foil hat again.

Seriously, I appreciate the post and will put it to good use.

Thursday, 03 November 2005 06:25:18 UTC
Comments are closed.

Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.