Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Alternate table row color via XSL in generating pdf

Tags:

xslt

I am very new to XSLT. I want to implement alternate colors in my table rows.The Even rows should be displayed - #EDF2F8 and Odd rows - #A7BFDE.

I have a xsl which looks like :

<xsl:apply-templates select="records"/>

<xsl:template match="records">
  <fo:table-row>
    <fo:table-cell>
            <xsl:value-of select="Firstname"/>
    </fo:table-cell>
    <fo:table-cell>
            <xsl:value-of select="lastname"/>
    </fo:table-cell>
    <fo:table-cell>
            <xsl:value-of select="Phone number"/>
    </fo:table-cell>
  </fo:table-row>

I tried using the below code but it did not work:

<xsl:variable name="css-class">
<xsl:choose>
<xsl:when test="position() mod 2 = 0">
<xsl:attribute name="bgcolor">#EDF2F8</xsl:attribute>
</xsl:when>
<xsl:otherwise>
<xsl:attribute name="bgcolor">#A7BFDE</xsl:attribute>
</xsl:otherwise>
</xsl:choose>
</xsl:variable>

<fo:table-row class="{$css-class}">
   <fo:table-cell>
            <xsl:value-of select="Firstname"/>
    </fo:table-cell>
    <fo:table-cell>
            <xsl:value-of select="lastname"/>
    </fo:table-cell>
    <fo:table-cell>
            <xsl:value-of select="Phone number"/>
    </fo:table-cell>
  </fo:table-row>

I really appreciate any help on this.

Part of my code which I edited to and it did not work either :

<xsl:template match="records">
<xsl:variable name="bgclr">
<xsl:choose>
<xsl:when test="position() mod 2 = 0">#A7BFDE</xsl:when>
<xsl:otherwise>#EDF2F8</xsl:otherwise>
</xsl:choose>
</xsl:variable>
<fo:table-row bgcolor="{$bgclr}">
<fo:table-cell padding-top="0pt" padding-left="5.4pt" padding-bottom="0pt" padding-right="5.4pt" border-left-style="solid" border-right-style="solid" border-left-color="#FFFFFF" border-right-color="#FFFFFF" border-left-width="0.5pt" border-right-width="1.5pt" border-top-style="solid" border-bottom-style="solid" border-top-color="#FFFFFF" border-bottom-color="#FFFFFF" border-top-width="0.5pt" border-bottom-width="0.5pt">
<fo:block xmlns:st1="urn:schemas-microsoft-com:office:smarttags" space-after="10pt" space-after.conditionality="retain" line-height="1.4911" font-size="9pt" language="EN-US" text-align="left" font-weight="bold" linefeed-treatment="preserve">
<fo:leader leader-length="0pt"/>
<xsl:value-of select="name"/>
</fo:block>
</fo:table-cell>

.....<-- Similar more table cells -->

Edit 3 The input data is in JSON format like :

"pdfrequest" : {
        "records" : [{
                "firstname" : "--",
                "lastname" : "--",
                "phoneno" : "--",
                }]
}

