Subject: RE: [xsl] XML content check against the ms-excel content From: "G. Ken Holman" <gkholman@xxxxxxxxxxxxxxxxxxxx> Date: Sat, 28 Nov 2009 12:53:43 +0530 |
Here listed my details,
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.
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: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>
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">
-- 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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] XML content check against, Selvaganesh | Thread | RE: [xsl] XML content check against, Selvaganesh |
RE: [xsl] XML content check against, Selvaganesh | Date | RE: [xsl] XML content check against, Selvaganesh |
Month |