導(dǎo)出excel的邏輯：
excel整個(gè)表格專業(yè)名詞是workbook?写妥，里面每張表格是sheet
頁面引入xlsx的庫，https://unpkg.com/xlsx/dist/xlsx.core.min.js
把數(shù)據(jù)生成sheet审姓，var sheet = XLSX.utils.json_to_sheet(jsonData)?珍特，json_to_sheet是將由對象組成的數(shù)組轉(zhuǎn)化成sheet，當(dāng)然還有 aoa_to_sheet將一個(gè)二維數(shù)組轉(zhuǎn)成sheet 和 table_to_sheet將table的dom直接轉(zhuǎn)成sheet
創(chuàng)建虛擬的workbook魔吐，var wb = XLSX.utils.book_new()
把sheet添加到workbook里扎筒，XLSX.utils.book_append_sheet(wb, sheet, "這里是sheetName");
把workbook轉(zhuǎn)成blob，var blob = workbook2blob(wb)?酬姆，這里workbook2blob需要手動(dòng)寫啦嗜桌，下面會(huì)貼代碼
利用a標(biāo)簽和createObjectURL實(shí)現(xiàn)下載功能，openDownloadDialog(blob, 'excel的標(biāo)題.xlsx');?辞色，這里openDownloadDialog也會(huì)在下面放上代碼
// 將workbook裝化成blob對象functionworkbook2blob(workbook){// 生成excel的配置項(xiàng)varwopts = {// 要生成的文件類型bookType:"xlsx",// // 是否生成Shared String Table骨宠，官方解釋是，如果開啟生成速度會(huì)下降相满，但在低版本IOS設(shè)備上有更好的兼容性bookSST:false,type:"binary"};varwbout = XLSX.write(workbook, wopts);// 將字符串轉(zhuǎn)ArrayBufferfunctions2ab(s){varbuf =newArrayBuffer(s.length);varview =newUint8Array(buf);for(vari =0; i != s.length; ++i) view[i] = s.charCodeAt(i) &0xff;returnbuf;? ? }varblob =newBlob([s2ab(wbout)], {type:"application/octet-stream"});returnblob;}// 將blob對象創(chuàng)建bloburl层亿，然后用a標(biāo)簽實(shí)現(xiàn)彈出下載框functionopenDownloadDialog(blob, fileName){if(typeofblob =="object"&& blobinstanceofBlob) {? ? ? ? blob = URL.createObjectURL(blob);// 創(chuàng)建blob地址}varaLink =document.createElement("a");? ? aLink.href = blob;// HTML5新增的屬性，指定保存文件名立美，可以不要后綴匿又，注意，有時(shí)候 file:///模式下不會(huì)生效aLink.download = fileName ||"";varevent;if(window.MouseEvent) event =newMouseEvent("click");//? 移動(dòng)端else{? ? ? ? event =document.createEvent("MouseEvents");? ? ? ? event.initMouseEvent("click",true,false,window,0,0,0,0,0,false,false,false,false,0,null);? ? }? ? aLink.dispatchEvent(event);}// 用的例子letsheet1data = [ { department:"行政部", count:2}, { department:"前端部", count:2} ];letsheet2data = [ { name:"張三",do:"整理文件"}, { name:"李四",do:"打印"} ];letsheet3data = [ { name:"張大人",do:"vue"}, { name:"李大人",do:"react"} ];varsheet1 = XLSX.utils.json_to_sheet(sheet1data);varsheet2 = XLSX.utils.json_to_sheet(sheet2data);varsheet3 = XLSX.utils.json_to_sheet(sheet3data);/* create a new blank workbook */varwb = XLSX.utils.book_new();XLSX.utils.book_append_sheet(wb, sheet1,"部門統(tǒng)計(jì)");XLSX.utils.book_append_sheet(wb, sheet2,"行政部");XLSX.utils.book_append_sheet(wb, sheet3,"前端部");constworkbookBlob = workbook2blob(wb);openDownloadDialog(workbookBlob,`部門統(tǒng)計(jì).xlsx`);復(fù)制代碼
如果有想學(xué)習(xí)編程的初學(xué)者建蹄，可來我們的前端直播授課群的哦：571671034里面免費(fèi)送整套系統(tǒng)的前端教程碌更！
