解决layui框架excel导出长数据科学计数法问题

2022-04-06   阅读:797   分类:前端    标签: Layui

Layui框架自带的导出excel数据默认导出的数据会以数字格式存放,比较长的数据存放后会经过科学计数法加工,从而导致数据错误

解决方法:

1、在/lib/layui-v2.5.5/lay/modules/table.js中搜索:d.exportFile

2、将d.exportFile这个函数,用下面内容替换掉:

    d.exportFile = function (e, t, i) {
        t = t || d.clearCacheKey(d.cache[e]), i = i || "csv";
        var a = c.config[e] || {}, // 分页按钮
          l = {csv: "text/csv", xls: "application/vnd.ms-excel"}[i], // meta格式
          n = document.createElement("a"), // a 标签
          type = i,
          meta = l,
          title = a.title
 
        layui.each(t, function (ks, vs) {
          var inner = {}
          layui.each(vs, function (k, v) {
            if (/^\d{9,}$/.test(v)) {
              vs[k] = vs[k] + '\t'
            }
            inner[k] = vs[k]
          });
          t[ks] = inner
        })
        if (r.ie) {
          var i = [], a = [];
          layui.each(t, function (t, l) {
            var n = [];
            "object" == typeof e ? (layui.each(e, function (e, a) {
              0 == t && i.push(a || "")
            }), layui.each(d.clearCacheKey(l), function (e, t) {
              n.push(t)
            })) : d.eachCols(e, function (e, a) {
              a.field && "normal" == a.type && !a.hide && (0 == t && i.push(a.title || ""), n.push(l[a.field]))
            }), a.push(n.join(","))
          });
          var data = i.join(",") + "\r\n" + a.join("\r\n")
          navigator.msSaveBlob(new Blob(['\ufeff' + data], {type: meta + ';charset=utf-8;'}), title + '.' + type)
        } else {
          return n.href = "data:" + l + ";charset=utf-8,\ufeff" + encodeURIComponent(function () {
            var i = [], a = [];
            return layui.each(t, function (t, l) {
              var n = [];
              "object" == typeof e ? (layui.each(e, function (e, a) {
                0 == t && i.push(a || "")
              }), layui.each(d.clearCacheKey(l), function (e, t) {
                n.push(t)
              })) : d.eachCols(e, function (e, a) {
                a.field && "normal" == a.type && !a.hide && (0 == t && i.push(a.title || ""), n.push(l[a.field]))
              }), a.push(n.join(","))
            }), i.join(",") + "\r\n" + a.join("\r\n")
          }()), n.download = (a.title || "table_" + (a.index || "")) + "." + i, document.body.appendChild(n), n.click(), void document.body.removeChild(n)}
      },
【腾讯云】云服务器等爆品抢先购,服务器108元每年

‘简忆博客’微信公众号 扫码关注‘简忆博客’微信公众号,获取最新文章动态
转载:请说明文章出处“来源简忆博客”。http://www.tpxhm.com/fdetail/887.html

×
觉得文章有用就打赏一下文章作者
微信扫一扫打赏 微信扫一扫打赏
支付宝扫一扫打赏 支付宝扫一扫打赏

文章评论(0)

登录
简忆博客壁纸 头像

简忆博客
勤于学习,乐于分享。

置顶推荐

打赏本站

如果你觉得本站很棒,可以通过扫码支付打赏哦!
微信扫码:你说多少就多少~
微信扫码
支付宝扫码:你说多少就多少~
支付宝扫码
×