XML/XSL Transformation: Tree to Table
Parent page: Generating Test Reports
Today I present XML Tree to HTML Table transformation example.
Here’s our XML record simulating logged test steps.
XML Source
<?xml version="1.0" encoding="utf-8"?> <?xml-stylesheet type="text/xsl" href=".\Tree2Table.xsl"?> <log> <step type="GUI Step"> <description>Pasted data [User1234] in edit box [Username] </description> </step> <step type="GUI Step"> <description>Pasted data [Password1234] in edit box [Password]</description> </step> <step type="GUI Step"> <description>Clicked on button [Login]</description> </step> </log>
Did you notice the following line?
<?xml-stylesheet type=”text/xsl” href=”.\Tree2Table.xsl”?>
This is how we instruct the web browser to use XSL script for visualization of XML data.
Web-page Report
And here’s the source code of the script
XSL Source
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <!-- variables --> <xsl:variable name="CHAR_SPC"> </xsl:variable> <xsl:template match="/"> <html> <head> <title>automation-beyond.com | Tree2Table XML/XSL Transformation Example by </title> </head> <body bgcolor="#c0c0c0"> <H1 align="center">Tree2Table</H1> <H4 align="center">XML/XSL Transformation Example by <A HREF="http://automation-beyond.com/about/"></A></H4> <BR /> <P /> <h3 align="center">Test Steps</h3> <BR /> <TABLE id="automation-beyond-2010" BORDER="1" width="650" align="center"> <TR> <TH width="150">Step Name</TH> <TH width="500">Step Description</TH> </TR> <xsl:for-each select="log/step"> <TR> <TD><xsl:value-of select = "@type" /><xsl:value-of select = "$CHAR_SPC" /></TD> <TD><xsl:value-of select = "description" /><xsl:value-of select = "$CHAR_SPC" /></TD> </TR> </xsl:for-each> </TABLE> <BR /> <div align="center"> <A HREF="http://automation-beyond.com/chapters/tutorials/test-reports/">Home</A> </div> <BR /> </body> </html> </xsl:template> </xsl:stylesheet>
How To
- Define template of a table
- Select XML elements in a lop (with xsl:for-each)
- Insert node values into table cells (with xsl:value-of)
And here is the package containing the original XML and XSL files.
One response to "XML/XSL Transformation: Tree to Table"
Pretty cool Author.
Humm… Thinking now about a certain CSV to XML transformation… :)
[Author's reply. Sh-sh-sh, that’s supposed to be a surprise :) ]