請問怎樣用xsl轉換xml的內容

Question

你将recordset生成的文件完整的贴出来，我确实懒得自己再修改，然后我帮你写xsl

Answer 1

<?xml version='1.0' encoding='big5'?>
<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly'>
<s:AttributeType name='DEPT_NAME' rs:number='1' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='24'/>
</s:AttributeType>
<s:AttributeType name='DEPT_MANAGER' rs:number='2' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='8'/>
</s:AttributeType>
<s:AttributeType name='QTY1' rs:number='3' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY2' rs:number='4' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY3' rs:number='5' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY4' rs:number='6' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY5' rs:number='7' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY6' rs:number='8' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY7' rs:number='9' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY8' rs:number='10' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY9' rs:number='11' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY10' rs:number='12' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY11' rs:number='13' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTY12' rs:number='14' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:AttributeType name='QTYALL' rs:number='15' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='number' rs:dbtype='varnumeric' dt:maxLength='20' rs:scale='0' rs:precision='38'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row DEPT_NAME='割皮' DEPT_MANAGER='李國香' QTY1='845.9' QTY2='123.3' QTY3='54' QTY4='1411.5' QTY5='66'
 QTY6='193.7' QTY7='0' QTY8='96.4' QTY9='118.4' QTY10='90.3' QTY11='81' QTY12='78.3' QTYALL='3158.8'/>
<z:row DEPT_NAME='轉鼓實驗室' DEPT_MANAGER='林煌' QTY1='36.46' QTY2='1110.2' QTY3='2119.19' QTY4='220.53'
 QTY5='230.31' QTY6='1200.46' QTY7='57' QTY8='122.09' QTY9='23' QTY10='133.66' QTY11='16.13' QTY12='80.16' QTYALL='5349.19'/>
<z:row DEPT_NAME='警衛' DEPT_MANAGER='沈衛國' QTY1='0' QTY2='0' QTY3='0' QTY4='339.55' QTY5='1559' QTY6='89.3'
 QTY7='0' QTY8='147' QTY9='391.8' QTY10='363' QTY11='2.8' QTY12='275' QTYALL='3167.45'/>
<z:row DEPT_NAME='成品倉' DEPT_MANAGER='肖聲序' QTY1='853.6' QTY2='454' QTY3='227.5' QTY4='583.2' QTY5='448'
 QTY6='1160.5' QTY7='0' QTY8='568' QTY9='872.2' QTY10='969.5' QTY11='1310' QTY12='1170.8' QTYALL='8617.3'/>
<z:row DEPT_NAME='品檢' DEPT_MANAGER='劉天其' QTY1='0' QTY2='0' QTY3='180' QTY4='392' QTY5='0' QTY6='9'
 QTY7='0' QTY8='0' QTY9='1' QTY10='52' QTY11='271' QTY12='99.8' QTYALL='1004.8'/>
<z:row DEPT_NAME='樣品開發' DEPT_MANAGER='劉天其' QTY1='2.8' QTY2='18' QTY3='0' QTY4='0' QTY5='0' QTY6='0'
 QTY7='0' QTY8='25' QTY9='0' QTY10='21' QTY11='0' QTY12='50' QTYALL='116.8'/>
</rs:data>
</xml>

Answer 2

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'
>
<xsl:output method="xml" indent="yes" /><xsl:template match="node()">
<xsl:copy>
<xsl:copy-of select="@*" />
<xsl:apply-templates select="node()" />
</xsl:copy>
</xsl:template><!--目標一-->
<xsl:template match="z:row">
<xsl:copy>
<xsl:attribute name="rowno"><xsl:value-of select="position()" /></xsl:attribute>
<xsl:copy-of select="@*" />
<xsl:apply-templates select="node()" />
</xsl:copy>
</xsl:template><!--目標二-->
<xsl:template match="s:AttributeType">
<xsl:copy>
<xsl:copy-of select="@*" />
<xsl:copy-of select="s:datatype/@*" />
</xsl:copy>
</xsl:template></xsl:stylesheet>

Answer 3

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'
>
<xsl:output method="xml" indent="yes" /><xsl:template match="node()">
<xsl:element name="{local-name()}">
<xsl:apply-templates select="@*" />
<xsl:apply-templates select="node()" />
</xsl:element>
</xsl:template><xsl:template match="s:AttributeType">
<xsl:element name="{local-name()}">
<xsl:apply-templates select="@*" />
<xsl:apply-templates select="s:datatype/@*" />
</xsl:element>
</xsl:template><xsl:template match="@*">
<xsl:attribute name="{local-name()}"><xsl:value-of select="." /></xsl:attribute>
</xsl:template><xsl:template match="@dt:type">
<xsl:copy-of select="." />
</xsl:template><xsl:template match="s:Schema">
<xsl:apply-templates select="node()" />
</xsl:template></xsl:stylesheet>