Exporting to Excel in ASP.Net

[Michael]

I need to be able to export data from a web form into MS Excel. I know
you can do it with a VB.net windows application, but how can you do it
with an asp.net application using vb.net? Any help would be
appreciated!

Michael

 

[Steve C. Orr [MVP, MCSD]]

There are many different ways you can go about exporting web form data to
Excel.
This article discusses the topic in detail:
http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp

 

[Rick Spiewak]

Interesting article, but I wouldn't use Excel directly from ASP.NET.
Instead, if you have your data in an HTML table (a datagrid, for example)
you can download to Excel with this:

Response.ContentType = "application/vnd.ms-excel"
Response.Charset = String.Empty

Also, set .EnableViewState = False for your datagrid.