layui 数据表格自带的导出Excel,身份证等E+/000问题解决

                         <script type="text/html" id="ReportTBtoolbar">

                             <div class="layui-btn-container">

                                 <button class="layui-btn layui-btn-sm" lay-event="seeReport"><i class="layui-icon"></i>查看报告</button>

                                 <button class="layui-btn layui-btn-sm" lay-event="printReport"><i class="layui-icon"></i>打印报告</button>

                                 <button class="layui-btn layui-btn-sm" lay-event="printBarCode"><i class="layui-icon"></i>打印条码</button>

                             </div>

                             <div class="layui-table-tool-self_diy">

                                 <span class="layui-inline yutons-header-tool" title="筛选列" lay-event="LAYTABLE_COLS">

                                     <i class="layui-icon layui-icon-cols"></i>

                                 </span>

                                 <span class="layui-inline yutons-header-tool" title="导出Excel" lay-event="table_export">

                                     <i class="layui-icon layui-icon-export"></i>

                                 </span>

                                 <span class="layui-inline yutons-header-tool" title="打印" lay-event="LAYTABLE_PRINT">

                                     <i class="layui-icon layui-icon-print"></i>

                                 </span>

                             </div>

                         </script>

     //头工具栏事件

     table.on('toolbar(ReportTB)', function (obj) {

         var checkStatus = table.checkStatus(obj.config.id);

         switch (obj.event) {

             case 'table_export':

                 exportFile('ReportTB');

                 break;

         };

     });

 if (!Array.from) {

     Array.from = function (el) {

         return Array.apply(this, el);

     }

 }

 function exportFile(id) {

     //根据传入tableID获取表头

     var headers = $("div[lay-id=" + id + "] .layui-table-box table").get(0);

     var htrs = Array.from(headers.querySelectorAll('tr'));

     var titles = {};

     for (var j = 0; j < htrs.length; j++) {

         var hths = Array.from(htrs[j].querySelectorAll("th"));

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

             var clazz = hths[i].getAttributeNode('class').value;

             if (clazz != ' layui-table-col-special' && clazz != 'layui-hide') {

                 //排除居左、具有、隐藏字段

                 //修改:默认字段data-field+i,兼容部分数据表格中不存在data-field值的问题

                 titles['data-field' + i] = hths[i].innerText;

             }

         }

     }

     //根据传入tableID获取table内容

     var bodys = $("div[lay-id=" + id + "] .layui-table-box table").get(1);

     var btrs = Array.from(bodys.querySelectorAll("tr"))

     var bodysArr = new Array();

     for (var j = 0; j < btrs.length; j++) {

         var contents = {};

         var btds = Array.from(btrs[j].querySelectorAll("td"));

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

             for (var key in titles) {

                 //修改:默认字段data-field+i,兼容部分数据表格中不存在data-field值的问题

                 var field = 'data-field' + i;

                 if (field === key) {

                     //根据表头字段获取table内容字段

                     contents[field] = btds[i].innerText;

                 }

             }

         }

         bodysArr.push(contents)

     }

     //将标题行置顶添加到数组

     bodysArr.unshift(titles);

     //导出excel

     excel.exportExcel({

         sheet1: bodysArr

     }, '用户表' + new Date().toLocaleString() + '.xlsx', 'xlsx');

 }

 if (!Array.from) {

       Array.from = function (el) {

           return Array.apply(this, el);

       }

   }