ansaurus

Question

XSLT to flatten XML hierarchy to HTML table

Answer 1

+3 A:

It's not quite what you need (because it leaves a jagged table) but it'll still work in html

<xsl:template match="/">
    <html>
     <head>
     </head>
     <body>
      <table>
       <xsl:apply-templates select="//node" mode="row" />
      </table>
     </body>
    </html>
</xsl:template>

<xsl:template match="node" mode="row">
    <tr>
     <xsl:apply-templates select="ancestor-or-self::node" mode="popcell"/> 
     <xsl:apply-templates select="node[1]" mode="emptycell"/>
    </tr>
</xsl:template>

<xsl:template match="node" mode="popcell">
    <td><xsl:value-of select="@text"/></td>
</xsl:template>

<xsl:template match="node" mode="emptycell">
    <td></td>
    <xsl:apply-templates select="node[1]" mode="emptycell"/>
</xsl:template>

Version 2: Well I'm considerably less self-satisfied with it :P , but the following removes the jaggedness:

<xsl:variable name="depth">
    <xsl:for-each select="//node">
     <xsl:sort select="count(ancestor::node)" data-type="number" order="descending"/>
     <xsl:if test="position()=1">
      <xsl:value-of select="count(ancestor::node)+1"/>
     </xsl:if>
    </xsl:for-each>
</xsl:variable>

<xsl:template match="/">
    <html>
     <head>
     </head>
     <body>
      <table>
       <xsl:apply-templates select="//node" mode="row" />
      </table>
     </body>
    </html>
</xsl:template>

<xsl:template match="node" mode="row">
    <tr>
     <xsl:apply-templates select="ancestor-or-self::node" mode="popcell"/>
     <xsl:call-template name="emptycells">
      <xsl:with-param name="n" select="($depth)-count(ancestor-or-self::node)"/>
     </xsl:call-template>
     <td><xsl:value-of select="@value"/></td>
    </tr>
</xsl:template>

<xsl:template match="node" mode="popcell">
    <td><xsl:value-of select="@text"/></td>
</xsl:template>

<xsl:template name="emptycells">
    <xsl:param name="n" />
    <xsl:if test="$n &gt; 0">
     <td></td> 
     <xsl:call-template name="emptycells">
      <xsl:with-param name="n" select="($n)-1"/>
     </xsl:call-template>
    </xsl:if>
</xsl:template>

annakata 2009-06-04 11:12:02

+1 This is an amazing xslt :)

Rashmi Pandit 2009-06-04 11:22:58

Thanks :) Sometimes the elegance of XSLT really is astonishing.

annakata 2009-06-04 11:28:33

Hi annakata, thanks for this! It's close to what I need, unfortunately the jagged table is a problem. In my first draft of the question I simplified my problem. I've amended it now, so the reason I can't have jagged edges should be clear.

Matt 2009-06-04 11:39:51

Bah, you've ruined my beautiful XSL.

annakata 2009-06-04 12:04:33

Annakata, so sorry for ruining your beautiful XSL, but your 2nd version does exactly what I need - thank you so much!

Matt 2009-06-04 13:12:00

Answer 2

A:

This XSLT 1.0 solution would do it.

produces a well-formed HTML table
no recursion used

XSLT code:

<xsl:stylesheet
  version="1.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>

  <xsl:output method="xml" indent="yes" omit-xml-declaration="yes" />

  <!-- some preparation -->
  <xsl:variable name="vAllNodes" select="//node" />

  <!-- find out the deepest nested node -->
  <xsl:variable name="vMaxDepth">
    <xsl:for-each select="$vAllNodes">
      <xsl:sort 
        select="count(ancestor::node)" 
        data-type="number" 
        order="descending" 
      />
      <xsl:if test="position() = 1">
        <xsl:value-of select="count(ancestor-or-self::node)" />
      </xsl:if>
    </xsl:for-each>
  </xsl:variable>

  <!-- select a list of nodes, merely to iterate over them -->
  <xsl:variable name="vIteratorList" select="
    $vAllNodes[position() &lt;= $vMaxDepth]
  " />

  <!-- build the table -->
  <xsl:template match="/">
    <table>
      <!-- the rows will be in document order -->
      <xsl:apply-templates select="$vAllNodes" />
    </table>
  </xsl:template>

  <!-- build the rows -->
  <xsl:template match="node">
    <xsl:variable name="self" select="." />
    <tr>
      <!-- iteration instead of recursion -->
      <xsl:for-each select="$vIteratorList">
        <xsl:variable name="vPos" select="position()" />
        <td>
          <!-- the ancestor axis is indexed the other way around -->
          <xsl:value-of select="
            $self/ancestor-or-self::node[last() - $vPos + 1]/@text
          " />
        </td>
      </xsl:for-each>
      <td>
        <xsl:value-of select="@value" />
      </td>
    </tr>
  </xsl:template>

</xsl:stylesheet>

Output:

<table>
  <tr>
    <td>a</td>
    <td></td>
    <td></td>
    <td></td>
    <td>1</td>
  </tr>
  <tr>
    <td>a</td>
    <td>gga</td>
    <td></td>
    <td></td>
    <td>5</td>
  </tr>
  <tr>
    <td>a</td>
    <td>gga</td>
    <td>dh</td>
    <td></td>
    <td>9</td>
  </tr>
  <tr>
    <td>a</td>
    <td>gga</td>
    <td>dh</td>
    <td>tyfg</td>
    <td>4</td>
  </tr>
  <tr>
    <td>a</td>
    <td>dfhgf</td>
    <td></td>
    <td></td>
    <td>7</td>
  </tr>
  <tr>
    <td>a</td>
    <td>dfhgf</td>
    <td>fdsg</td>
    <td></td>
    <td>2</td>
  </tr>
</table>

Tomalak 2009-06-04 12:21:42

Thanks for this Tomalak, it works very well. I made one tiny change to get the output I wanted -<xsl:value-of select="$vNodes[last() - $vPos + 1]/@text" />changed to:<xsl:value-of select="$vNodes[$vPos]/@text" />Otherwise the text cells in the row are in reverse order (i.e. leaf node text is in the leftmost column)

Matt 2009-06-04 13:16:54

Actually, this ought not to be happening. $vNodes is made from the ancestor axis, meaning that $vNodes[1] should be the leaf. What XSLT processor are you using?

Tomalak 2009-06-04 13:43:24

Visual Studio 2008

Matt 2009-06-04 13:48:15

Hm. I've changed it so that it uses the "ancestor-or-self" axis directly instead of a variable. Can you try again?

Tomalak 2009-06-04 13:51:38

I tried the change and now what I see is that every row in the output table contains the same text cells. The text in these cells corresponds to whatever the text of the longest path in the tree is. Hope I've explained that clearly!

Matt 2009-06-04 14:10:51

Whoops, my bad. This has been fixed, try again.

Tomalak 2009-06-04 14:55:02

ansaurus

tags:

views:

answers:

XSLT to flatten XML hierarchy to HTML table

related questions