我正在尝试将两个xml文件和一个XSLT文件组合成一个X
HTML页面.我之前没有这样做,也无法弄清楚如何做到这一点.这是我到目前为止,只有一个xml文件:
@H_301_20@<?PHP $xsl = new DOMDocument(); $xsl->load("file.xsl"); $inputdom = new DomDocument(); $inputdom->load("file.xml"); $proc = new XSLTProcessor(); $xsl = $proc->importStylesheet($xsl); $proc->setParameter(null,"",""); $newdom = $proc->transformToDoc($inputdom); print $newdom-> saveXML();
带有:ss命名空间的xsl-file.我不确定如何使用ss前缀?
<?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"> <xsl:template match="/"> <html> <body> <table border="1"> <tr bgcolor="#9acd32"> <th>Title</th> <th>Title2</th> </tr> <xsl:for-each select="something/some"> <tr> <td><xsl:value-of select="title"/></td> <td><xsl:value-of select="title2"/></td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template>
XML文件
<?xml version="1.0" encoding="iso-8859-1"?> <?xml-stylesheet type="text/xsl" href="file.xsl"?> <something> <some> <Firstname>Peter</Firstname> <Lastname>Anderson</Lastname> <some> .....
如果有人能给我正确的方向,我将不胜感激.
这是第二个xml文件:
<?xml version="1.0"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Created>2012-09-25T13:44:01Z</Created> </DocumentProperties> <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> <AllowPNG/> </OfficeDocumentSettings> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <WindowHeight>14060</WindowHeight> <WindowWidth>25040</WindowWidth> <WindowTopX>25540</WindowTopX> <WindowTopY>4100</WindowTopY> <Date1904/> <ProtectStructure>False</ProtectStructure> <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="12" ss:Color="#000000"/> <Interior/> <NumberFormat/> <Protection/> </Style> <Style ss:ID="s62"> <Font ss:FontName="Courier" ss:Color="#000000"/> </Style> </Styles> <Worksheet ss:Name="Workbook1.csv"> <Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="79" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="65" ss:DefaultRowHeight="15"> <Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="43"/> <Column ss:AutoFitWidth="0" ss:Width="113"/> <Column ss:Index="5" ss:AutoFitWidth="0" ss:Width="220"/> <Row ss:Index="6"> <Cell ss:Index="3" ss:StyleID="s62"/> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s62"/> </Row> <Row> <Cell ss:Index="3" ss:StyleID="s62"/> </Row> <Row> <Cell ss:Index="2"><Data ss:Type="String">id</Data></Cell> <Cell ss:StyleID="s62"><Data ss:Type="String">latitude</Data></Cell> <Cell><Data ss:Type="String">longitude</Data></Cell> </Row> <Row> <Cell ss:Index="2"><Data ss:Type="Number">8</Data></Cell> <Cell ss:StyleID="s62"><Data ss:Type="Number">57.4999</Data></Cell> <Cell><Data ss:Type="Number">15.8280</Data></Cell> </Row> .....