RE: [xsl] XML content check against the ms-excel content

["G. Ken Holman" <gkholman@xxxxxxxxxxxxxxxxxxxx>]

At 2009-11-28 12:21 +0530, Selvaganesh wrote:
> Here listed my details,

Thank you for being explicit.  This made answering easy.

> This is my input XML file:
> ...
> This is my input Excel XML file:
> ...
> I expect the output:
>
> <b><span style="background-color: Green">mulberrytech</span></b>
> <b><span style="background-color: Red">xsltech1</span></b>
>
> How to write the xslt coding.

You don't say if you needed the answer in XSLT 2 or XSLT 1, so both 
answers are below.

Note that because the processor will cache the referenced document, 
there is no performance penalty using the document() function repeatedly.

The answer involves using a key for a lookup table and looking inside 
the Excel file while reading the input file.

I hope this helps.

. . . . . . . . .  Ken

t:\ftemp>type reference.xml
<root>
    <reference>
        <id>ID001</id>
        <title>mulberrytech</title>
    </reference>
    <reference>
        <id>ID002</id>
        <title>xsltech1</title>
    </reference>
</root>

t:\ftemp>type selva.xml
<root>
    <p>
        <reference id="ID001">mulberrytech</reference>
    </p>
    <p>
        <reference id="ID001">xsltech1</reference>
    </p>
</root>

t:\ftemp>call xslt2 selva.xml selva.xsl
<?xml version="1.0" encoding="UTF-8"?>
<b>
   <span style="background-color: Green">mulberrytech</span>
</b>
<b>
   <span style="background-color: Red">xsltech1</span>
</b>
t:\ftemp>type selva.xsl
<?xml version="1.0" encoding="US-ASCII"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
                version="2.0">

<xsl:output indent="yes"/>

<xsl:key name="ref" match="reference" use="title"/>

<xsl:template match="/">
  <xsl:for-each select="*/p">
    <b>
      <span style="background-color: {
                   if( key('ref',reference,doc('reference.xml'))/id =
                       reference/@id )
                   then 'Green' else 'Red'
                   }">
        <xsl:value-of select="reference"/>
      </span>
    </b>
  </xsl:for-each>
</xsl:template>

</xsl:stylesheet>

t:\ftemp>call xslt selva.xml selva1.xsl
<?xml version="1.0" encoding="utf-8"?>
<b>
   <span style="background-color: Green">mulberrytech</span>
</b>
<b>
   <span style="background-color: Red">xsltech1</span>
</b>
t:\ftemp>type selva1.xsl
<?xml version="1.0" encoding="US-ASCII"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
                version="1.0">

<xsl:output indent="yes"/>

<xsl:key name="ref" match="reference" use="title"/>

<xsl:template match="/">
  <xsl:for-each select="*/p">
    <b>
      <span>
        <xsl:attribute name="style">
          <xsl:text>background-color: </xsl:text>
          <xsl:variable name="given" select="reference"/>
          <xsl:for-each select="document('reference.xml')">
            <xsl:choose>
              <xsl:when 
test="key('ref',$given)/id=$given/@id">Green</xsl:when>
              <xsl:otherwise>Red</xsl:otherwise>
            </xsl:choose>
          </xsl:for-each>
        </xsl:attribute>
        <xsl:value-of select="reference"/>
      </span>
    </b>
  </xsl:for-each>
</xsl:template>

</xsl:stylesheet>



--
Vote for your XML training:   http://www.CraneSoftwrights.com/s/i/
Crane Softwrights Ltd.          http://www.CraneSoftwrights.com/s/
Training tools: Comprehensive interactive XSLT/XPath 1.0/2.0 video
Video lesson:    http://www.youtube.com/watch?v=PrNjJCh7Ppg&fmt=18
Video overview:  http://www.youtube.com/watch?v=VTiodiij6gE&fmt=18
G. Ken Holman                 mailto:gkholman@xxxxxxxxxxxxxxxxxxxx
Male Cancer Awareness Nov'07  http://www.CraneSoftwrights.com/s/bc
Legal business disclaimers:  http://www.CraneSoftwrights.com/legal