js实现HTML Table 导出为Excel格式（含合并列格式）

function PageToExcel(TableID,FirstRow,LastRowColor,SaveAsName){ 
this.lastRowColor=LastRowColor==""?0:LastRowColor; 
var today=new Date(); 
this.saveAsName=(SaveAsName==""?today.getYear()+""+(today.getMonth()+1) + today.getDate() + today.getHours() + today.getMinutes() + today.getSeconds()  + ".xls":SaveAsName); 
this.tableId=TableID; 
this.table=document.getElementById(this.tableId);//导出的table 对象 
this.rows=this.table.rows.length;//导出的table总行数 
this.colSumCols=this.table.rows(0).cells.length;//第一行总列数 
this.fromrow=FirstRow; 
this.beginCol=0; //起始列数 
this.cols=this.colSumCols; 
this.oXL=null; 
this.oWB=null; 
this.oSheet=null; 
this.rowSpans=1; //行合并 
this.colSpans=1; //列合并 
this.colsName={0:"A",1:"B", 2:"C", 3:"D", 4:"E", 5:"F", 6:"G", 7:"H", 8:"I",9:"J", 10:"K", 11:"L", 12:"M", 13:"N", 14:"O", 15:"P", 16:"Q", 16:"R" ,18:"S", 19:"T", 20:"U", 21:"V", 22:"W", 23:"X", 24:"Y", 25:"Z"}; 

} 
PageToExcel.prototype.DeleteExcelCols=function(NotShowColList){//数组NotShowColList 
    //this.notShowColList=NotShowColList;//不显示列集合,1,2,3,1 
    //删除excel中的列 
   var m=0; 
   for(var i=0;i<NotShowColList.length;i++){ 
   if(i>0){ 
m++; 
} 
var temp=NotShowColList[i]- m; 
var index=this.colsName[temp]; 
this.oSheet.Columns(index).Delete;//删除 
   } 
   m=0; 
} 
PageToExcel.prototype.CreateExcel=function(ExcelVisible){ 
   try{ 
   this.oXL = new ActiveXObject("Excel.Application"); //创建应该对象 
   this.oXL.Visible = ExcelVisible; 
   this.oWB = this.oXL.Workbooks.Add();//新建一个Excel工作簿 
   this.oSheet = this.oWB.ActiveSheet;//指定要写入内容的工作表为活动工作表 
   //不显示网格线 
   //this.oXL.ActiveWindow.DisplayGridlines=false; 
   }catch(e){ 
alert("请确认安装了非绿色版本的excel！"+e.description); 
CloseExcel(); 
   } 
} 
//关闭excel 
PageToExcel.prototype.CloseExcel=function(){ 
    this.oXL.DisplayAlerts = false;   
this.oXL.Quit();   
this.oXL = null;   
this.oWB=null;   
this.oSheet=null; 
} 

PageToExcel.prototype.ChangeElementToLabel=function (ElementObj){ 

   var GetText=""; 
   try{ 
   var childres=ElementObj.childNodes; 
  
   }catch(e){ return GetText} 
   if(childres.length<=0) return GetText; 
   for(var i=0;i<childres.length;i++){ 
   try{if(childres[i].style.display=="none"||childres[i].type.toLowerCase()=="hidden"){continue;}} 
   catch(e){} 
    
     try{ 
      switch (childres[i].nodeName.toLowerCase()){ 
        case "#text" : 
         GetText +=childres[i].nodeValue ; 
         break; 
        case "br" : 
         GetText +="\n"; 
         break; 
        case "img" : 
         GetText +=""; 
         break; 
        case "select" : 
         GetText +=childres[i].options[childres[i].selectedIndex].innerText ; 
         break; 
        case "input" : 
         if(childres[i].type.toLowerCase()=="submit"||childres[i].type.toLowerCase()=="button"){ 
          GetText +=""; 
         }else if(childres[i].type.toLowerCase()=="textarea"){ 
          GetText +=childres[i].innerText; 
         }else{ 
          GetText +=childres[i].value; 
         } 
         break; 
        default : 
         GetText += this.ChangeElementToLabel(childres[i]); 
         break; 
      } 
     
     }catch(e){} 
   } 
   return GetText; 
} 

