Re: Converting XML spreadsheet to native Excel in ASP.NET

[Ken Cox [Microsoft MVP]]

Hi Magdelin,

For very old versions of Excel, the safest format is CSV.

For older versions, you can use Datagrid HTML tables.
http://support.microsoft.com/default.aspx?scid=kb;en-us;317719

For recent versions, you can use a library like this:
http://www.asp.net/ControlGallery/ControlDetail.aspx?Control=1977&tabindex=2

If you need to go to the real Excel native format, you'll probably need a
3rd party component:

http://www.asp.net/ControlGallery/ControlDetail.aspx?Control=1144&tabindex=2
http://www.asp.net/ControlGallery/ControlDetail.aspx?Control=1002&tabindex=2

Ken
MVP [ASP.NET]

 

[Steven Cheng[MSFT]]

Hi Magdelin,

I think Ken has provided almost all the current existing means to expose
excel spreadsheet in ASP.NET and here is another good tech article writen
by Steven C:

#Export to Excel
http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so
_l.asp

Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx