87,993
社区成员
发帖
与我相关
我的任务
分享请问可以用js将HTML文档中的表格输出吗？
小弟是一只菜鸟，现在有一问题请教各位大侠！现有HTML文档，用表格（TABLE）和表单（FORM）记录着姓名，学号，性别，请问可不可以用JS将记录输出到文本或EXCEL中？附部分源码！（中间记录省略大半）
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0096)http://200.200.200.3:8080/school/St_class.jsp?CZ_GZ=C&l_grade=2001&l_class=2&Submit=%C8%B7%B6%A8 -->
<HTML><HEAD><TITLE>学籍管理</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<SCRIPT language=JavaScript>
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</SCRIPT>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD>
<BODY>
<DIV id=Layer0
style="HEIGHT: 29px; LEFT: 20px; POSITION: absolute; TOP: 0px; WIDTH: 710px; Z-INDEX: 1"><BR>
<FORM onaction="st_class.jsp"><FONT size=+1>
<DIV align=center>
<P><FONT size=+1><SELECT name=CZ_GZ> <OPTION selected value=C>初中</OPTION>
<OPTION value=G>高中</OPTION></SELECT> </FONT><INPUT align=center maxLength=4
name=l_grade size=5 value=2001> 级 <INPUT align=center maxLength=2 name=l_class
size=3 value=2> 班 <FONT size=+1><FONT size=+1><INPUT name=Submit type=submit value=确定>
</FONT></FONT></P></DIV></FONT></FORM></DIV>
<DIV id=Layer1
style="HEIGHT: 240px; LEFT: 20px; POSITION: absolute; TOP: 38px; WIDTH: 710px; Z-INDEX: 1">
<TABLE border=1 height=50 width=250>
<TBODY>
<TR>
<TD>学号</TD>
<TD>姓名</TD>
<TD>性别</TD>
<TD></TD>
<TD></TD>
<TD>学号</TD>
<TD>姓名</TD>
<TD>性别</TD>
<TD></TD>
<TD></TD>
<TD>学号</TD>
<TD>姓名</TD>
<TD>性别</TD>
<TD></TD>
<TD></TD></TR>
<TR>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=298>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=07> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value="冯雪仪 "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION value=男>男</OPTION>
<OPTION selected value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=299>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=08> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value="孔丽婷 "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION value=男>男</OPTION>
<OPTION selected value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=300>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=09> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value="刘海燕 "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION value=男>男</OPTION>
<OPTION selected value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM></TR>
<TR>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=340>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=49> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value=" "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION selected
value=男>男</OPTION> <OPTION value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=341>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=50> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value="陶家欣 "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION value=男>男</OPTION>
<OPTION selected value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden>
<TD align=middle height=45 width="15%"><INPUT maxLength=4 name=no size=4>
</TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION selected
value=男>男</OPTION> <OPTION value=女>女</OPTION></SELECT> </TD>
<TD align=middle height=44 width="30%">
<DIV align=center><INPUT name=modify type=submit value=增加>
</DIV></TD></FORM></TR></TBODY></TABLE></DIV></BODY></HTML>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0096)http://200.200.200.3:8080/school/St_class.jsp?CZ_GZ=C&l_grade=2001&l_class=2&Submit=%C8%B7%B6%A8 -->
<HTML><HEAD><TITLE>学籍管理</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<SCRIPT language=JavaScript>
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</SCRIPT>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD>
<BODY>
<DIV id=Layer0
style="HEIGHT: 29px; LEFT: 20px; POSITION: absolute; TOP: 0px; WIDTH: 710px; Z-INDEX: 1"><BR>
<FORM onaction="st_class.jsp"><FONT size=+1>
<DIV align=center>
<P><FONT size=+1><SELECT name=CZ_GZ> <OPTION selected value=C>初中</OPTION>
<OPTION value=G>高中</OPTION></SELECT> </FONT><INPUT align=center maxLength=4
name=l_grade size=5 value=2001> 级 <INPUT align=center maxLength=2 name=l_class
size=3 value=2> 班 <FONT size=+1><FONT size=+1><INPUT name=Submit type=submit value=确定>
</FONT></FONT></P></DIV></FONT></FORM></DIV>
<DIV id=Layer1
style="HEIGHT: 240px; LEFT: 20px; POSITION: absolute; TOP: 38px; WIDTH: 710px; Z-INDEX: 1">
<TABLE border=1 height=50 width=250>
<TBODY>
<TR>
<TD>学号</TD>
<TD>姓名</TD>
<TD>性别</TD>
<TD></TD>
<TD></TD>
<TD>学号</TD>
<TD>姓名</TD>
<TD>性别</TD>
<TD></TD>
<TD></TD>
<TD>学号</TD>
<TD>姓名</TD>
<TD>性别</TD>
<TD></TD>
<TD></TD></TR>
<TR>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=298>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=07> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value="冯雪仪 "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION value=男>男</OPTION>
<OPTION selected value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=299>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=08> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value="孔丽婷 "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION value=男>男</OPTION>
<OPTION selected value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=300>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=09> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value="刘海燕 "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION value=男>男</OPTION>
<OPTION selected value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM></TR>
<TR>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=340>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=49> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value=" "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION selected
value=男>男</OPTION> <OPTION value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden value=341>
<TD height=45 width="15%"><INPUT maxLength=2 name=no size=4 value=50> </TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8
value="陶家欣 "> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION value=男>男</OPTION>
<OPTION selected value=女>女</OPTION></SELECT> </TD>
<TD height=45 width="30%">
<DIV align=center><INPUT name=modify type=submit value=修改> </DIV></TD>
<TD width="10%"> </TD></FORM>
<FORM action=st_modify.jsp method=post><INPUT name=CZ_GZ type=hidden
value=C> <INPUT name=grade type=hidden value=2001> <INPUT name=class
type=hidden value=2> <INPUT name=id type=hidden>
<TD align=middle height=45 width="15%"><INPUT maxLength=4 name=no size=4>
</TD>
<TD height=45 width="25%"><INPUT maxLength=8 name=name size=8> </TD>
<TD height=45 width="22%"><SELECT name=sex> <OPTION selected
value=男>男</OPTION> <OPTION value=女>女</OPTION></SELECT> </TD>
<TD align=middle height=44 width="30%">
<DIV align=center><INPUT name=modify type=submit value=增加>
</DIV></TD></FORM></TR></TBODY></TABLE></DIV></BODY></HTML>
...全文
请发表友善的回复…
发表回复
wu_07 2002-09-11
- 打赏
- 举报
function savetoExcel(){
var tblout
var table = document.all.tags("TABLE");
if(table.length==0) return false;
for (i = 0; i < table.length; i++){
tblout=table(i);break;
}
try{
var exApp = new ActiveXObject("Excel.Application");}catch(exception){alert("不能连接到excel!");return }
exApp.WorkBooks.add()
var exSheet = exApp.ActiveWorkBook.WorkSheets(1);
exSheet.name=self.document.title
for(i=0;i<tblout.rows.length;i++)
for(j=0;j<tblout.rows(i).cells.length;j++)
{
if (tblout.rows(i).cells(j).childNodes.length==1)
valueString = tblout.rows(i).cells(j).innerText;
if (tblout.rows(i).cells(j).childNodes.length==0)
valueString = "";
if (tblout.rows(i).cells(j).childNodes.length==2)
valueString = tblout.rows(i).cells(j).firstChild.value;
exSheet.Cells(i+2, j+1).Value = valueString
}
exApp.ActiveWorkBook.Close(true,"d:\\newbook.xls");
exApp.quit();
exApp=null;
alert("列表已被保存为d:\\newbook.xls！");
return fasle;
}
var tblout
var table = document.all.tags("TABLE");
if(table.length==0) return false;
for (i = 0; i < table.length; i++){
tblout=table(i);break;
}
try{
var exApp = new ActiveXObject("Excel.Application");}catch(exception){alert("不能连接到excel!");return }
exApp.WorkBooks.add()
var exSheet = exApp.ActiveWorkBook.WorkSheets(1);
exSheet.name=self.document.title
for(i=0;i<tblout.rows.length;i++)
for(j=0;j<tblout.rows(i).cells.length;j++)
{
if (tblout.rows(i).cells(j).childNodes.length==1)
valueString = tblout.rows(i).cells(j).innerText;
if (tblout.rows(i).cells(j).childNodes.length==0)
valueString = "";
if (tblout.rows(i).cells(j).childNodes.length==2)
valueString = tblout.rows(i).cells(j).firstChild.value;
exSheet.Cells(i+2, j+1).Value = valueString
}
exApp.ActiveWorkBook.Close(true,"d:\\newbook.xls");
exApp.quit();
exApp=null;
alert("列表已被保存为d:\\newbook.xls！");
return fasle;
}
richardluopeng 2002-09-11
- 打赏
- 举报
厉害！
randyhui 2002-09-10
- 打赏
- 举报
to : gzh_seagull(不可)
谢谢你的示例，不过我还是不明白，可不可以针对我的HTML给我个实例？
谢谢你的示例，不过我还是不明白，可不可以针对我的HTML给我个实例？
lmh79 2002-09-10
- 打赏
- 举报
我觉得可以的，js有文件操作！不过直接输出到EXCEL文件中可能要找找资料那！
gzh_seagull 2002-09-10
- 打赏
- 举报
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<SCRIPT LANGUAGE="JavaScript">
<!--
function table2array(table1) //把一个表格转换为一个2维数组
{
return tbody2array(table1.firstChild)
}
function tbody2array(tbody1)
{
var elm=tbody1.children;
var result = new Array();
for (var i=0;i<elm.length;i++)
{
var tmp = new Array();
for (var j=0;j<elm[i].children.length;j++)
tmp[tmp.length] = elm[i].children[j].innerText;
result [result.length]=tmp;
}
return (result);
}
//-->
</SCRIPT>
</HEAD>
<BODY>
<table id="resultRs" BORDER="0" CELLSPACING="1" CELLPADDING="1" WIDTH="100%" BGCOLOR="#999999">
<tr BGCOLOR="#d8c8a8">
<td ALIGN="CENTER" width="1%" NOWRAP CLASS="ttTable">序号</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">客户名称</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">6月</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">7月</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">8月</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">总计</td>
</tr>
<tr BGCOLOR="#f0f0e8">
<td NOWRAP class="td">1</td>
<td NOWRAP class="td">建丰广州公司</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>528,343</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>528,343</td>
</tr>
<tr BGCOLOR="#f8f4e4">
<td NOWRAP class="td">2</td>
<td NOWRAP class="td">大地科技技术有限公司</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>137,440</td>
<td ALIGN="right" class="td" NOWRAP>248,990</td>
<td ALIGN="right" class="td" NOWRAP>386,430</td>
</tr>
<tr BGCOLOR="#f0f0e8">
<td NOWRAP class="td">3</td>
<td NOWRAP class="td">滁州亿万饲料科技有限公司</td>
<td ALIGN="right" class="td" NOWRAP>300,000</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>300,000</td>
</tr>
<tr BGCOLOR="#f8f4e4">
<td NOWRAP class="td">4</td>
<td NOWRAP class="td">合肥华仁生物技术有限公司</td>
<td ALIGN="right" class="td" NOWRAP>300,000</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>300,000</td>
</tr>
<tr BGCOLOR="#f0f0e8">
<td NOWRAP class="td">5</td>
<td NOWRAP class="td">福建龙岩佳明畜牧饲料有限公司</td>
<td ALIGN="right" class="td" NOWRAP>252,500</td>
<td ALIGN="right" class="td" NOWRAP>1,250</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>253,750</td>
</tr>
<tr BGCOLOR="#d8c8a8">
<td NOWRAP class="td"></td>
<td NOWRAP class="td">合计</td>
<td ALIGN="right" class="td" NOWRAP>852,500</td>
<td ALIGN="right" class="td" NOWRAP>667,033</td>
<td ALIGN="right" class="td" NOWRAP>248,990</td>
<td ALIGN="right" class="td" NOWRAP>1,768,523</td>
</tr>
</table>
<SCRIPT LANGUAGE="JavaScript">
<!--
var arRS = table2array(resultRs);
//-->
</SCRIPT>
<INPUT TYPE="button" value="showExcel" onclick="showExcel(arRS,'客户交易排行');">
<SCRIPT LANGUAGE="JavaScript">
<!--
function showExcel(ar,title){
var s_head="<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\">"
+"<head><style type=\"text/css\">"
+"<!--"
+"tr {mso-height-source:auto;}"
+"td {white-space:nowrap;}"
+".wcC24FAB9 {white-space:nowrap;font-family:宋体;mso-number-format:General;font-size:auto;font-weight:auto;font-style:auto;text-decoration:auto;mso-background-source:auto;mso-pattern:auto;mso-color-source:auto;text-align:general;vertical-align:bottom;border-top:none;border-left:none;border-right:none;border-bottom:none;mso-protection:locked;}"
+".wcCF5FAB9 {white-space:nowrap;font-family:宋体;mso-number-format:General;font-size:auto;font-weight:auto;font-style:auto;text-decoration:auto;mso-background-source:auto;mso-pattern:auto;mso-color-source:auto;text-align:general;vertical-align:bottom;border-top:none;border-left:none;border-right:none;border-bottom:none;mso-protection:unlocked;}"
+"-->"
+"</style></head><body>"
+"<!--[if gte mso 9]>"
+"<xml>"
+"<x:ExcelWorkbook>"
+"<x:ExcelWorksheets>"
+"<x:ExcelWorksheet>"
+"<x:OWCVersion>9.0.0.2710</x:OWCVersion>"
+"<x:Label Style='border-top:solid .5pt silver;border-left:solid .5pt silver; order-right:solid .5pt silver;border-bottom:solid .5pt silver'>"
+"<x:Caption>"+ title +"</x:Caption>"
+"</x:Label>"
+"<x:Name>Sheet1</x:Name>"
+"<x:WorksheetOptions>"
+"<x:Selected/>"
+"<x:Height>7620</x:Height>"
+"<x:Width>15240</x:Width>"
+"<x:TopRowVisible>0</x:TopRowVisible>"
+"<x:LeftColumnVisible>0</x:LeftColumnVisible>"
+"<x:ProtectContents>False</x:ProtectContents>"
+"<x:DefaultRowHeight>210</x:DefaultRowHeight>"
+"<x:StandardWidth>2389</x:StandardWidth>"
+"</x:WorksheetOptions>"
+"</x:ExcelWorksheet>"
+"</x:ExcelWorksheets>"
+"<x:SpreadsheetAutoFit/>"
+"<x:MaxHeight>80%</x:MaxHeight>"
+"<x:MaxWidth>80%</x:MaxWidth>"
+"</x:ExcelWorkbook>"
+"</xml><![endif]-->"
+"<table class=wcC24FAB9 x:str>"
for (var i=0;i<ar[0].length;i++) {
s_head+="<col class=wcC24FAB9 width=\"200\" style='mso-width-source:userset'> "
}
s_head+="<tr height=\"14\"><td align=\"center\" colspan=\"" + ar[0].length + "\"><font size=\"3\">" + title+ "</font></td></tr>"
for (var i=0;i<ar.length;i++){
s_head+="<tr height=\"14\"> "
for(var j=0;j<ar[0].length;j++){
s_head += "<td class=wcC24FAB9>" + ar[i][j] + "</td>"
}
s_head+="</tr>"
}
s_head+="</table></body></html>"
Spreadsheet1.HTMLData=s_head;
//alert(Spreadsheet1.HTMLData)
showExceldiv.style.display="block";
}
//-->
</SCRIPT>
<div id="showExceldiv" style="display:none">
<object classid="clsid:0002E510-0000-0000-C000-000000000046" id="Spreadsheet1" codebase="" width="100%" height="1400">
</object>
</div>
</BODY>
</HTML>
<HEAD>
<TITLE> New Document </TITLE>
<SCRIPT LANGUAGE="JavaScript">
<!--
function table2array(table1) //把一个表格转换为一个2维数组
{
return tbody2array(table1.firstChild)
}
function tbody2array(tbody1)
{
var elm=tbody1.children;
var result = new Array();
for (var i=0;i<elm.length;i++)
{
var tmp = new Array();
for (var j=0;j<elm[i].children.length;j++)
tmp[tmp.length] = elm[i].children[j].innerText;
result [result.length]=tmp;
}
return (result);
}
//-->
</SCRIPT>
</HEAD>
<BODY>
<table id="resultRs" BORDER="0" CELLSPACING="1" CELLPADDING="1" WIDTH="100%" BGCOLOR="#999999">
<tr BGCOLOR="#d8c8a8">
<td ALIGN="CENTER" width="1%" NOWRAP CLASS="ttTable">序号</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">客户名称</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">6月</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">7月</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">8月</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">总计</td>
</tr>
<tr BGCOLOR="#f0f0e8">
<td NOWRAP class="td">1</td>
<td NOWRAP class="td">建丰广州公司</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>528,343</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>528,343</td>
</tr>
<tr BGCOLOR="#f8f4e4">
<td NOWRAP class="td">2</td>
<td NOWRAP class="td">大地科技技术有限公司</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>137,440</td>
<td ALIGN="right" class="td" NOWRAP>248,990</td>
<td ALIGN="right" class="td" NOWRAP>386,430</td>
</tr>
<tr BGCOLOR="#f0f0e8">
<td NOWRAP class="td">3</td>
<td NOWRAP class="td">滁州亿万饲料科技有限公司</td>
<td ALIGN="right" class="td" NOWRAP>300,000</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>300,000</td>
</tr>
<tr BGCOLOR="#f8f4e4">
<td NOWRAP class="td">4</td>
<td NOWRAP class="td">合肥华仁生物技术有限公司</td>
<td ALIGN="right" class="td" NOWRAP>300,000</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>300,000</td>
</tr>
<tr BGCOLOR="#f0f0e8">
<td NOWRAP class="td">5</td>
<td NOWRAP class="td">福建龙岩佳明畜牧饲料有限公司</td>
<td ALIGN="right" class="td" NOWRAP>252,500</td>
<td ALIGN="right" class="td" NOWRAP>1,250</td>
<td ALIGN="right" class="td" NOWRAP></td>
<td ALIGN="right" class="td" NOWRAP>253,750</td>
</tr>
<tr BGCOLOR="#d8c8a8">
<td NOWRAP class="td"></td>
<td NOWRAP class="td">合计</td>
<td ALIGN="right" class="td" NOWRAP>852,500</td>
<td ALIGN="right" class="td" NOWRAP>667,033</td>
<td ALIGN="right" class="td" NOWRAP>248,990</td>
<td ALIGN="right" class="td" NOWRAP>1,768,523</td>
</tr>
</table>
<SCRIPT LANGUAGE="JavaScript">
<!--
var arRS = table2array(resultRs);
//-->
</SCRIPT>
<INPUT TYPE="button" value="showExcel" onclick="showExcel(arRS,'客户交易排行');">
<SCRIPT LANGUAGE="JavaScript">
<!--
function showExcel(ar,title){
var s_head="<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\">"
+"<head><style type=\"text/css\">"
+"<!--"
+"tr {mso-height-source:auto;}"
+"td {white-space:nowrap;}"
+".wcC24FAB9 {white-space:nowrap;font-family:宋体;mso-number-format:General;font-size:auto;font-weight:auto;font-style:auto;text-decoration:auto;mso-background-source:auto;mso-pattern:auto;mso-color-source:auto;text-align:general;vertical-align:bottom;border-top:none;border-left:none;border-right:none;border-bottom:none;mso-protection:locked;}"
+".wcCF5FAB9 {white-space:nowrap;font-family:宋体;mso-number-format:General;font-size:auto;font-weight:auto;font-style:auto;text-decoration:auto;mso-background-source:auto;mso-pattern:auto;mso-color-source:auto;text-align:general;vertical-align:bottom;border-top:none;border-left:none;border-right:none;border-bottom:none;mso-protection:unlocked;}"
+"-->"
+"</style></head><body>"
+"<!--[if gte mso 9]>"
+"<xml>"
+"<x:ExcelWorkbook>"
+"<x:ExcelWorksheets>"
+"<x:ExcelWorksheet>"
+"<x:OWCVersion>9.0.0.2710</x:OWCVersion>"
+"<x:Label Style='border-top:solid .5pt silver;border-left:solid .5pt silver; order-right:solid .5pt silver;border-bottom:solid .5pt silver'>"
+"<x:Caption>"+ title +"</x:Caption>"
+"</x:Label>"
+"<x:Name>Sheet1</x:Name>"
+"<x:WorksheetOptions>"
+"<x:Selected/>"
+"<x:Height>7620</x:Height>"
+"<x:Width>15240</x:Width>"
+"<x:TopRowVisible>0</x:TopRowVisible>"
+"<x:LeftColumnVisible>0</x:LeftColumnVisible>"
+"<x:ProtectContents>False</x:ProtectContents>"
+"<x:DefaultRowHeight>210</x:DefaultRowHeight>"
+"<x:StandardWidth>2389</x:StandardWidth>"
+"</x:WorksheetOptions>"
+"</x:ExcelWorksheet>"
+"</x:ExcelWorksheets>"
+"<x:SpreadsheetAutoFit/>"
+"<x:MaxHeight>80%</x:MaxHeight>"
+"<x:MaxWidth>80%</x:MaxWidth>"
+"</x:ExcelWorkbook>"
+"</xml><![endif]-->"
+"<table class=wcC24FAB9 x:str>"
for (var i=0;i<ar[0].length;i++) {
s_head+="<col class=wcC24FAB9 width=\"200\" style='mso-width-source:userset'> "
}
s_head+="<tr height=\"14\"><td align=\"center\" colspan=\"" + ar[0].length + "\"><font size=\"3\">" + title+ "</font></td></tr>"
for (var i=0;i<ar.length;i++){
s_head+="<tr height=\"14\"> "
for(var j=0;j<ar[0].length;j++){
s_head += "<td class=wcC24FAB9>" + ar[i][j] + "</td>"
}
s_head+="</tr>"
}
s_head+="</table></body></html>"
Spreadsheet1.HTMLData=s_head;
//alert(Spreadsheet1.HTMLData)
showExceldiv.style.display="block";
}
//-->
</SCRIPT>
<div id="showExceldiv" style="display:none">
<object classid="clsid:0002E510-0000-0000-C000-000000000046" id="Spreadsheet1" codebase="" width="100%" height="1400">
</object>
</div>
</BODY>
</HTML>