Edit 4. Below is the sample XSL which I am using. This transforms the JSON to pdf. Any help is appreciated.

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" version="1.1" exclude-result-prefixes="fo">
<xsl:output method="xml" version="1.0" omit-xml-declaration="no" indent="yes"/>
<xsl:template match="pdfrequest">
<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml">
<fo:layout-master-set xmlns:rx="http://www.renderx.com/XSL/Extensions" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:wx="http://schemas.microsoft.com/office/word/2003/auxHint" xmlns:aml="http://schemas.microsoft.com/aml/2001/core" xmlns:w10="urn:schemas-microsoft-com:office:word" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882">
<fo:simple-page-master master-name="section1-first-page" page-width="12in" page-height="8.5in" margin-top="36pt" margin-bottom="36pt" margin-right="10pt" margin-left="10pt">
<fo:region-body margin-top="10pt" margin-bottom="70pt"/>
<fo:region-before region-name="first-page-header" extent="11in"/>
<fo:region-after region-name="first-page-footer" extent="11in" display-align="after"/>
</fo:simple-page-master>
<fo:simple-page-master master-name="section1-odd-page" page-width="12in" page-height="8.5in" margin-top="36pt" margin-bottom="36pt" margin-right="10pt" margin-left="10pt">
<fo:region-body margin-top="49pt" margin-bottom="61pt"/>
<fo:region-before region-name="odd-page-header" extent="11in"/>
<fo:region-after region-name="odd-page-footer" extent="11in" display-align="after"/>
</fo:simple-page-master>
<fo:simple-page-master master-name="section1-even-page" page-width="12in" page-height="8.5in" margin-top="36pt" margin-bottom="36pt" margin-right="10pt" margin-left="10pt">
<fo:region-body margin-top="49pt" margin-bottom="61pt"/>
<fo:region-before region-name="even-page-header" extent="11in"/>
<fo:region-after region-name="even-page-footer" extent="11in" display-align="after"/>
</fo:simple-page-master>
<fo:page-sequence-master master-name="section1-page-sequence-master">
<fo:single-page-master-reference master-reference="section1-first-page"/>
<fo:repeatable-page-master-alternatives>
<fo:conditional-page-master-reference odd-or-even="odd" master-reference="section1-odd-page"/>
<fo:conditional-page-master-reference odd-or-even="even" master-reference="section1-even-page"/>
</fo:repeatable-page-master-alternatives>
</fo:page-sequence-master>
</fo:layout-master-set>
<fo:page-sequence xmlns:rx="http://www.renderx.com/XSL/Extensions" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:wx="http://schemas.microsoft.com/office/word/2003/auxHint" xmlns:aml="http://schemas.microsoft.com/aml/2001/core" xmlns:w10="urn:schemas-microsoft-com:office:word" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" master-reference="section1-page-sequence-master" format="1">
</fo:static-content>
<fo:static-content flow-name="xsl-footnote-separator">
<fo:block>
<fo:leader leader-pattern="rule" leader-length="144pt" rule-thickness="0.5pt" rule-style="solid" color="gray"/>
</fo:block>
</fo:static-content>
<fo:flow flow-name="xsl-region-body">
<fo:block widows="2" orphans="2" font-size="10pt" line-height="1.147" white-space-collapse="false">
<fo:marker xmlns:st1="urn:schemas-microsoft-com:office:smarttags" marker-class-name="first-page-header">
<fo:block space-after="0pt" space-after.conditionality="retain" line-height="1.147" font-size="11pt" language="EN-US" start-indent="-40.5pt">
<fo:leader/>
</fo:block>
</fo:marker>
<fo:marker xmlns:st1="urn:schemas-microsoft-com:office:smarttags" marker-class-name="first-page-footer">
<fo:block space-after="0pt" space-after.conditionality="retain" line-height="1.147" font-size="11pt" language="EN-US">
<fo:leader/>
</fo:block>
</fo:marker>
<fo:marker xmlns:st1="urn:schemas-microsoft-com:office:smarttags" marker-class-name="even-page-header"/>
<fo:marker xmlns:st1="urn:schemas-microsoft-com:office:smarttags" marker-class-name="even-page-footer"/>
<fo:block space-after="10pt" space-after.conditionality="retain" line-height="1.3190500000000002" font-size="16pt" language="EN-US" start-indent="0pt" space-before="18pt" space-before.conditionality="retain" font-weight="bold" color="#0070C0">
<fo:inline font-weight="bold" color="#0070C0" font-size="16pt">
<fo:leader leader-length="0pt"/>
Summary Report
</fo:inline>
</fo:block>
<fo:table xmlns:st1="urn:schemas-microsoft-com:office:smarttags" language="EN-US" start-indent="0pt" border-top-style="solid" border-top-color="#FFFFFF" border-top-width="1pt" border-left-style="solid" border-left-color="#FFFFFF" border-left-width="1pt" border-bottom-style="solid" border-bottom-color="#FFFFFF" border-bottom-width="1pt" border-right-style="solid" border-right-color="#FFFFFF" border-right-width="1pt" table-layout="fixed" table-omit-header-at-break="false">
<fo:table-column column-number="1" column-width="76.7pt"/>
<fo:table-column column-number="2" column-width="76.7pt"/>
<fo:table-column column-number="3" column-width="76.7pt"/>
<fo:table-header start-indent="0pt" end-indent="0pt">
<fo:table-row>
<fo:table-cell number-columns-spanned="9" padding-top="0pt" padding-left="5.4pt" padding-bottom="0pt" padding-right="5.4pt" border-left-style="solid" border-right-style="solid" border-left-color="#FFFFFF" border-right-color="#FFFFFF" border-left-width="0.5pt" border-right-width="0.5pt" border-top-style="solid" border-bottom-style="solid" border-top-color="#FFFFFF" border-bottom-color="#FFFFFF" border-top-width="0.5pt" border-bottom-width="1.5pt" background-color="#4F81BD">
<fo:block space-after="0pt" space-after.conditionality="retain" line-height="1.147" font-size="9pt" language="EN-US" space-before="6pt" space-before.conditionality="retain" text-align="left" font-weight="bold" color="#FFFFFF">
<fo:inline font-weight="bold" color="#FFFFFF" font-size="9pt">
<fo:leader leader-length="0pt"/>
Section 1
</fo:inline>
</fo:block>
</fo:table-cell>
<fo:table-cell number-columns-spanned="2" padding-top="0pt" padding-left="5.4pt" padding-bottom="0pt" padding-right="5.4pt" border-left-style="solid" border-right-style="solid" border-left-color="#FFFFFF" border-right-color="#FFFFFF" border-left-width="0.5pt" border-right-width="0.5pt" border-top-style="solid" border-bottom-style="solid" border-top-color="#FFFFFF" border-bottom-color="#FFFFFF" border-top-width="0.5pt" border-bottom-width="1.5pt" background-color="#4F81BD">
<fo:block space-after="0pt" space-after.conditionality="retain" line-height="1.147" font-size="9pt" language="EN-US" space-before="6pt" space-before.conditionality="retain" text-align="left" font-weight="bold" color="#FFFFFF">
<fo:inline font-weight="bold" color="#FFFFFF" font-size="9pt">
<fo:leader leader-length="0pt"/>
Section 2
</fo:inline>
</fo:block>
</fo:table-cell>
</fo:table-row>
<fo:table-row>
<fo:table-cell padding-top="0pt" padding-left="5.4pt" padding-bottom="0pt" padding-right="5.4pt" border-left-style="solid" border-right-style="solid" border-left-color="#FFFFFF" border-right-color="#FFFFFF" border-left-width="0.5pt" border-right-width="0.5pt" border-top-style="solid" border-bottom-style="solid" border-top-color="#FFFFFF" border-bottom-color="#FFFFFF" border-top-width="0.5pt" border-bottom-width="1.5pt" background-color="#4F81BD">
<fo:block space-after="0pt" space-after.conditionality="retain" line-height="1.147" font-size="9pt" language="EN-US" space-before="6pt" space-before.conditionality="retain" text-align="left" font-weight="bold" color="#FFFFFF">
<fo:inline font-weight="bold" color="#FFFFFF" font-size="9pt">
<fo:leader leader-length="0pt"/>
Name
</fo:inline>
</fo:block>
</fo:table-cell>
<fo:table-cell padding-top="0pt" padding-left="5.4pt" padding-bottom="0pt" padding-right="5.4pt" border-left-style="solid" border-right-style="solid" border-left-color="#FFFFFF" border-right-color="#FFFFFF" border-left-width="0.5pt" border-right-width="0.5pt" border-top-style="solid" border-bottom-style="solid" border-top-color="#FFFFFF" border-bottom-color="#FFFFFF" border-top-width="0.5pt" border-bottom-width="1.5pt" background-color="#4F81BD">
<fo:block space-after="0pt" space-after.conditionality="retain" line-height="1.147" font-size="9pt" language="EN-US" space-before="6pt" space-before.conditionality="retain" text-align="left" font-weight="bold" color="#FFFFFF">
<fo:inline font-weight="bold" color="#FFFFFF" font-size="9pt">
<fo:leader leader-length="0pt"/>
Phone no
</fo:inline>
</fo:block>
</fo:table-cell>
<fo:table-cell padding-top="0pt" padding-left="5.4pt" padding-bottom="0pt" padding-right="5.4pt" border-left-style="solid" border-right-style="solid" border-left-color="#FFFFFF" border-right-color="#FFFFFF" border-left-width="0.5pt" border-right-width="0.5pt" border-top-style="solid" border-bottom-style="solid" border-top-color="#FFFFFF" border-bottom-color="#FFFFFF" border-top-width="0.5pt" border-bottom-width="1.5pt" background-color="#4F81BD">
<fo:block space-after="0pt" space-after.conditionality="retain" line-height="1.147" font-size="9pt" language="EN-US" space-before="6pt" space-before.conditionality="retain" text-align="left" font-weight="bold" color="#FFFFFF">
<fo:inline font-weight="bold" color="#FFFFFF" font-size="9pt">
<fo:leader leader-length="0pt"/>
Email
</fo:inline>
</fo:block>
</fo:table-cell>
</fo:table-row>
</fo:table-header>
<fo:table-body>
<xsl:template match="/pdfrequest">
<fo:root>
<xsl:apply-templates select="records"/>
</fo:root>
</xsl:template>
</fo:table-body>
</fo:table>
</fo:block>
</fo:flow>
</fo:page-sequence>
</fo:root>
</xsl:template>
<xsl:template match="records">
<xsl:variable name="bgclr">
<xsl:choose>
<xsl:when test="position() mod 2 = 0">#A7BFDE</xsl:when>
<xsl:otherwise>#EDF2F8</xsl:otherwise>
</xsl:choose>
</xsl:variable>
<fo:table-row bgcolor="{$bgclr}">
<fo:table-cell padding-top="0pt" padding-left="5.4pt" padding-bottom="0pt" padding-right="5.4pt" border-left-style="solid" border-right-style="solid" border-left-color="#FFFFFF" border-right-color="#FFFFFF" border-left-width="0.5pt" border-right-width="1.5pt" border-top-style="solid" border-bottom-style="solid" border-top-color="#FFFFFF" border-bottom-color="#FFFFFF" border-top-width="0.5pt" border-bottom-width="0.5pt">
<fo:block xmlns:st1="urn:schemas-microsoft-com:office:smarttags" space-after="10pt" space-after.conditionality="retain" line-height="1.4911" font-size="9pt" language="EN-US" text-align="left" font-weight="bold" linefeed-treatment="preserve">
<fo:leader leader-length="0pt"/>
<xsl:value-of select="firstname"/>
</fo:block>
</fo:table-cell>
<fo:table-cell padding-top="0pt" padding-left="0.1pt" padding-bottom="0pt" padding-right="5.4pt" border-left-style="solid" border-right-style="solid" border-left-color="#FFFFFF" border-right-color="#FFFFFF" border-left-width="0.5pt" border-right-width="0.5pt" border-top-style="solid" border-bottom-style="solid" border-top-color="#FFFFFF" border-bottom-color="#FFFFFF" border-top-width="0.5pt" border-bottom-width="0.5pt">
<fo:block xmlns:st1="urn:schemas-microsoft-com:office:smarttags" space-after="10pt" space-after.conditionality="retain" line-height="1.4911" font-size="9pt" language="EN-US" text-align="center" font-weight="bold" linefeed-treatment="preserve">
<fo:leader leader-length="0pt"/>
<xsl:value-of select="lastname"/>
</fo:block>
</fo:table-cell>
<fo:table-cell padding-top="0pt" padding-left="5.4pt" padding-bottom="0pt" padding-right="5.4pt" border-left-style="solid" border-right-style="solid" border-left-color="#FFFFFF" border-right-color="#FFFFFF" border-left-width="0.5pt" border-right-width="0.5pt" border-top-style="solid" border-bottom-style="solid" border-top-color="#FFFFFF" border-bottom-color="#FFFFFF" border-top-width="0.5pt" border-bottom-width="0.5pt">
<fo:block xmlns:st1="urn:schemas-microsoft-com:office:smarttags" space-after="10pt" space-after.conditionality="retain" line-height="1.4911" font-size="9pt" language="EN-US" text-align="left" font-weight="bold" linefeed-treatment="preserve">
<fo:leader leader-length="0pt"/>
<xsl:value-of select="phoneno"/>
</fo:block>
</fo:table-cell>
</fo:table-row>
</xsl:template>
</xsl:stylesheet>
like image 875
theConstructor Avatar asked Dec 02 '22 19:12

