![]() |
![]() | ![]() | ![]() | Altova Mailing List Archives>Archive Index >microsoft.public.xsl Archive Home >Recent entries >Thread Prev - XMl with html tags to Excel? [Thread Next] Re: XMl with html tags to Excel?To: NULL Date: 3/21/2008 4:15:00 PM
FredB wrote:
> <data>
> <item><b>BOLD<b></item> (ignore the non-escaped character for examples
> sake)
> </data>
>
> portion of a sample xsl:
> <Row>
> <Cell ss:StyleID="s80"><data ss:Type="string"> <xsl:value-of
> select="item"/></Data></Cell>
> </Row>
>
> The Resuting data in my spread sheet is literally "<b>BOLD</b>" as opposed
> to the text being bolded.
>
> Is it possible to go straight from html data to the correpsonding format in
> excel?
I don't know whether Excel recognizes HTML elements like 'b', you would
have to ask in an Excel group.
If you want to transform those HTML elements then don't use
<xsl:value-of select="item"/>, instead use <xsl:apply-templates
select="item"/>
and make sure you write templates to transform e.g. 'b' to the
corresponding Excel markup e.g.
<xsl:template match="b">
<!-- put Excel markup here -->
<xsl:apply-templates/>
<!-- put Excel markup here -->
</xsl:template>
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
| ![]() | ![]() | ![]() |
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||||
|
