XSL用于Xml到两行和多列的表转换 [英] XSL for Xml to table transformation for two rows and many columns
问题描述
我一直在努力研究上周提出的一个问题的变化。
XSL for Xml to table transformation 。
我必须输出第一个和最后一个
我对将两行表与Muenchian分组方法进行整合的方法感到困惑
XSLT 1.0解决方案就是我需要的。我有一个解决方案,但我需要两行。
任何建议或指导将非常感谢。
输入:
< root>
< page number =1section =Arsenal>阿森纳< / page>
< page number =2section =Arsenal>阿森纳< / page>
< page number =3section =Arsenal>阿森纳< / page>
< page number =4section =Arsenal>阿森纳< / page>
< page number =5section =Arsenal>阿森纳< / page>
< page number =6section =Arsenal>阿森纳< / page>
< page number =7section =Chelsea> Chelsea< / page>
< page number =8section =Chelsea> Chelsea< / page>
< page number =9section =Chelsea> Chelsea< / page>
< page number =10section =Chelsea> Chelsea< / page>
< page number =11section =Chelsea> Chelsea< / page>
< page number =12section =Chelsea> Chelsea< / page>
< page number =13section =ManUnited> ManUnited< / page>
< page number =14section =ManUnited> ManUnited< / page>
< page number =15section =ManUnited> ManUnited< / page>
< page number =16section =ManUnited> ManUnited< / page>
< page number =17section =ManUnited> ManUnited< / page>
< page number =18section =ManUnited> ManUnited< / page>
< page number =19section =ManCity> ManCity< / page>
< page number =20section =ManCity> ManCity< / page>
< page number =21section =ManCity> ManCity< / page>
< page number =22section =ManCity> ManCity< / page>
< page number =23section =ManCity> ManCity< / page>
< page number =24section =ManCity> ManCity< / page>
< / root>
输出:
<表>
< tr>
< td>阿森纳< / td>
< td>< / td>
< td>切尔西< / td>
< td>< / td>
< td> ManU< / td>
< td>< / td>
< td> ManCity< / td>
< td>< / td>
< / tr>
< tr>
< td> 1< / td>
< td> 6< / td>
< td> 7< / td>
< td> 12< / td>
< td> 13< / td>
< td> 18< / td>
< td> 19< / td>
< td> 24< / td>
< / tr>
< / table>
这是我目前使用的XSLT逻辑。
<表>
< tr>
< / tr>
< / table>
< / xsl:template>
< xsl:template match =page>
< td>
< xsl:value-of select =@ section/>
< / td>
< td>
< xsl:value-of select =@ number/>
< / td>
< td>
< xsl:value-of select =key('kSection',@section)[last()] / @ number/>
< / td>
< / xsl:template>
< / xsl:stylesheet>
问候JJ。
< xsl:stylesheet version =1.0xmlns:xsl =http: //www.w3.org/1999/XSL/Transform\">
< xsl:key name =kmatch =pageuse =@ section/>
< xsl:template match =/ root>
< table>
< tr>
< / tr>
< tr>
< / tr>
< / table>
< / xsl:template>
< xsl:template match =page>
< td>
< xsl:value-of select =。/>
< / td>
< td>< / td>
< / xsl:template>
< xsl:template match =pagemode =page>
< td>
< xsl:value-of select =@ number/>
< / td>
< td>
< xsl:value-of select =key('k',@section)[last()] / @ number/>
< / td>
< / xsl:template>
< / xsl:stylesheet>
输出:
<表>
< tr>
< td>阿森纳< / td>
< td />
< td>切尔西< / td>
< td />
< td> ManUnited< / td>
< td />
< td> ManCity< / td>
< td />
< / tr>
< tr>
< td> 1< / td>
< td> 6< / td>
< td> 7< / td>
< td> 12< / td>
< td> 13< / td>
< td> 18< / td>
< td> 19< / td>
< td> 24< / td>
< / tr>
< / table>
I have been trying to work on a variation of a question I asked last week.
XSL for Xml to table transformation.
I have to output the the first and last page number of each section into a table with two rows.
I'm confused on how integrate a two row table with the Muenchian grouping Method
The XSLT 1.0 Solution is what I need. I have solution below for one, but I need two rows.
Any advice or guidance will be much appreciate.
Input:
<root>
<page number="1" section="Arsenal">Arsenal</page>
<page number="2" section="Arsenal">Arsenal</page>
<page number="3" section="Arsenal">Arsenal</page>
<page number="4" section="Arsenal">Arsenal</page>
<page number="5" section="Arsenal">Arsenal</page>
<page number="6" section="Arsenal">Arsenal</page>
<page number="7" section="Chelsea">Chelsea</page>
<page number="8" section="Chelsea">Chelsea</page>
<page number="9" section="Chelsea">Chelsea</page>
<page number="10" section="Chelsea">Chelsea</page>
<page number="11" section="Chelsea">Chelsea</page>
<page number="12" section="Chelsea">Chelsea</page>
<page number="13" section="ManUnited">ManUnited</page>
<page number="14" section="ManUnited">ManUnited</page>
<page number="15" section="ManUnited">ManUnited</page>
<page number="16" section="ManUnited">ManUnited</page>
<page number="17" section="ManUnited">ManUnited</page>
<page number="18" section="ManUnited">ManUnited</page>
<page number="19" section="ManCity">ManCity</page>
<page number="20" section="ManCity">ManCity</page>
<page number="21" section="ManCity">ManCity</page>
<page number="22" section="ManCity">ManCity</page>
<page number="23" section="ManCity">ManCity</page>
<page number="24" section="ManCity">ManCity</page>
</root>
Output:
<table>
<tr>
<td>Arsenal</td>
<td></td>
<td>Chelsea</td>
<td></td>
<td>ManU</td>
<td></td>
<td>ManCity</td>
<td></td>
</tr>
<tr>
<td>1</td>
<td>6</td>
<td>7</td>
<td>12</td>
<td>13</td>
<td>18</td>
<td>19</td>
<td>24</td>
</tr>
</table>
This is my current XSLT logic.
<table>
<tr>
<xsl:apply-templates select="page[generate-id() = generate-id(key('kSection', @section))]"/>
</tr>
</table>
</xsl:template>
<xsl:template match="page">
<td>
<xsl:value-of select="@section"/>
</td>
<td>
<xsl:value-of select="@number"/>
</td>
<td>
<xsl:value-of select="key('kSection', @section)[last()]/@number"/>
</td>
</xsl:template>
</xsl:stylesheet>
Regards JJ.
Use:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" omit-xml-declaration="yes" indent="yes"/>
<xsl:key name="k" match="page" use="@section"/>
<xsl:template match="/root">
<table>
<tr>
<xsl:apply-templates select="page[generate-id() = generate-id(key('k', @section))]"/>
</tr>
<tr>
<xsl:apply-templates select="page[generate-id() = generate-id(key('k', @section))]" mode="page"/>
</tr>
</table>
</xsl:template>
<xsl:template match="page">
<td>
<xsl:value-of select="."/>
</td>
<td></td>
</xsl:template>
<xsl:template match="page" mode="page">
<td>
<xsl:value-of select="@number"/>
</td>
<td>
<xsl:value-of select="key('k', @section)[last()]/@number"/>
</td>
</xsl:template>
</xsl:stylesheet>
Output:
<table>
<tr>
<td>Arsenal</td>
<td />
<td>Chelsea</td>
<td />
<td>ManUnited</td>
<td />
<td>ManCity</td>
<td />
</tr>
<tr>
<td>1</td>
<td>6</td>
<td>7</td>
<td>12</td>
<td>13</td>
<td>18</td>
<td>19</td>
<td>24</td>
</tr>
</table>
这篇关于XSL用于Xml到两行和多列的表转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!