theConstructor

1 Answers

Try:

<xsl:variable name="bgclr">
    <xsl:choose>
        <xsl:when test="position() mod 2">#A7BFDE</xsl:when>
        <xsl:otherwise>#EDF2F8</xsl:otherwise>
    </xsl:choose>
</xsl:variable>

<fo:table-row bgcolor="{$bgclr}">
    ...

Or:

<xsl:variable name="cls">
    <xsl:choose>
        <xsl:when test="position() mod 2">odd</xsl:when>
        <xsl:otherwise>even</xsl:otherwise>
    </xsl:choose>
</xsl:variable>

<fo:table-row class="{$cls}">
    ...

Edit:

Since you didn't post a complete example of input, stylesheet and expected output, I am posting (a minimal) one here. Given the following example input:

<input>  
    <record>
        <firstname>Adam</firstname> 
        <lastname>Adams</lastname>
        <phonenumber>555-111</phonenumber>
    </record>
    <record>
        <firstname>Betty</firstname> 
        <lastname>Blue</lastname>
        <phonenumber>555-222</phonenumber>
    </record>
    <record>
        <firstname>Cecil</firstname> 
        <lastname>Crawford</lastname>
        <phonenumber>555-333</phonenumber>
    </record>
 </input>

the following stylesheet:

