js导出excel文件

<div id="tablesDiv">

    <table id="tabDiv1">

        <tbody><tr>

            <td>ID</td>

            <td>姓名</td>

            <td>年龄</td>

        </tr>

        <tr>

            <td>0001</td>

            <td>张三</td>

            <td>24</td>

        </tr>

    </tbody></table>

    <table id="tabDiv2">

        <tbody><tr>

            <td>ID</td>

            <td>姓名</td>

            <td>年龄</td>

        </tr>

        <tr>

            <td>0002</td>

            <td>李四</td>

            <td>24</td>

        </tr>

    </tbody></table>

    <table id="tabDiv3">

        <tbody><tr>

            <td>ID</td>

            <td>姓名</td>

            <td>年龄</td>

        </tr>

        <tr>

            <td>0003</td>

            <td>王五</td>

            <td>24</td>

        </tr>

    </tbody></table>

    <button onclick="exp();">export to excel...</button>

</div>

#tabDiv1,#tabDiv2,#tabDiv3 {

    border:1px solid pink;

    margin:10px auto;

    width:100%;

}

button {

    width:100%;

}

 function exp() {

     tablesToExcel(['tabDiv1', 'tabDiv2', 'tabDiv3'], ['yy', 'bb', 'cc'], "abc.xls", "Excel");

 }

 //导出excel包含多个sheet

 //tables:tableId的数组;wsbames:sheet的名字数组;wbname:工作簿名字;appname:Excel

 function tablesToExcel(tables, wsnames, wbname, appname) {

     var uri = 'data:application/vnd.ms-excel;base64,',

         tmplWorkbookXML = '<?xml version="1.0"?><?mso-application progid="Excel.Sheet"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">' +

         '<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"><Author>Axel Richter</Author><Created>{created}</Created></DocumentProperties>' +

         '<Styles>' +

         '<Style ss:ID="Currency"><NumberFormat ss:Format="Currency"></NumberFormat></Style>' +

         '<Style ss:ID="Date"><NumberFormat ss:Format="Medium Date"></NumberFormat></Style>' +

         '</Styles>' +

         '{worksheets}</Workbook>',

         tmplWorksheetXML = '<Worksheet ss:Name="{nameWS}"><Table>{rows}</Table></Worksheet>',

         tmplCellXML = '<Cell{attributeStyleID}{attributeFormula}><Data ss:Type="{nameType}">{data}</Data></Cell>',

         base64 = function(s) {

             return window.btoa(unescape(encodeURIComponent(s)))

         },

         format = function(s, c) {

             return s.replace(/{(\w+)}/g, function(m, p) {

                 return c[p];

             })

         }

     var ctx = "";

     var workbookXML = "";

     var worksheetsXML = "";

     var rowsXML = "";

     for (var i = 0; i < tables.length; i++) {

         if (!tables[i].nodeType)

             tables[i] = document.getElementById(tables[i]);

         //           控制要导出的行数

         for (var j = 0; j < tables[i].rows.length; j++) {

             rowsXML += '<Row>';

             for (var k = 0; k < tables[i].rows[j].cells.length; k++) {

                 var dataType = tables[i].rows[j].cells[k].getAttribute("data-type");

                 var dataStyle = tables[i].rows[j].cells[k].getAttribute("data-style");

                 var dataValue = tables[i].rows[j].cells[k].getAttribute("data-value");

                 dataValue = (dataValue) ? dataValue : tables[i].rows[j].cells[k].innerHTML;

                 var dataFormula = tables[i].rows[j].cells[k].getAttribute("data-formula");

                 dataFormula = (dataFormula) ? dataFormula : (appname == 'Calc' && dataType == 'DateTime') ? dataValue : null;

                 ctx = {

                     attributeStyleID: (dataStyle == 'Currency' || dataStyle == 'Date') ? ' ss:StyleID="' + dataStyle + '"' : '',

                     nameType: (dataType == 'Number' || dataType == 'DateTime' || dataType == 'Boolean' || dataType == 'Error') ? dataType : 'String',

                     data: (dataFormula) ? '' : dataValue,

                     attributeFormula: (dataFormula) ? ' ss:Formula="' + dataFormula + '"' : ''

                 };

                 rowsXML += format(tmplCellXML, ctx);

             }

             rowsXML += '</Row>'

         }

         ctx = {

             rows: rowsXML,

             nameWS: wsnames[i] || 'Sheet' + i

         };

         worksheetsXML += format(tmplWorksheetXML, ctx);

         rowsXML = "";

     }

     ctx = {

         created: (new Date()).getTime(),

         worksheets: worksheetsXML

     };

     workbookXML = format(tmplWorkbookXML, ctx);

     //       查看后台的打印输出

     //console.log(workbookXML);

     var link = document.createElement("A");

     link.href = uri + base64(workbookXML);

     link.download = wbname || 'Workbook.xls';

     link.target = '_blank';

     document.body.appendChild(link);

     link.click();

     document.body.removeChild(link);

 }