layui 导出 Excel表格的方法

一、使用layui自带的excel导出功能

1. // 原始容器
2. <table id="demo" lay-filter="test"></table>
3. //JS 调用：
4. table.render({
5.   elem: '#demo'
6.   ,toolbar: '#toolbarDemo' // 重点，可默认，也可自己设置按钮
7.   ,defaultToolbar: ['filter', 'exports'], // exports为导出按钮
8.   //,…… //其他参数
9. });

复制代码

如下图：

 也可设置数据导出按钮，通过方法导出恣意数据，方法如下：
语法：

1. table.exportFile(id, data, type)

复制代码

示例：

1. var ins1 = table.render({
2.     elem: '#demo1'
3.     ,id: 'test'
4.     // ,.... //其他参数
5. })
7. // 将上述表格示例导出为csv文件
8. table.exportFile(ins1.config.id, data); // data 为该实例中的任意数量的数据

复制代码

该方法也可以不用依靠table的实例，可直接导出恣意数据：

1. table.exportFile(['名字','性别','年龄'], [
2.   ['张三','男','20'],
3.   ['李四','女','18'],
4.   ['王五','女','19']
5. ], 'csv'); //默认导出 csv，也可以为：xls

复制代码

二、使用第三方扩展插件：excel.js

1、下载插件放入项目中

 
2、前端界面设置button按钮

1. <button class="layui-btn layui-btn-normal " lay-event="bgShow">导出</button>

复制代码

3、获取点击事件

1. //头工具栏事件
2.        layui.table.on('toolbar(table)', function (obj) {
3.             var checkStatus = layui.table.checkStatus(obj.config.id);
4.             switch (obj.event) {
5.                 case 'bgShow':   //导出
6.                     exportFile("table", "XXXXX"); // 第一个参数：table；第二个参数为文件名称
7.                     break;
8.             };
9.         });

复制代码

4、table分页，导出当前页内容

1. function exportFile(id, titleInfo) {
2. //根据传入tableID获取表头
3. var headers = $("div[lay-id=" + id + "] .layui-table-box table").get(0);
4. var htrs = Array.from(headers.querySelectorAll('tr'));
5. var titles = {};
6. for (var j = 0; j < htrs.length; j++) {
7.      var hths = Array.from(htrs[j].querySelectorAll("th"));
8.      for (var i = 0; i < hths.length; i++) {
9.          var clazz = hths[i].getAttributeNode('class').value;
10.          if (clazz != ' layui-table-col-special' && clazz != 'layui-hide') {
11.              //排除居左、具有、隐藏字段
12.              //修改:默认字段data-field+i,兼容部分数据表格中不存在data-field值的问题
13.              titles['data-field' + i] = hths[i].innerText;
14.           }
15.      }
16.   }
18. //根据传入tableID获取table内容
19. var bodys = $("div[lay-id=" + id + "] .layui-table-box table").get(1);
20. var btrs = Array.from(bodys.querySelectorAll("tr"));
21. var bodysArr = new Array();
22. for (var j = 0; j < btrs.length; j++) {
23.     var contents = {};
24.     var btds = Array.from(btrs[j].querySelectorAll("td"));
25.     for (var i = 0; i < btds.length; i++) {
26.         for (var key in titles) {
27.             //修改:默认字段data-field+i,兼容部分数据表格中不存在data-field值的问题
28.             var field = 'data-field' + i;
29.             if (field === key) {
30.                //根据表头字段获取table内容字段
31.                contents[field] = btds[i].innerText;
32.             }
33.         }
34.      }
35.      bodysArr.push(contents)
36.   }
37.   //将标题行置顶添加到数组
38.   bodysArr.unshift(titles);
39.   // 导出excel
40.   layui.config({
41.      base: 'assets/libs/layui_extends/' // 插件路径
42.   }).use(['excel'], function () {
43.      var excel = layui.excel;
44.      excel.exportExcel({
45.         sheet1: bodysArr
46.      }, titleInfo + new Date().toLocaleString() + '.xlsx', 'xlsx');
47.    });
48. }

复制代码

5、导出全部数据

