Hi,

 This may sound like a noob question, but I try to transform html into excel compatible format. I have both the data in html and xsl working. The problem is when there is a & sign in the data html, asp.net's transformation object freaks out and throws exception. What do I need to do to escape the character, and other than &, are there any other character I should escape?

Thanks,

for & use &

for < use &lt;

for > use &gt;

for " use &quot;

 actually, any presence of the & sign throws the transformer off. &amp; contains & in the first place!!!

It was tedious, but I wrapped all cell contents with <![CData[ ... ]]>  and it was happy.

Thanks for trying.