js操作Excel导出

<script type="text/javascript">
function ExportToExcel(tableid) {
   
 var curTbl = document.getElementById(tableid);
 var tableHtml = curTbl.innerHTML;
 //$("input:text").each(function(i,e){
       //var cur_v = $(e).val();
      // $(e).parent().html("<span>"+cur_v+"</span>");
 //});
 //$("textarea").each(function(i,e){
     //  var cur_v = $(e).val();
      // $(e).parent().html("<span>"+cur_v+"</span>");
 //});
 //$("select").each(function(i,e){
      // var cur_v = $(e).val();
       //$(e).parent().html("<span>"+cur_v+"</span>");
 //});
 $("a").each(function(i,e){
       var cur_v = $(e).html();
       $(e).parent().html("<span>"+cur_v+"</span>");
 });
 var oXL = new ActiveXObject("Excel.Application");
 var oWB = oXL.Workbooks.Add();
 var exSheet = oWB.WorkSheets(1);
 
 exSheet.Columns('A:A').ColumnWidth = 25;
 exSheet.Columns('B:B').ColumnWidth = 30;
 exSheet.Columns('C:C').ColumnWidth = 25;
 exSheet.Columns('D:D').ColumnWidth = 30;
  
    // copy指定的表格
    var sel=document.body.createTextRange();
    sel.moveToElementText(curTbl);
 
 sel.select();
 sel.execCommand("Copy");
 exSheet.Paste();
 oXL.Visible = true;
 $(curTbl).html(tableHtml);
     // 退出Excel实例
     oXL.Quit();
     oXL = null;
     // 调用Cleanup（）进行垃圾回收
     idTmr = window.setInterval("Cleanup();",10);
}
//函数功能：杀掉Excel进程
function Cleanup() {
  window.clearInterval(idTmr);
  CollectGarbage();
}
</script>