1. function exportFile(id, titleInfo) {
3.    $.ajax({
4.        url: 'xxxxxx', // 获取数据的接口
5.        type: 'get',
6.        data: {},
7.        success: function (res) {
8.           if (res.code == 0) {
9.              var excelData = res.data;
10.              layui.config({
11.                 base: 'assets/libs/layui_extends/'
12.              }).use(['excel'], function () {
13.                 var excel = layui.excel;
14.                 excelData = excel.filterExportData(excelData, [
15.                     'aaa','bbb','ccc' // 对应需要导出的字段，根据后台返回数据对应需要字段
16.                 ])
17.                 // 对应数据的表头
18.                 excelData.unshift({ aaa: 'aaa', bbb: 'bbb', ccc: 'ccc' });
19.                 excel.exportExcel(excelData, titleInfo + new Date().toLocaleString() + '.xlsx', 'xlsx');
20.                         });
21.           } else {
22.                layer.closeAll();
23.                layer.msg("数据导出失败", { icon: 2 });
24.           }
25.       },
26.       error: function (error) {
27.          console.log("获取全部数据失败：", error);
28.       }
29.    })
30. }

复制代码

路漫漫其修远兮，吾将上下而求索！


来源：https://blog.csdn.net/weixin_38817361/article/details/129040044
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！

To the person inquiring about agen togel terbaik, bandar togel online terbesar, situs terupdate, situs slot yang terpercaya, slot online 4d, agen situs slot terpercaya, agent slot online, slot online resmi, game slot joker gaming, main judi slot online,  I highly recommend this additional reading for tajir4d site or slot kami, nama situs togel terbaik, situs terbesar slot, bandar togel terbesar di indonesia, judi toto, situs toto online terpercaya, tentang judi slot, cara main game slot, judi slot online indonesia, situs togel dan slot resmi, on top of this his comment is here for login tajir4d tips bearing in mind permainan casino online, situs slot jago, hk siang, situs situs slot terbaik, slot live online, cara bermain slot pragmatic, main game slot online, resmi slot, situs pg soft, situs judi resmi, together with this learn more for tajir4d link alternatif url which is also great. Also, have a look at this clicking here about tajir4d url alongside all web judi terpercaya, terbaru slot, menang togel online, kami slot, aplikasi link togel, situs gaming, situs online togel, main slot, situs slot toto, daftar situs judi slot online resmi, and don't forget this learn more here for tajir4d link alternatif advice which is worth considering with slot casino, slot gampang menang, situs online slot terpercaya, bermain slot adalah, judi toto,  great site on not to mention judi slot online deposit pulsa tanpa potongan, agen togel slot, situs terupdate, situs2 slot, da slot,  for good measure. Check more @ New Tajir4D Link Alternatif Blog e61d047

For the person talking about rejuvenation shot, face and body treatments, skin care treatment, rf laser treatment, dermal fillers co to jest, lip flip with lip filler, face rejuvenation treatments, face skin care treatment, best non invasive skin tightening, the vampire breast lift,  I highly recommend this our website on laser treatment skin tightening url or skin tightening and lifting, best facial injections, makeup microneedling, rejuvenate medical aesthetics, spa sarasota fl, dermal injector, face lift non surgical, facial hair restoration, best chemical peel, derma face lift, bearing in mind this enquiry about laser treatment near me info and don't forget red treatment, skin treatments, skin lifting facial, skin derma peel, non surgical body skin tightening, best lip injections, derma prp, the best lip injections, male enhancement shot, p injections, which is worth considering with this great laser medspa Sarasota info which is also great. Also, have a look at this this hyperlink for laser facial skin treatment link together with peel treatment, the med spa, co2 skin rejuvenation, med spa sarasota fl, lip filler with fat, red light therapy red light therapy, best body treatments, best face tightening procedures, derma treatment, medical aesthetics, and don't forget this sell on pigmentation treatment Sarasota url bearing in mind facial list, wrinkle fillers, best facial sarasota, microneedling facial, aesthetics med,  a replacement about on top of a thread lift, best facial in, fat dissolving, therapy for skin, dermaplane peel,  for good measure. Check more @ Top Rated Laser Treatment Near Me Site 98ce0e6

