function table_to_excel(table_id){
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var targetT = document.getElementById(table_id);
var Lenr = targetT.rows.length;
for (i=0;i<Lenr;i++)
{
var Lenc = targetT.rows(i).cells.length;
for (j=0;j<Lenc;j++)
{
node = targetT.rows(i).cells(j);
if (node.innerText){
oSheet.Cells(i+1, j+1).value = node.innerText;
}else{
oSheet.Cells(i+1,j+1).value = node.childNodes[0].value;
}
}
}
oXL.Visible = true;
}
在ie中将表格导出excel
最新推荐文章于 2021-06-15 18:03:29 发布