chunk-29531240.a654d728.js 3.1 KB

1
  1. (window["webpackJsonp"]=window["webpackJsonp"]||[]).push([["chunk-29531240"],{"36bd":function(e,t,n){"use strict";var r=n("4bf8"),o=n("77f1"),a=n("9def");e.exports=function(e){var t=r(this),n=a(t.length),c=arguments.length,s=o(c>1?arguments[1]:void 0,n),i=c>2?arguments[2]:void 0,l=void 0===i?n:o(i,n);while(l>s)t[s++]=e;return t}},"4bf8d":function(e,t,n){"use strict";n.r(t),n.d(t,"export_table_to_excel",(function(){return f})),n.d(t,"export_json_to_excel",(function(){return v}));n("6b54"),n("ac6a");var r=n("2909"),o=(n("34ef"),n("21a6")),a=n("1146"),c=n.n(a);function s(e){for(var t=[],n=e.querySelectorAll("tr"),r=[],o=0;o<n.length;++o){for(var a=[],c=n[o],s=c.querySelectorAll("td"),i=0;i<s.length;++i){var l=s[i],h=l.getAttribute("colspan"),u=l.getAttribute("rowspan"),f=l.innerText;if(""!==f&&f==+f&&(f=+f),r.forEach((function(e){if(o>=e.s.r&&o<=e.e.r&&a.length>=e.s.c&&a.length<=e.e.c)for(var t=0;t<=e.e.c-e.s.c;++t)a.push(null)})),(u||h)&&(u=u||1,h=h||1,r.push({s:{r:o,c:a.length},e:{r:o+u-1,c:a.length+h-1}})),a.push(""!==f?f:null),h)for(var v=0;v<h-1;++v)a.push(null)}t.push(a)}return[t,r]}function i(e,t){t&&(e+=1462);var n=Date.parse(e);return(n-new Date(Date.UTC(1899,11,30)))/864e5}function l(e,t){for(var n={},r={s:{c:1e7,r:1e7},e:{c:0,r:0}},o=0;o!=e.length;++o)for(var a=0;a!=e[o].length;++a){r.s.r>o&&(r.s.r=o),r.s.c>a&&(r.s.c=a),r.e.r<o&&(r.e.r=o),r.e.c<a&&(r.e.c=a);var s={v:e[o][a]};if(null!=s.v){var l=c.a.utils.encode_cell({c:a,r:o});"number"===typeof s.v?s.t="n":"boolean"===typeof s.v?s.t="b":s.v instanceof Date?(s.t="n",s.z=c.a.SSF._table[14],s.v=i(s.v)):s.t="s",n[l]=s}}return r.s.c<1e7&&(n["!ref"]=c.a.utils.encode_range(r)),n}function h(){if(!(this instanceof h))return new h;this.SheetNames=[],this.Sheets={}}function u(e){for(var t=new ArrayBuffer(e.length),n=new Uint8Array(t),r=0;r!=e.length;++r)n[r]=255&e.charCodeAt(r);return t}function f(e){var t=document.getElementById(e),n=s(t),r=n[1],a=n[0],i="SheetJS",f=new h,v=l(a);v["!merges"]=r,f.SheetNames.push(i),f.Sheets[i]=v;var p=c.a.write(f,{bookType:"xlsx",bookSST:!1,type:"binary"});Object(o["saveAs"])(new Blob([u(p)],{type:"application/octet-stream"}),"test.xlsx")}function v(){var e=arguments.length>0&&void 0!==arguments[0]?arguments[0]:{},t=e.multiHeader,n=void 0===t?[]:t,a=e.header,s=e.data,i=e.filename,f=e.merges,v=void 0===f?[]:f,p=e.autoWidth,g=void 0===p||p,d=e.bookType,b=void 0===d?"xlsx":d;i=i||"excel-list",s=Object(r["a"])(s),s.unshift(a);for(var w=n.length-1;w>-1;w--)s.unshift(n[w]);var S="SheetJS",m=new h,y=l(s);if(v.length>0&&(y["!merges"]||(y["!merges"]=[]),v.forEach((function(e){y["!merges"].push(c.a.utils.decode_range(e))}))),g){var x=s.map((function(e){return e.map((function(e){return null==e?{wch:10}:e.toString().charCodeAt(0)>255?{wch:2*e.toString().length}:{wch:e.toString().length}}))})),A=x[0];try{for(var _=1;_<x.length;_++)for(var k=0;k<x[_].length;k++)A[k]["wch"]<x[_][k]["wch"]&&(A[k]["wch"]=x[_][k]["wch"])}catch(j){console.log(j)}y["!cols"]=A}m.SheetNames.push(S),m.Sheets[S]=y;var T=c.a.write(m,{bookType:b,bookSST:!1,type:"binary"});Object(o["saveAs"])(new Blob([u(T)],{type:"application/octet-stream"}),"".concat(i,".").concat(b))}}}]);