js导出excel文件

Html

Css

  #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);

}

↑上面代码改变，会自动显示代码结果 jQuery调用版本：1.11.3

立即下载

js导出excel文件



代码描述：js 导出多sheet excel文件

导出多sheet excel文件

0

最新

发表评论全部评论

暂时没有评论！

登录后才可以评论

30秒后在评论吧!

ID	姓名	年龄
0001	张三	24

ID	姓名	年龄
0002	李四	24

ID	姓名	年龄
0003	王五	24

PROMULGATOR

夜色的独白

相关代码

js导出excel文件

最新