XSLT Generate Dynamic Rows and Columns for Apache FOP

For the following xml file, i need to generate an xsl-fo file to be converted into pdf.

I am new to style sheets and struggling to create dynamic table. Please help.

Also, the width for each column varies,based on the column.How would i include this into the code?

The Column Headers and Column Values are dynamically populated in the xml file. Below is a sample.

Can anybody please help in generating xsl-fo or xslt code?

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

    <ColumnHeaders>
       <ColumnHeader>
           <Name>Col-Header1</Name>
           <Width>5</Length>
       </ColumnHeader>
       <ColumnHeader>
           <Name>Col-Header2</Name>
           <Width>10</Length>
       </ColumnHeader>
       <ColumnHeader>
           <Name>Col-Header3</Name>
           <Width>8</Length>
        </ColumnHeader>
    </ColumnHeaders>

<Rows>
       <Row>
          <Column>Row1-Col1</Column>
          <Column>Row1-Col2</Column>
          <Column>Row1-Col3</Column>              
       </Row>
       <Row>
          <Column>Row2-Col1</Column>
          <Column>Row2-Col2</Column>
          <Column>Row2-Col3</Column>
       </Row>
    </Rows>
</ReportData>

Solution

This should get you started. I used cm for the column width and the page is 11" x 8.5" (landscape) so the table would fit on the page. This should be easy for you to change.

XML Input (fixed to be well-formed)

<ReportData>

    <ColumnHeaders>
        <ColumnHeader>
            <Name>Col-Header1</Name>
            <Width>5</Width>
        </ColumnHeader>
        <ColumnHeader>
            <Name>Col-Header2</Name>
            <Width>10</Width>
        </ColumnHeader>
        <ColumnHeader>
            <Name>Col-Header3</Name>
            <Width>8</Width>
        </ColumnHeader>
    </ColumnHeaders>

    <Rows>
        <Row>
            <Column>Row1-Col1</Column>
            <Column>Row1-Col2</Column>
            <Column>Row1-Col3</Column>              
        </Row>
        <Row>
            <Column>Row2-Col1</Column>
            <Column>Row2-Col2</Column>
            <Column>Row2-Col3</Column>
        </Row>
    </Rows>
</ReportData>

XSLT 1.0

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format">
    <xsl:output indent="yes"/>
    <xsl:strip-space elements="*"/>

    <xsl:template match="/">
        <fo:root>
            <fo:layout-master-set>
                <fo:simple-page-master master-name="my-page" page-height="8.5in" page-width="11in">
                    <fo:region-body margin="1in" margin-top="1.5in" margin-bottom="1.5in"/>
                </fo:simple-page-master>
            </fo:layout-master-set>
            <fo:page-sequence master-reference="my-page">
                <fo:flow flow-name="xsl-region-body">
                    <xsl:apply-templates/>
                </fo:flow>
            </fo:page-sequence>
        </fo:root>
    </xsl:template>

    <xsl:template match="ReportData">
        <fo:table>
            <fo:table-header>
                <fo:table-row>
                    <xsl:apply-templates select="ColumnHeaders/ColumnHeader"/>                  
                </fo:table-row>
            </fo:table-header>
            <fo:table-body>
                <xsl:apply-templates select="Rows/Row"/>
            </fo:table-body>
        </fo:table>
    </xsl:template>

    <xsl:template match="ColumnHeader">
        <fo:table-cell width="{Width}cm" border="solid black 1px" padding="2px" font-weight="bold" text-align="center">
            <fo:block><xsl:value-of select="Name"/></fo:block>
        </fo:table-cell>
    </xsl:template>

    <xsl:template match="Row">
        <fo:table-row>
            <xsl:apply-templates/>
        </fo:table-row>
    </xsl:template>

    <xsl:template match="Column">
        <fo:table-cell border="solid black 1px" padding="2px">
            <fo:block><xsl:value-of select="."/></fo:block>
        </fo:table-cell>
    </xsl:template>     

</xsl:stylesheet>

XSL-FO Output

<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format">
   <fo:layout-master-set>
      <fo:simple-page-master master-name="my-page" page-height="8.5in" page-width="11in">
         <fo:region-body margin="1in" margin-top="1.5in" margin-bottom="1.5in"/>
      </fo:simple-page-master>
   </fo:layout-master-set>
   <fo:page-sequence master-reference="my-page">
      <fo:flow flow-name="xsl-region-body">
         <fo:table>
            <fo:table-header>
               <fo:table-row>
                  <fo:table-cell width="5cm"
                                 border="solid black 1px"
                                 padding="2px"
                                 font-weight="bold"
                                 text-align="center">
                     <fo:block>Col-Header1</fo:block>
                  </fo:table-cell>
                  <fo:table-cell width="10cm"
                                 border="solid black 1px"
                                 padding="2px"
                                 font-weight="bold"
                                 text-align="center">
                     <fo:block>Col-Header2</fo:block>
                  </fo:table-cell>
                  <fo:table-cell width="8cm"
                                 border="solid black 1px"
                                 padding="2px"
                                 font-weight="bold"
                                 text-align="center">
                     <fo:block>Col-Header3</fo:block>
                  </fo:table-cell>
               </fo:table-row>
            </fo:table-header>
            <fo:table-body>
               <fo:table-row>
                  <fo:table-cell border="solid black 1px" padding="2px">
                     <fo:block>Row1-Col1</fo:block>
                  </fo:table-cell>
                  <fo:table-cell border="solid black 1px" padding="2px">
                     <fo:block>Row1-Col2</fo:block>
                  </fo:table-cell>
                  <fo:table-cell border="solid black 1px" padding="2px">
                     <fo:block>Row1-Col3</fo:block>
                  </fo:table-cell>
               </fo:table-row>
               <fo:table-row>
                  <fo:table-cell border="solid black 1px" padding="2px">
                     <fo:block>Row2-Col1</fo:block>
                  </fo:table-cell>
                  <fo:table-cell border="solid black 1px" padding="2px">
                     <fo:block>Row2-Col2</fo:block>
                  </fo:table-cell>
                  <fo:table-cell border="solid black 1px" padding="2px">
                     <fo:block>Row2-Col3</fo:block>
                  </fo:table-cell>
               </fo:table-row>
            </fo:table-body>
         </fo:table>
      </fo:flow>
   </fo:page-sequence>
</fo:root>

PDF Output

enter image description here