[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: XML content check against the ms-excel content
Hi Ken, Thank you for the help. Thanks lot, Selva -----Original Message----- From: G. Ken Holman [mailto:gkholman@xxxxxxxxxxxxxxxxxxxx] Sent: Saturday, November 28, 2009 12:54 PM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: RE: XML content check against the ms-excel content 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 Confidentiality Notice: This transmittal is a confidential communication. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error and that any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify this office immediately by reply and immediately delete this message and all of its attachments, if any.
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|