========================
allproductioninfo.xml
========================
<?xml version="1.0"?>
<!--?xml-stylesheet type="text/xsl" href="allproductioninfo.xsl"?-->
<?xml-stylesheet type="text/xsl" href="Copy of cpage.xsl"?>
<root>
<row id="1" lotno="AC2763-1"/>
<row id="2" lotno="PC0472-1" ld_total="1200" ld_good="1199" ld_ng="1" ld_rate="99.9%" />
<row id="3" lotno="AC2894-1" />
<row id="4" lotno="AC1527-1" ld_total="1200" ld_good="1200" ld_ng="0" ld_rate="100%" />
<row id="5" lotno="BY1673-1" ld_total="1200" ld_good="1198" ld_ng="2" ld_rate="99.8%" />
<row id="6" lotno="QY0861-5" ld_total="1200" ld_good="1195" ld_ng="5" ld_rate="99.5%" />
<row id="7" lotno="AC2763-1" />
<row id="8" lotno="PC0472-1" ld_total="1200" ld_good="1199" ld_ng="1" ld_rate="99.9%" />
<row id="9" lotno="AC2894-1" />
<row id="10" lotno="AC1527-1" ld_total="1200" ld_good="1200" ld_ng="0" ld_rate="100%" />
<row id="11" lotno="BY1673-1" ld_total="1200" ld_good="1198" ld_ng="2" ld_rate="99.8%" />
<row id="12" lotno="QY0861-5" ld_total="1200" ld_good="1195" ld_ng="5" ld_rate="99.5%" />
<row id="13" lotno="AC1527-1" ld_total="1200" ld_good="1200" ld_ng="0" ld_rate="100%" />
<row id="14" lotno="BY1673-1" ld_total="1200" ld_good="1198" ld_ng="2" ld_rate="99.8%" />
<row id="15" lotno="PC0472-1" ld_total="1200" ld_good="1199" ld_ng="1" ld_rate="99.9%" />
<row id="16" lotno="PC0472-1" ld_total="1200" ld_good="1199" ld_ng="1" ld_rate="99.9%" />
<row id="17" lotno="AC1527-1" name="213RD" ld_total="1200" ld_good="1200" ld_ng="0" ld_rate="100%" />
</root>
=================
Copy of cpage.xsl
================
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<head>
<title>动态分页</title>
<script language="javascript">
function tableToExcel() {
window.clipboardData.setData("Text",document.all('theObjTable').outerHTML);
try
{
var ExApp = new ActiveXObject("Excel.Application");
var ExWBk = ExApp.workbooks.add();
var ExWSh = ExWBk.worksheets(1);
ExApp.DisplayAlerts = false;
ExApp.visible = true;
}
catch(e)
{
alert("您的电脑没有安装Microsoft Excel软件！") ;
return false;
}
ExWBk.worksheets(1).Paste;
}
</script>
<style>
body,root,row,id,lotno,ld_total,ld_good,ld_rate{ font: 11px "宋
体", "Arial", "Times New Roman"; }
table { font-size: 11px; border: 0px double; border-color: #99CC99 #99CC99 #CCCCCC
#CCCCCC; cellpadding:3;cellspacing:3; bgcolor:#eeeeee; text-decoration: blink}
span { font-size: 12px; color: red; }
.keybutton { cursor:hand; font-size: 11px; color: #003300; background: #ffffff;
border: 0px solid;}
</style>
<script>
function taxis(x)
{
stylesheet=document.XSLDocument;
source=document.XMLDocument;
sortField=document.XSLDocument.selectSingleNode("//xsl:sort/@select");
sortField.value=x;
Layer1.innerHTML=source.documentElement.transformNode(stylesheet);
}
</script>
<script>
<xsl:comment>
<![CDATA[
var OnePageNum=8;
var PageNum=1;
var XMLPageNum=1;
function pages(Num)
{
stylesheet=document.XSLDocument;
source=document.XMLDocument;
nodes=source.documentElement.childNodes;
len=nodes.length;
for(i=1;i<=(len/OnePageNum);i++);
XMLPageNum=i;
var firstNum=0;
var lastNume=0;
if (Num=="first") {PageNum=1;}
if (Num=="previous") {if (PageNum>1) PageNum -=1;}
if (Num=="next") {if (PageNum<XMLPageNum) PageNum +=1;}
if (Num=="last") {PageNum =XMLPageNum;}
sortField=document.XSLDocument.selectSingleNode("//@test");
firstNum=OnePageNum*(PageNum-1)+1;
lastNum=OnePageNum*(PageNum-1)+OnePageNum;
text="position()>="+firstNum+" and position()<="+lastNum;
sortField.text=text;
Layer1.innerHTML=source.documentElement.transformNode(stylesheet);
}
]]>
</xsl:comment>
</script>
</head>
<body>
<p align="center"><span>动态分页</span></p>
<table align="center" width="850" >
<tr>
<td>
<button id="cmdfirstPage" class="keybutton" onclick="pages('first');" >首页</button>
<button id="cmdpreviousPage" class="keybutton" onclick="pages('previous');" >上一页</button>
<button id="cmdnextPage" class="keybutton" onclick="pages('next');">下一页</button>
<button id="cmdlastPage" class="keybutton" onclick="pages('last');">尾页</button>
</td>
</tr>
</table>
<div id="Layer1" name="Layer1"> <xsl:apply-templates select="root" /></div>
</body>
</html>
</xsl:template>
<xsl:template match="root">
<table width="850" border="1" align="center" cellpadding="1" cellspacing="1"
bordercolordark="#ffffff" bordercolorlight="#ADAAAD" id='theObjTable'>
<tr bgcolor="#FFCC99" align="center">
<TD style="cursor:hand" onClick="taxis('@id')">ID</TD>
<td style="cursor:hand" onClick="taxis('@lotno')">LOTNO</td>
<TD colspan="3" ALIGN='CENTER'>LD</TD>
<tr/>
<td></td>
<td></td>
<td align='center'>投入</td>
<td align='center'>良品</td>
<td align='center'>步留</td>
<tr/>
</tr>
<xsl:apply-templates select="row">
<xsl:sort select="@id" data-type="number"/>
<xsl:sort select="@lotno"/>
</xsl:apply-templates>
</table>
<table>
<td><a href="#" onclick="tableToExcel()">EXcel</a></td>
</table>
</xsl:template>
<xsl:template match="row">
<xsl:if test="position()>=1 and position() <= 8">
<tr align="center">
<xsl:apply-templates select="@id" />
<xsl:apply-templates select="@lotno" />
<xsl:apply-templates select="@ld_total" />
<xsl:apply-templates select="@ld_good" />
<xsl:apply-templates select="@ld_rate" />
</tr>
</xsl:if>
</xsl:template>
<xsl:template match="@id">
<td bgcolor="#eeeeee">
<xsl:value-of select="."/>
</td>
</xsl:template>
<xsl:template match="@lotno">
<td>
<xsl:value-of select="."/>
</td>
</xsl:template>
<xsl:template match="@ld_total">
<td>
<xsl:value-of select="."/>
</td>
</xsl:template>
<xsl:template match="@ld_good">
<td>
<xsl:value-of select="."/>
</td>
</xsl:template>
<xsl:template match="@ld_rate">
<td>
<xsl:value-of select="."/>
</td>
</xsl:template>
</xsl:stylesheet>
目前只可实现导出当前页数据为XLS格式
[此贴子已经被作者于2007-5-9 16:39:16编辑过]
[返回] 中文XML论坛 - 专业的XML技术讨论区 →
XML.ORG.CN讨论区 - XML技术 → 『 XSL/XSLT/XSL-FO/CSS 』 → [求助]◆◆xsl实现分页显示XML后如何导出全部数据??------各位版主,大侠救命!!!◆◆
(订阅本版)
2007/5/7 18:11:00
新浪微博
[求助]◆◆xsl实现分页显示XML后如何导出全部数据??------各位版主,大侠救命!!!◆◆
