XSL用于Xml到两行和多列的表转换 [英] XSL for Xml to table transformation for two rows and many columns

查看:93
本文介绍了XSL用于Xml到两行和多列的表转换的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我一直在努力研究上周提出的一个问题的变化。

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

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