For the lady talking about startup ai companies to invest in, ai stocks to buy, best app for trading analysis, stock market ai bot, stock analyzer tool free, best platform to analyse stocks, artificial technology stocks, ai trading software free, shares in open ai, advice on stocks,  I highly suggest this extra resources on AI stock investing analysis details or use ai to predict stock price, ai companies in stock market, stock analysis best website, ai picking stocks, ai on stock market, ai companies on stock market, stocks in trading, best tools to analyze stocks, ai forecast stock, ai startup stocks, and don't forget this a fantastic read for AI stock picker analysis advice alongside all best ai investing platform, best ai stocks to buy now, best apps to predict stocks, best ai stocks to invest, ai algorithms for stock trading, stocks dealing with artificial intelligence, website stock market, best free software for stock market analysis, number one ai stock, equity trading software, not to mention this additional reading about AI stock trading analysis blog which is also great. Also, have a look at this this guy for AI stock picker analysis tips alongside all ai on stock market, ai companies to buy stock in, stock market data analysis, up and coming ai companies to invest in, artificial intelligence trading software, stock investment analysis, free stock prediction app, ai gpt stock, ai chat stock, stock financial analysis, which is worth considering with this website on AI stock investing platform advice alongside all stock technical analysis, top ai trading software, best investment analysis websites, best tools for investing in stocks, stock price prediction ai,  the original source about as well as free software for stock market, best cheap ai stocks, trading prediction software, ai for trading stocks, best online stock analysis tools,  for good measure. Check more @ Updated Tajir4D Link Alternatif Info 6bab48d

In reply to the people inquiring about keluar angka singapura hari ini, link judi togel terpercaya, data keluaran sgp, situs togel angka jitu, bocoran sgp togel hari ini angka jitu, daftar angka keluar hongkong, pengeluaran angka singapura, daftar keluaran togel hongkong, pengeluaran togel sidney hari ini, angka jitu togel hk hari ini,  I highly suggest this updated 7 RAJA TOGEL forum or angka jitu sdy hari ini, pengeluaran togel sidney hari ini, togel keluaran sgp hari ini, prediksi angka togel sgp, angka togel hk hari ini, togel angka keluar sgp, prediksi togel sgp hari ini, no togel sdy, pengeluaran angka sgp, cara menghitung angka togel hk, bearing in mind this for beginners for 7RAJATOGEL details together with prediksi angka sgp hari ini, angka keluar sgp 2022, nomor togel sidney hari ini, judi togel sidney, cara mencari angka jitu togel, angka angka togel, angka togel angka togel, prediksi angka keluar sgp hari ini, togel singapore sydney hongkong, bandar togel online terbesar, not forgetting sites such as this find out more on 7 RAJA TOGEL link which is also great. Also, have a look at this this contact form about 7RAJATOGEL blog bearing in mind data keluaran togel lengkap, angka togel keluar, bandar togel online terpercaya, data keluaran sgp, angka keluar sgp tercepat, live result sgp hk sydney, angka keluar singapura hari ini, data angka keluar sgp, prediksi angka togel sgp hari ini, angka togel sydney, not to mention this top 7RAJATOGEL details which is worth considering with keluaran sgp hk sdy, live draw togel sdy, angka jitu togel sydney, cara bermain togel hongkong, togel singapore hk sydney,  read more on as well as angka keluar togel sgp hari ini, data togel sdy sgp hk, sgp hari ini keluaran sgp hari ini, keluaran sgp hk sdy, cara menghitung angka keluar hk,  for good measure. Check more @ Cool Tajir4D Site 47ad44_

For the lady inquiring about agen togel terlengkap, login joker123 gaming, kumpulan situs slot online terbaik, togel 4d slot, joker slot login, link slot joker, link game judi slot online, situs terbaik slot online, judi slot pg, judi mesin slot online,  I highly recommend this awesome DVLTOTO advice or link main slot online, situs togel terbesar, permainan online slot, judi slot terpercaya, judi slot uang asli, ini slot, slot microgaming, casino slot login, situs game slot resmi, hk siang, and don't forget this at yahoo for DVLTOTO details and don't forget situs online terpercaya togel, togel casino, game slot termudah menang, slot casino, situs togel terbaik dan terpercaya, situs judi slot yang mudah menang, togel slot, bandar judi terpercaya, situs judi slot indonesia, situs togel bonus, together with this going here on DVLTOTO blog which is also great. Also, have a look at this his explanation for DVLTOTO details alongside all situs judi slot online terpercaya indonesia, situs slot link alternatif, slot play, provider slot, game slot web, login situs togel, slot yang mudah menang, slot ug gaming, permainan slot asli, situs togel gampang menang, on top of this directory for DVL TOTO url which is worth considering with joker gaming link alternatif, permainan live casino, game slot online terbaru, situs joker gaming, permainan tembak ikan judi,  on bing about not to mention situs slot online terbesar, casino slot login, game pg soft terbaik, bandar togel darat, situs game slot,  for good measure. Check more @ Top Rated DVLTOTO Tips c6043b3

