xsp 代碼
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsp:page language="java"
? xmlns:xsp="? xmlns:xsp-request="? xmlns:xscript="? xmlns:soap="?
? <page>
????? <content>
????? <xsp:logic>
?????? String cFCType= request.getParameter("cFCType");
???????String cPFrom= request.getParameter("cPFrom");
?<para>
????????<xsp:expr>iStartYear</xsp:expr>
?</para>
?<para>
?? <soap:call url="???? <ns1:getcurrforecast xmlns:ns1="urn:www.gpe.com:forecast:forecast">
???? <soap:enc/>
???? ?<cFCType xsi:type="xsd:string" xmlns:xsi=">
???? </ns1:getcurrforecast>
?? </soap:call>
?</para>
????? </xsp:logic>
????? </content>
? </page>
?
</xsp:page>
xml2html 代碼
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
???? xmlns:xsl="???? xmlns:sql="<xsl:output method="html"/>
<xsl:template match="/">
<xsl:variable name="s" select="number(//fp_id_12)"/>
<table border="0" width="100%" height="50">
<tr>
<td width="30%" align="left">
<img border="0" src="</td>
<td width="40%" align="center" style="font-size: 30pt"><b><u>Forecast Report</u></b></td>
<td width="30%" align="right" style="font-size: 14pt">
<SCRIPT>
document.write(Date());
</SCRIPT>
</td>
</tr>
</table>
<table border="0" bgcolor="#66CCFF" width="100%" style="border: 1px #66CCFF" cellspacing="1" cellpadding="1">
?<tr bgcolor="#66CCFF">
?? <th style="font-size: 9pt"><nobr>Part No</nobr></th>
?? <th style="font-size: 9pt"><nobr>Description</nobr></th>
?</tr>
?<xsl:for-each select="http://Item">
??<tr bgcolor="#FFFFFF">
??<td style="font-size: 9pt"><nobr><xsl:value-of select="product_code"/></nobr></td>
??<td style="font-size: 9pt"><nobr><xsl:value-of select="description"/></nobr></td>
?</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>
xml2xls 代碼
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="????????????????????????????? xmlns:sql="???????????????????????????? xmlns:gmr="? <xsl:output method="xml" />
? <xsl:template match="/">
?<gmr:Workbook xmlns:gmr="????? <gmr:SheetNameIndex>
??????? <gmr:SheetName>Sheet 1</gmr:SheetName>
????? </gmr:SheetNameIndex>
????? <gmr:Sheets>
??????? <gmr:Sheet>
????????? <gmr:Name>Sheet 1</gmr:Name>
????????? <gmr:Styles>
??????????? <gmr:StyleRegion startRow="0" endRow="0" startCol="0" endCol="99">
?????????????? <gmr:Style HAlign="8" VAlign="4" WrapText="0" Orient="1"
???????????????????????? Shade="0" Indent="0" Locked="1" Hidden="0"
???????????????????????? Fore="0:0:0" Back="FFFF:FFFF:FFFF"
???????????????????????? PatternColor="0:0:0" Format="General">
??????????????? <gmr:Font Unit="10" Bold="1" Italic="0" Underline="0" StrikeThrough="0">
????????????????? Helvetica
??????????????? </gmr:Font>
????????????? </gmr:Style>
??????????? </gmr:StyleRegion>
????????? </gmr:Styles>
????????? <gmr:Cells>
?????? <xsl:call-template name="headerrow"/>
??????????? <xsl:apply-templates select="http://Item"/>
????????? </gmr:Cells>
??????? </gmr:Sheet>
????? </gmr:Sheets>
??? </gmr:Workbook>
</xsl:template>
<xsl:template name="headerrow">
??? ??<gmr:Cell Row="0" Col="0" ValueType="60">Part No</gmr:Cell>
??<gmr:Cell Row="0" Col="1" ValueType="60">Description</gmr:Cell>
</xsl:template>
<xsl:template match="Item">
??? <xsl:variable name="row" select="position()"/>
??? <gmr:Cell Row="{$row}" Col="0" ValueType="60">
????? <xsl:value-of select="product_code"/>
??? </gmr:Cell>
??? <gmr:Cell Row="{$row}" Col="1" ValueType="60">
????? <xsl:value-of select="description"/>
??? </gmr:Cell>
</xsl:template>
</xsl:stylesheet>