gpt4 book ai didi

xslt - 在生成 pdf 时通过 XSL 替代表格行颜色

转载 作者:行者123 更新时间:2023-12-04 21:57:12 26 4
gpt4 key购买 nike

我对 XSLT 很陌生。我想在我的表格行中实现替代颜色。应该显示偶数行 - #EDF2F8 和奇数行 - #A7BFDE。

我有一个 xsl 看起来像:

<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>

我尝试使用以下代码,但没有用:
<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>

我真的很感激这方面的任何帮助。

我编辑的部分代码也不起作用:
<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>

.....<-- 类似的更多表格单元格 -->

编辑 3
输入数据采用 JSON 格式,如:
"pdfrequest" : {
"records" : [{
"firstname" : "--",
"lastname" : "--",
"phoneno" : "--",
}]
}

编辑 4。
下面是我正在使用的示例 XSL。这会将 JSON 转换为 pdf。任何帮助表示赞赏。
<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>

最佳答案

尝试:

<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}">
...

或者:
<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}">
...

编辑:

由于您没有发布完整的输入、样式表和预期输出示例,我在这里发布(一个最小的)示例。给定以下示例输入:
<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>

以下样式表:
<?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>

将返回以下输出:
<?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>

注意每个 table-row 的交替背景颜色.

关于xslt - 在生成 pdf 时通过 XSL 替代表格行颜色,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/25341612/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com