javascript将网页数据导到EXCEL

提示说automation找不到对象,是因为浏览器限制了未签名的ActivcX控件

解决方法:将Internet选项-->安全-->选中Internet-->  的相关"禁用"改为"提示"

<script language="javascript">
<!--
function automateexcel()
{

// start excel and get application object.

var oxl = new ActiveXObject("excel.application");
// get a new workbook.
var owb = oxl.workbooks.add();
var osheet = owb.activesheet;
var table = document.all.company;
var hang = table.rows.length;
var lie = table.rows(0).cells.length;
// add table headers going cell by cell.
for (i=0;i<hang;i++ ) {
 for (j=0;j<lie;j++) {
  osheet.cells(i+1,j+1).value = table.rows(i).cells(j).innerText;
 }
}
oxl.visible = true;
oxl.usercontrol = true;
}
//-->
</script>

<input type="button" onclick_kkk="automateexcel();" value="导出到excel" >

<table id_dd="company">
 <tr>
  <td>kkkkkkkkkk</td>
 </tr>
</table>