Dynamic HTML table

bonekrusher · September 22nd, 2006, 05:48 PM

Hi All,

I am having trouble parsing an XML table into an HTML Table. Here is my XML code:

Code:

                    <table border="7" width="100%">
                        <tbody>
                            <tr>
                                <td width="171">Test</td>
                                <td>TEST</td>
                                <td>TEST a agian</td>
                            </tr>
                            <tr>
                                <td width="171">ok this is good</td>
                                <td>more</td>
                                <td/>
                            </tr>
                            <tr>
                                <td width="171"/>
                                <td/>
                                <td/>
                            </tr>
                        </tbody>
                    </table>

and here is the XSLT template:

Code:

<xsl:template match="JBU:table">
            <html>
                <head>
                    <title/>
                </head>
                <body>
                    <table border="@border">
                        <tbody>
                            <tr>
                                <td>
                                    <xsl:apply-templates/>
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </body>
            </html>
    </xsl:template>

The xml table is dynamic as well as the atributes (width, border etc..)
The code puts all the data in one cell. Based on the XML I posted it should produce 3 rows and 3 columns.

Thanks for the help.
Bones

bonekrusher · September 23rd, 2006, 12:40 PM

Ok, I was able to do it, but how do I make the attributes of the JBU:table values for the table.

For example: border style, BGcolor etc..

Here is my XSLT

Code:

    <xsl:template match="JBU:table">
        <xsl:for-each select="JBU:tbody">
            <table border="?????????">
                <xsl:for-each select="JBU:tr">
                    <tr bgcolor="??????">
                        <xsl:for-each select="JBU:td">
                            <td>
                                <xsl:value-of select="."/>
                            </td>
                        </xsl:for-each>
                    </tr>
                </xsl:for-each>
            </table>
        </xsl:for-each>
    </xsl:template>

here are my attributes for JBU:table:

            <xs:attribute name="align" type="xs:string"/>
            <xs:attribute name="border"/>
            <xs:attribute name="cellpadding"/>
            <xs:attribute name="bgcolor"/>
            <xs:attribute name="width"/>
            <xs:attribute name="cellspacing"/>
            <xs:attribute name="frame"/>
            <xs:attribute name="rules"/>

joefawcett · September 23rd, 2006, 12:55 PM

Why is the xsl:for-each select="JBU:tbody" outside the table border="?????????", do you want one table per JBU:tbody? Just move it up one level, or remove it, and insert the border using an attribute value template:

Code:

<xsl:template match="JBU:table">
  <table border="{@border}">

--

Joe (Microsoft MVP - XML)

bonekrusher · September 23rd, 2006, 01:27 PM

Joe,

Once again thank you for the help. Moving the JBU:tbody up one level did the trick. I cant thank you enough.

Thanks

Bones