XSLT Table Transformation

filippo nanni

Hello,
I have a series of xml tables that i should convert to html code -
Here is an Example:

Expand|Select|Wrap|Line Numbers

 <TABELLA data_mod="2008-10-30 12:20:59" id="2903" locale="it_IT" colonne="1" righe="2"

            colonna_1="100%">

            <grown>

                <TAB_2903>

                    <story>

                        <Table xmlns:aid="http://ns.adobe.com/AdobeInDesign/4.0/" aid:table="table"

                            aid:trows="2" aid:tcols="1" summary="NOCHANGE">

                            <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                                larghezza="100%">

                                <_B>

                                    <img_html href="file://./NOME_1.eps" proporzione_x="31"

                                        id="50211557" proporzione_h="32" proporzione_w="32"

                                        alkusetype="3"/>

                                </_B>

                            </Cell>

                            <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                                larghezza="100%">56733</Cell>

                        </Table>

                    </story>

                </TAB_2903>

            </grown>

        </TABELLA>

Every table has a unique ID like </TAB_2903>, </TAB_2904>, etc.
Can anyone help me with this problem?
Thanks to all in advance

Dormilich

what does your html code shall look like? (in other words: a table isn't a table isn't a table)

if you know that, you can "map" your xml data to these html elements/attributes using <xsl:template>. see XSLT @ w3schools

filippo nanni

Hello Dormilich,
the tables have to look like this:

Expand|Select|Wrap|Line Numbers

 <html>

    <body>

        <table>

            <tr>

                <td>

                    <img src="NOME_1.eps"/>

                </td>

            </tr>

            <tr>

                <td>56733</td>

            </tr>

        </table>

    </body>

</html>

But the problem here, is that every table has got a variable number of columns and rows, and the only reference to these seem to be aid:trows and aid:tcols (as a note, these tables are exported from Adobe Indesign).
I think that there would be some sort of recursive function to divide the cells by the values of tcols and trows, but I'm not able to do this.
I also attach other 2 tables so that you can better understand the problem:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="UTF-8"?>

<Root>

    <TABELLA data_mod="2008-10-30 12:20:59" id="2899" locale="it_IT" colonne="3" righe="2"

        colonna_1="33%" colonna_2="33%" colonna_3="33%">

        <grown>

            <TAB_2899>

                <story>

                    <Table xmlns:aid="http://ns.adobe.com/AdobeInDesign/4.0/" aid:table="table"

                        aid:trows="2" aid:tcols="3" summary="NOCHANGE">

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="33%">

                            <_B>

                                <img_html href="file://./NOME_1.eps" proporzione_x="31"

                                    id="50211557" proporzione_h="32" proporzione_w="32"

                                    alkusetype="3"/>

                            </_B>

                        </Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="33%">

                            <_centro>

                                <img_html href="file://./LUNGHEZZA_1.eps" proporzione_x="31"

                                    id="50211532" proporzione_h="34" proporzione_w="55"

                                    alkusetype="3"/>

                            </_centro>

                        </Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="33%">

                            <img_html href="file://./TIPO_1.eps" proporzione_x="31" id="50211586"

                                proporzione_h="78" proporzione_w="79" alkusetype="3"/>

                        </Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="33%">12613</Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="33%">130</Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="33%">ø25 - 1&quot;3/8&quot; Z6</Cell>

                    </Table>

                </story>

            </TAB_2899>

        </grown>

    </TABELLA>

    <TABELLA data_mod="2008-10-30 12:20:58" id="2895" locale="it_IT" colonne="5" righe="2"

        colonna_1="20%" colonna_2="20%" colonna_3="20%" colonna_4="20%" colonna_5="20%">

        <grown>

            <TAB_2895>

                <story>

                    <Table xmlns:aid="http://ns.adobe.com/AdobeInDesign/4.0/" aid:table="table"

                        aid:trows="2" aid:tcols="5" summary="NOCHANGE">

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">

                            <_B>

                                <img_html href="file://./NOME_1.eps" proporzione_x="31"

                                    id="50211557" proporzione_h="32" proporzione_w="32"

                                    alkusetype="3"/>

                            </_B>

                        </Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">

                            <_centro>

                                <img_html href="file://./COPPIA CONTINUA_1.eps" proporzione_x="31"

                                    id="50211518" proporzione_h="84" proporzione_w="85"

                                    alkusetype="3"/>

                            </_centro>

                        </Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">

                            <_centro>

                                <img_html href="file://./RAPPORTO DI MOLTIPLICA_1.eps"

                                    proporzione_x="31" id="50211574" proporzione_h="59"

                                    proporzione_w="60" alkusetype="3"/>

                            </_centro>

                        </Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">

                            <img_html href="file://./MISURA A_1.eps" proporzione_x="31"

                                id="50211536" proporzione_h="57" proporzione_w="57" alkusetype="3"/>

                        </Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">

                            <img_html href="file://./MISURA B_1.eps" proporzione_x="31"

                                id="50211538" proporzione_h="59" proporzione_w="60" alkusetype="3"/>

                        </Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">17644</Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">900</Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">3,1:1</Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">35</Cell>

                        <Cell aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="184"

                            larghezza="20%">10</Cell>

                    </Table>

                </story>

            </TAB_2895>

        </grown>

    </TABELLA>

</Root>

Please let me know if you find a solution to this.
Anyhow, thanks for your support
Filippo

jkmyoung

I see, so your problem is that the cells just come one after each other?

Suggested solution is somewhat like the following:

Expand|Select|Wrap|Line Numbers

 
put xmlns:aid="http://ns.adobe.com/AdobeInDesign/4.0/" in your stylesheet node.
 
<xsl:template match="Table">

  <table>

    <xsl:variable name="cols" select="aid:crows"/>

    <xsl:for-each select="Cell[position() mod $cols = 1]"><!-- get each cell at the start of a row. -->

      <tr><!-- get all cells in this row -->

        <xsl:apply-templates select=".|following-sibling::Cell[position() &lt; $cols]"/> 

      </tr>

    <xsl:for-each>

  </table>

</xsl:template>

XSLT Table Transformation

re: XSLT Table Transformation

re: XSLT Table Transformation

re: XSLT Table Transformation

Similar XML bytes

/bytes/development

/bytes/it

/bytes/about