當(dāng)幸福來敲門

function method1(tableid) {//整個表格拷貝到EXCEL中
    var curTbl = document.getElementById(tableid);
    var oXL = new ActiveXObject("Excel.Application");
    //創(chuàng)建AX對象excel
    var oWB = oXL.Workbooks.Add();
    //獲取workbook對象
        var oSheet = oWB.ActiveSheet;
    //激活當(dāng)前sheet
    var sel = document.body.createTextRange();
    sel.moveToElementText(curTbl);
    //把表格中的內(nèi)容移到TextRange中
    sel.select();
    //全選TextRange中內(nèi)容
    sel.execCommand("Copy");
    //復(fù)制TextRange中內(nèi)容
    oSheet.Paste();
    //粘貼到活動的EXCEL中      
    oXL.Visible = true;
    //設(shè)置excel可見屬性
}
function method2(tableid) //讀取表格中每個單元到EXCEL中
{
    var curTbl = document.getElementById(tableid);
     var oXL = new ActiveXObject("Excel.Application");
     //創(chuàng)建AX對象excel
     var oWB = oXL.Workbooks.Add();
     //獲取workbook對象
    var oSheet = oWB.ActiveSheet;
    //激活當(dāng)前sheet
     var Lenr = curTbl.rows.length;
     //取得表格行數(shù)
     for (i = 0; i < Lenr; i++)
     {
         var Lenc = curTbl.rows(i).cells.length;
         //取得每行的列數(shù)
         for (j = 0; j < Lenc; j++)
         {
             oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText;
             //賦值
         }
     }
     oXL.Visible = true;
     //設(shè)置excel可見屬性
}

<input type="button" onclick="javascript:method1('TableExcel');" value="第一種方法導(dǎo)入到EXCEL">
<input type="button" onclick="javascript:method2('TableExcel');" value="第二種方法導(dǎo)入到EXCEL">