<?xml version="1.0" encoding="utf-8"?>
<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 method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:template match="/input">
    <fo:root>
        <xsl:apply-templates select="record"/>
    </fo:root>
</xsl:template>

<xsl:template match="record">
    <xsl:variable name="bgclr">
        <xsl:choose>
            <xsl:when test="position() mod 2">#A7BFDE</xsl:when>
            <xsl:otherwise>#EDF2F8</xsl:otherwise>
        </xsl:choose>
    </xsl:variable>
    <fo:table-row bgcolor="{$bgclr}">
        <fo:table-cell>
            <xsl:value-of select="firstname"/>
        </fo:table-cell>
        <fo:table-cell>
            <xsl:value-of select="lastname"/>
        </fo:table-cell>
        <fo:table-cell>
            <xsl:value-of select="phonenumber"/>
        </fo:table-cell>
  </fo:table-row>
</xsl:template>

</xsl:stylesheet>

will return the following output:

<?xml version="1.0" encoding="UTF-8"?>
<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format">
  <fo:table-row bgcolor="#A7BFDE">
    <fo:table-cell>Adam</fo:table-cell>
    <fo:table-cell>Adams</fo:table-cell>
    <fo:table-cell>555-111</fo:table-cell>
  </fo:table-row>
  <fo:table-row bgcolor="#EDF2F8">
    <fo:table-cell>Betty</fo:table-cell>
    <fo:table-cell>Blue</fo:table-cell>
    <fo:table-cell>555-222</fo:table-cell>
  </fo:table-row>
  <fo:table-row bgcolor="#A7BFDE">
    <fo:table-cell>Cecil</fo:table-cell>
    <fo:table-cell>Crawford</fo:table-cell>
    <fo:table-cell>555-333</fo:table-cell>
  </fo:table-row>
</fo:root>

Note the alternating background color for each table-row.

like image 143
michael.hor257k Avatar answered Jan 22 '23 10:01

michael.hor257k
Sign in to Comment

Related questions

XSLT: remove white spaces when transforming to HTML
Messing with Encoding and XslCompiledTransform
XSLT matching empty nodes
How to handle HTML entity nbsp in XSLT. Without changing the input file
Trouble using XSLT variables to hold attributes
XSLT: Sum of specific attribute value based on other attribute's name
XSLT understand about the generate-id working way
transforming xml to html using xslt
XSLT/XPath : No upper-case function in MSXML 4.0?
xsl for-each: add code block every n rows?
XSLT sort by tag name and attribute value
Parse XML file to get all Namespace information
xslt 1.0 how to replace empty or blank value with 0 (zero) in select condition
Meaning of "context" in regard to parameters of a calling template
xsl:choose check all xsl:when conditions
XSLT - Best way to split and render comma separated text as HTML
Real World Application of XPath & XSLT
dynamic xpath in xslt?
Identity transformation in XSLT
concat, quotation mark and apostrophe combination problems

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!