PageToExcel.prototype.SaveAs=function (){ 
   //保存 
   try{ 
this.oXL.Visible =true; 
this.oXL.Application.OpenFile(this.saveAsName);
//var fname = this.oXL.Application.GetSaveAsFilename(this.saveAsName, "Excel Spreadsheets (*.xls), *.xls"); 
/*if(fname){ 
this.oWB.SaveAs(fname); 
this.oXL.Visible =false; 
} */
   }catch(e){}; 
} 
PageToExcel.prototype.Exec=function() 
{ 
  
   //寻找列数，考虑到第一行可能存在 
   for (var i=0; i<this.colSumCols;i++) { 
    var tmpcolspan = this.table.rows(0).cells(i).colSpan; 
    if ( tmpcolspan>1 ) { 
     this.cols += tmpcolspan-1; 
    } 
   } 
  
   //定义2维容器数据，1：行；2：列；值（0 可以填充，1 已被填充） 
   var container=new Array(this.rows); 
   for (var i=0;i<this.rows;i++) { 
    container[i]=new Array(this.cols); 
    for (j=0;j<this.cols;j++) { 
     container[i][j]=0; 
    } 
   } 
  
   //将所有单元置为文本，避免非数字列被自动变成科学计数法和丢失前缀的0 
   this.oSheet.Range(this.oSheet.Cells(this.fromrow+1,1), this.oSheet.Cells(this.fromrow+this.rows,this.cols)).NumberFormat = "@"; 
   // 循环行 
   for (i=0;i<this.rows;i++){ 
    //循环列 
    for (j=0;j<this.cols;j++){ 
     //寻找开始列 
     for (k=j;k<this.cols;k++){ 
      if (container[i][k]==0) { 
       this.beginCol=k; 
       k=this.cols; //退出循环 
      } 
     } 

      //赋值 
      //此处相应跟改 根据 标签的类型，替换相关参数 
      this.oSheet.Cells(i+1+this.fromrow,this.beginCol+1).value = this.ChangeElementToLabel(this.table.rows(i).cells(j)); 
      //计算合并列 
      try{ 
     this.colSpans = this.table.rows(i).cells(j).colSpan; 
      }catch(e){ 
     this.colSpans=0   
     } 
     if (this.colSpans>1) { 
      //合并 
      this.oSheet.Range(this.oSheet.Cells(i+1+this.fromrow,this.beginCol+1),this.oSheet.Cells(i+1+this.fromrow,this.beginCol+this.colSpans)).Merge(); 
     } 
     //将当前table位置填写到对应的容器中 
     for (k=0; k<this.colSpans;k++) { 
      container[i][this.beginCol+k]= 1; 
     } 
     // 计算合并行 
    
     try{ 
      this.rowSpans = this.table.rows(i).cells(j).rowSpan; 
       }catch(e){ 
       this.rowSpans = 0; 
     } 
    
     if (this.rowSpans>1) { //行合并 
      this.oSheet.Range(this.oSheet.Cells(i+1+this.fromrow,this.beginCol+1),this.oSheet.Cells(i+this.rowSpans+this.fromrow,this.beginCol+this.colSpans)).Merge(); 
      //将当前table位置填写到对应的容器中 
      for (k=1; k<this.rowSpans;k++) { //由于第0行已经被colSpans对应的代码填充了，故这里从第1行开始 
       for (l=0;l<this.colSpans;l++) { 
        container[i+k][this.beginCol+l]=1; 
       } 
      } 
     } 
     //如果开始列＋合并列已经等于列数了，故不需要再循环html table 
     if (this.beginCol+this.colSpans>=this.cols) j=this.cols; 
   
    } 
    if(i==0) 
    { 
     //标题栏 
     this.oSheet.Range(this.oSheet.Cells(1,1), this.oSheet.Cells(1,1)).Font.Size=20; 
     this.oSheet.Range(this.oSheet.Cells(1,1), this.oSheet.Cells(1,1)).Font.Bold = true; 
     this.oSheet.Range(this.oSheet.Cells(1,1), this.oSheet.Cells(1,1)).HorizontalAlignment = -4108; //居中 
     this.oSheet.Range(this.oSheet.Cells(1,1), this.oSheet.Cells(1,1)).Rows.RowHeight = 40; 
    } 
     //自动调整行高 
   } 
  
   //最后一行是否空色 
   try{ 
    this.oSheet.Range(this.oSheet.Cells(this.rows,1), this.oSheet.Cells(this.rows,1)).Font.Color=this.lastRowColor; 
   }catch(e){} 

   this.oSheet.Range(this.oSheet.Cells(this.fromrow+2,1), this.oSheet.Cells(this.fromrow+this.rows,this.cols)).Rows.RowHeight=20; 
   this.oSheet.Range(this.oSheet.Cells(this.fromrow+2,1), this.oSheet.Cells(this.fromrow+this.rows,this.cols)).Font.Size=10; 
   //自动换行 
   this.oSheet.Range(this.oSheet.Cells(this.fromrow+2,1), this.oSheet.Cells(this.fromrow+this.rows,this.cols)).WrapText = true; 
   //自动调整列宽 
   this.oSheet.Range(this.oSheet.Cells(this.fromrow+1,1), this.oSheet.Cells(this.fromrow+this.rows,this.cols)).Columns.AutoFit();
//加实线 
   this.oSheet.Range(this.oSheet.Cells(this.fromrow+1,1), this.oSheet.Cells(this.fromrow+this.rows,this.cols)).Borders.LineStyle =1;
   //点虚线 
   //this.oSheet.Range(this.oSheet.Cells(this.fromrow+1,1), this.oSheet.Cells(this.fromrow+this.rows,this.cols)).Borders.LineStyle = -4118; 
  
   return this.rows; 
} 

function test(tabId){ 
// JavaScript Document 
//调用方法 
var test=new PageToExcel(tabId,0,255,"测试.xls");//table id , 第几行开始，最后一行颜色 ，保存的文件名 
test.CreateExcel(false); 
test.Exec(); 
test.SaveAs(); 
test.CloseExcel(); 
//LastRowColor 0黑色 255红色 
}