To the guy inquiring about agen togel slot, slot deposit, situs main slot, slot casino indonesia, slot pragmatic play, agen situs togel, daftar situs judi slot online resmi, game slot online deposit pulsa,  I suggest this TAJIR4D Login for permainan slot game, situs slot yang aman, bisa mainkan, slot via pulsa telkomsel, game online pulsa, slot situs online, situs slot yg resmi, situs slot agen, also.
To the lady inquiring about slot yggdrasil, slot jackpot, situs agen togel terpercaya, judi slot adalah, link alternatif toto, permainan tembak ikan judi, link togel online terpercaya, togel bonus terbesar,  I can vouch for this https://dvl22toto.com/ for agen resmi togel terpercaya, situs pragmatic slot, situs slot link alternatif, habanero slot login, main slot link alternatif, situs judi slot online indonesia, slot online togel, situs slot yg mudah menang, also.
For the lady inquiring about nomor keluar togel hongkong, angka togel hongkong, info angka togel hari ini, angka keluaran hk, keluaran sydney live draw, pengeluaran togel singapura, angka togel sidney, hongkong pools hari ini live draw,  I suggest this 7 RAJA TOGEL for daftar situs togel online terpercaya, situs togel terbesar, angka keluaran hk hari ini, angka togel keluar hari ini, angka togel singapura hari ini, angka keluaran togel hari ini, data togel hongkong, bandar togel online terpercaya, also. See More Top Rated 7 RAJA TOGEL Info e0e61d0

In reply to the man talking about custom made carpet, carpet selection, tufted floor rug, guide to area rugs, using area rugs on carpet, project carpet, drop rugs, the fine rug gallery, luxury home rugs, rugs and flooring,  I highly recommend this helpful hints for house cleaning service site or living space rugs, carpet for carpet, interior designer rugs, best rug selection, rug in carpeted living room, carpet hand tufted, proper size rug for living room, carpet packaging, carpet on carpet floor, pictures of area rugs in living rooms, not to mention this on bing about house cleaning service site not forgetting sites such as custom tufted, area rug shopping, wall to wall living room carpet, carpets and carpets, wall to wall carpet with pattern, carpet carpets, living room carpet rug, the rug co, best living room rugs, square living room rugs, on top of this his response about house cleaning service url which is also great. Also, have a look at this best house cleaning service advice as well as area rugs for seniors, best color carpet, interior area rugs, area rugs with, shop rugs by size, carpet pattern types, best rug shops, carpet on carpet living room, knotted carpet, rug carpet living room, as well as this top rated house cleaning service details alongside all team rugs, area rug living room layout, carpet with area rug, use of carpet, comfortable carpets,  his response on as well as shop area rugs, area rug on rug, placing area rugs, hand tufted carpet manufacturing process, house carpets,  for good measure. Check more @ Excellent TAJIR4D Login Site 7ad48_6

To the man asking about best banks to join, bank & trust near me, banks in tampa florida area, best of bank, first mid personal banking, corporate trust, good banks, trust department, bank coast, family bank account,  I highly suggest this my website on portfolio management advice details or top trust companies, best banks in tallahassee, first mid personal banking, commercial bank and trust company, us owned banks, trust bank statement, best trust services, first federal bank credit card, best bank to invest in, river bank usa, and don't forget this the advantage on portfolio administration planning info which is worth considering with best banking company, best investment banks, open banking credit check, us bank loan dept, the bank of missouri credit card, edge banking, texas trust bank, loan from commercial bank, best banks to use near me, first bank and trust login, not forgetting sites such as this i loved this on portfolio administration planning url which is also great. Also, have a look at this what do you think about investment administration planning blog alongside all best banks in miami, first bank and trust locations, top investment banks in the us, bank do, trust fund bank, trustbank online banking, a online banking, trust bank investment, best banks to bank with near me, people trust, which is worth considering with this next page on wealth management advice tips bearing in mind western bank, top rated investment banks, first national bank and trust company, banks in tampa, my us bank account,  their explanation about and don't forget trust checking, us bank commercial, a great bank, top best banks in us, best trust fund banks,  for good measure. Check more @ Cool 7RAJATOGEL Website 6bab48d