Export transformed XML to Excel

[Guest]

I have a a report that I want to be opened by Excel. It is a simple HTML table

I have set Response.ContentType = "application/ms-excel". I have produced the HTML table by transforming SQL Server XML to HTML by using an asp:xml object and an XSL transform

The page opens in Excel but does not display the data. When i save and imspect source for this page all seams fine there is a simple html table preceeded by "<?xml version="1.0" encoding="utf-8"?>". When i remove this tag mannualy then save and reopen the file with excel it opens correctly

I have tried this office 2000 with no problems at all. I cannot remove the xml tag as if i leave it out of the xsl the the asp:xml object rightly puts it back

Can anyone tell me what the problem with this tag is

Many Thanks
Nick

 

[Steve C. Orr [MVP, MCSD]]

Read this article:
http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net

I have a a report that I want to be opened by Excel. It is a simple HTML table.

I have set Response.ContentType = "application/ms-excel". I have produced

the HTML table by transforming SQL Server XML to HTML by using an asp:xml
object and an XSL transform.

The page opens in Excel but does not display the data. When i save and

imspect source for this page all seams fine there is a simple html table

I have tried this office 2000 with no problems at all. I cannot remove

the xml tag as if i leave it out of the xsl the the asp:xml object rightly
puts it back.

 

[Guest]

Thanks for the quick reply Steve

I had already read your article; in fact it was the last one I read before posting this question

As far as I can see I am producing a HTML table just like in your example. The only difference is that I am using an XSL transform and an asp:xml object to create it. This leaves in the HTML an "<?xml version="1.0" encoding="utf-8"?>" tag just preceding the transformed output

It seams to be this tag that prevents Excel 2002 from rendering the table. If I download and remove this tag and then open with Excel 2002 it renders fine. It also renders correctly when opened with Excel 2000