怎样把网页上的表格内容导入到excel中,表格title有两层甚至三层,有例子请参考 这个程序是利用OWC做的,但是只能实现一层表格title的情况。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 OWC中文全称是什么?在哪里可以学到?学到什么时候可以实现这样的功能? OWC是OFFICE WEB CONTENT的缩写 s_head+="<tr height=\"14\"><td align=\"center\" colspan=\"" + ar[0].length + "\"><font size=\"3\">" + title+ "</font></td></tr>"多重复几次就几层s_head+="<tr height=\"14\"><td align=\"center\" colspan=\"" + ar[0].length + "\"><font size=\"3\">" + title+ "</font></td></tr>" 这个表格怎么导出到excel,秋水姐姐再帮帮我。<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" colspan=3>6月7月8月</td> <td ALIGN="CENTER" NOWRAP CLASS="ttTable">总计</td></tr><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> function export1(){ Spreadsheet1.ActiveSheet.Export()}<A href="javascript:export1()">safd</A> 这个代码不错,可是excel的表出来后怎么没有打印按钮呀,这是最重要的呀。 我个人认为:能导入到excel不就可以打印了吗,还可以自己调整格式,在这上面带打印功能没必要。 javascript object 一个最基础的问题,键名必须有吗? 请问这个正则是什么意思?(非常基础) 急急急!!!那位仁兄能帮我解释一下这段js代码,小弟不甚感激 JS 排序问题 只有小时和分钟,不要日期的JAVASCRIPT控件 哪位知道js如何才能只启动默认浏览器,而不开启任何页面? 急急急急急一个txtbox 输入名字,边输入 旁边 边显示最近5个输入的名字? 初学者请教问题之三:页面跳转问题 请各位赐教!设置表格内文本颜色问题 树型菜单的JS代码,急用200分相送 怎样让父窗口提交表单? java script在onload时的调用
多重复几次就几层s_head+="<tr height=\"14\"><td align=\"center\" colspan=\"" + ar[0].length + "\"><font size=\"3\">" + title+ "</font></td></tr>"
<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" colspan=3>6月7月8月</td>
<td ALIGN="CENTER" NOWRAP CLASS="ttTable">总计</td>
</tr>
<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>
{
Spreadsheet1.ActiveSheet.Export()
}
<A href="javascript:export1()">safd</A>