@libs-jd/xlsx-parse-table
Advanced tools
Comparing version 1.0.9 to 1.0.10
@@ -1,1 +0,1 @@ | ||
"use strict";function t(t){const e=t.replace(/[0-9]/g,""),n=t.replace(/[^0-9]/g,"");let o=0;for(let t=0;t<e.length;t++)o=26*o+e.charCodeAt(t)-"A".charCodeAt(0);return[parseInt(n)-1,o]}function e(t){const e=[];let n=null;for(let o=0;o<t.length;o++){let r=t[o].some((t=>""!==t));r&&!n?n={startRow:o,endRow:o}:r&&n?n.endRow=o:!r&&n&&(e.push(n),n=null)}return n&&e.push(n),e}function n(t,e){const n=[];let o=1/0,r=-1;for(let n=e.startRow;n<=e.endRow;n++)for(let e=0;e<t[n].length;e++)""!==t[n][e]&&(o=Math.min(o,e),r=Math.max(r,e));for(let l=e.startRow;l<=e.endRow;l++){const e=t[l].slice(o,r+1);n.push(e)}return n}function o(t){const e=function(t){const e=[];for(let n=0;n<t[0].length-1;n++){let o=!0;for(let e=0;e<t.length;e++)if(""!==t[e][n]){o=!1;break}o&&e.push(n)}return e}(t);if(0===e.length)return[t];const n=[];let o=0;for(const r of e){if(r>o){const e=t.map((t=>t.slice(o,r))).filter((t=>t.some((t=>""!==t))));n.push(e)}o=r+1}if(o<t[0].length){const e=t.map((t=>t.slice(o))).filter((t=>t.some((t=>""!==t))));n.push(e)}return n.filter((t=>t.some((t=>t.some((t=>""!==t))))))}function r(e){const n=function(e){let n=0,o=0;Object.keys(e).forEach((e=>{if(e.match(/^[A-Z]+[0-9]+$/)){const[r,l]=t(e);n=Math.max(n,r),o=Math.max(o,l)}}));const r=Array(n+1).fill().map((()=>Array(o+1).fill("")));return Object.entries(e).forEach((([e,n])=>{if(e.match(/^[A-Z]+[0-9]+$/)){const[o,l]=t(e);r[o][l]=n.v||""}})),r}(e);return l([n])}function l(t){let r=[];for(const l of t){const t=e(l).map((t=>n(l,t))).flatMap((t=>o(t)));r.push(...t)}return r.length>t.length?l(r):r}var s={parse:t=>r(t)};module.exports=s; | ||
"use strict";function t(t){const e=t.match(/([A-Z]+)(\d+)/);if(!e)return[-1,-1];const[,n,r]=e,s=n.split("").reduce(((t,e)=>26*t+e.charCodeAt(0)-65),0);return[parseInt(r)-1,s]}function e(e){const r=function(e){const n=Object.entries(e).filter((([t])=>t.match(/^[A-Z]+[0-9]+$/))),[r,s]=n.reduce((([e,n],[r])=>{const[s,l]=t(r);return[Math.max(e,s),Math.max(n,l)]}),[-1,-1]),l=Array(r+1).fill().map((()=>Array(s+1).fill("")));return n.forEach((([e,n])=>{const[r,s]=t(e);l[r][s]=n.v||""})),l}(e);return function(t){const e=[];let r=null;for(let s=0;s<t.length;s++){t[s].some((t=>""!==t))?r?r.end=s:r={start:s,end:s}:r&&(e.push(n(t,r)),r=null)}r&&e.push(n(t,r));return e.flatMap((t=>{const e=[];for(let n=0;n<t[0].length-1;n++)t.every((t=>""===t[n]))&&e.push(n);if(!e.length)return[t];const n=[];let r=0;for(const s of e){if(s>r){const e=t.map((t=>t.slice(r,s))).filter((t=>t.some((t=>""!==t))));e.length&&n.push(e)}r=s+1}if(r<t[0].length){const e=t.map((t=>t.slice(r))).filter((t=>t.some((t=>""!==t))));e.length&&n.push(e)}return n}))}(r)}function n(t,{start:e,end:n}){let r=1/0,s=-1;for(let l=e;l<=n;l++)for(let e=0;e<t[l].length;e++)""!==t[l][e]&&(r=Math.min(r,e),s=Math.max(s,e));return t.slice(e,n+1).map((t=>t.slice(r,s+1)))}var r={parse:t=>e(t)};module.exports=r; |
{ | ||
"name": "@libs-jd/xlsx-parse-table", | ||
"description": "Modern Excel/XLSX parser and streaming capabilities", | ||
"version": "1.0.9", | ||
"version": "1.0.10", | ||
"homepage": "https://github.com/jeet-dhandha/xlsx-parse-table", | ||
@@ -6,0 +6,0 @@ "author": "Jeet Dhandha", |
Trivial Package
Supply chain riskPackages less than 10 lines of code are easily copied into your own project and may not warrant the additional supply chain risk of an external dependency.
Found 1 instance in 1 package
Trivial Package
Supply chain riskPackages less than 10 lines of code are easily copied into your own project and may not warrant the additional supply chain risk of an external dependency.
Found 1 instance in 1 package
3365
5