可以用JavaScript的ActiveXObiect()构造函数创建Execl.Application对象实现以下是一个自定义JavaScript函数outExcel(),用于将报表信息导出到Excel。<a href="#" onClick="outExcel();">导出到Excel</a><script language="javascript">
function outExcel(){
var table=document.all.wage;
row=table.rows.length;
column=table.rows(1).cells.length;
var excelapp=new ActiveXObject("Excel.Application");
excelapp.visible=true;
objBook=excelapp.Workbooks.Add();//添加新的工作簿
var objSheet=objBook.ActiveSheet;
title=objSheet.Range("DI").MergeArea;//合并单元格
title.Cells(1.0).value=doctitle.innerHTML.replace(" ","");//输出标题
title.Cells(1,1).Font.Size=16;
for(i=1;i<row+1;i++){
for(j=0;j<column;j++){
objSheet.Cells(i+1,j+1).value=table.rows(i-1).cells(j).innerHTML.replace(" ","");
}
}
excelapp.UserControl=true;
}
</script>
function outExcel(){
var table=document.all.wage;
row=table.rows.length;
column=table.rows(1).cells.length;
var excelapp=new ActiveXObject("Excel.Application");
excelapp.visible=true;
objBook=excelapp.Workbooks.Add();//添加新的工作簿
var objSheet=objBook.ActiveSheet;
title=objSheet.Range("DI").MergeArea;//合并单元格
title.Cells(1.0).value=doctitle.innerHTML.replace(" ","");//输出标题
title.Cells(1,1).Font.Size=16;
for(i=1;i<row+1;i++){
for(j=0;j<column;j++){
objSheet.Cells(i+1,j+1).value=table.rows(i-1).cells(j).innerHTML.replace(" ","");
}
}
excelapp.UserControl=true;
}
</script>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货