正在转换MS Office XML

Question

感谢Will，我在生成自己的XSLT方面取得了一些进展，但这个XML让我完全陷入了困境，与我以前使用过的任何东西都不一样。由于它使用了MSOffice样式表，它可以在Excel中打开，但遗憾的是，我正在进行一个自动化的过程。

任何关于我如何做到这一点的线索都将受到欢迎。

转换原始XML数据：

<?xml version="1.0" encoding="UTF-8"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
<ss:Styles/>
<ss:Worksheet ss:Name="Information">
<ss:Table>
<ss:Row>
<ss:Cell>
<ss:Data ss:Type="String">Name</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">Age</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">Unit</ss:Data>
</ss:Cell>
</ss:Row>
<ss:Row>
<ss:Cell>
<ss:Data ss:Type="String">Sally</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">29</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">Greenford</ss:Data>
</ss:Cell>
</ss:Row>
<ss:Row>
<ss:Cell>
<ss:Data ss:Type="String">Dave</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">45</ss:Data>
</ss:Cell>
<ss:Cell>
<ss:Data ss:Type="String">Paddington</ss:Data>
</ss:Cell>
</ss:Row>
</ss:Table>
</ss:Worksheet>
</ss:Workbook>

进入：

<?xml version="1.0" encoding="ISO-8859-1"?>
<Report Title="Location">
<Record>
<Name>Sally</Name>
<Age>29</Age>
<Unit>Greenford</Unit>
</Record>
<Record>
<Name>Dave</Name>
<Age>45</Age>
<Unit>Paddington</Unit>
</Record>
</Report>

谢谢。

Answer 1

下面的样式表将为您提供所需的输出XML。

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" exclude-result-prefixes="ss">
  <xsl:output method="xml" encoding="ISO-8859-1"/>
  <xsl:strip-space elements="*"/>
  <!-- Match the table, output the root node and select the rows
       excluding the row that contains the header. -->
  <xsl:template match="ss:Workbook/ss:Worksheet/ss:Table">
    <xsl:text>&#xa;</xsl:text>
    <Report Title="Location">
      <xsl:text>&#xa;</xsl:text>
      <xsl:apply-templates select="ss:Row[not(position()=1)]"/>
    </Report>
    <xsl:text>&#xa;</xsl:text>
  </xsl:template>
  <!-- Now we're at a row. Match the data in each cell. -->
  <xsl:template match="ss:Row">
    <Record>
      <xsl:text>&#xa;</xsl:text>
      <xsl:apply-templates select="ss:Cell/ss:Data"/>
    </Record>
    <xsl:text>&#xa;</xsl:text>
  </xsl:template>
  <!-- Output an element for each piece of data. -->
  <xsl:template match="ss:Data">
    <!-- Find which column we are at. -->
    <xsl:variable name="column" select="count(../preceding-sibling::ss:Cell) + 1"/>
    <!-- The name of the element comes from the corresponding column 
     in the header (the first row). -->
    <xsl:element name="{//ss:Workbook/ss:Worksheet/ss:Table/ss:Row[1]/ss:Cell[$column]/ss:Data}">
      <xsl:value-of select="."/>
    </xsl:element>
    <xsl:text>&#xa;</xsl:text>
  </xsl:template>
</xsl:stylesheet>