deno.land / x / sheetjs@v0.18.3 / modules / 83_numbers.js
نووسراو ببینە
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668var NUMBERS = !Object.defineProperty ? (void 0) :(function() { var __defProp = Object.defineProperty; var __getOwnPropDesc = Object.getOwnPropertyDescriptor; var __getOwnPropNames = Object.getOwnPropertyNames; var __hasOwnProp = Object.prototype.hasOwnProperty; var __markAsModule = function(target) { return __defProp(target, "__esModule", { value: true }); }; var __export = function(target, all) { for (var name in all) __defProp(target, name, { get: all[name], enumerable: true }); }; var __reExport = function(target, module, copyDefault, desc) { if (module && typeof module === "object" || typeof module === "function") for (var keys = __getOwnPropNames(module), i = 0, n = keys.length, key; i < n; i++) { key = keys[i]; if (!__hasOwnProp.call(target, key) && (copyDefault || key !== "default")) __defProp(target, key, { get: function(k) { return module[k]; }.bind(null, key), enumerable: !(desc = __getOwnPropDesc(module, key)) || desc.enumerable }); } return target; }; var __toCommonJS = /* @__PURE__ */ function(cache) { return function(module, temp) { return cache && cache.get(module) || (temp = __reExport(__markAsModule({}), module, 1), cache && cache.set(module, temp), temp); }; }(typeof WeakMap !== "undefined" ? /* @__PURE__ */ new WeakMap() : 0);
// 83_numbers.ts var numbers_exports = {}; __export(numbers_exports, { parse_numbers: function() { return numbers_default; } });
// src/util.ts var u8_to_dataview = function(array) { return new DataView(array.buffer, array.byteOffset, array.byteLength); }; var u8str = function(u8) { return typeof TextDecoder != "undefined" ? new TextDecoder().decode(u8) : utf8read(a2s(u8)); }; var u8concat = function(u8a) { var len = u8a.reduce(function(acc, x) { return acc + x.length; }, 0); var out = new Uint8Array(len); var off = 0; u8a.forEach(function(u8) { out.set(u8, off); off += u8.length; }); return out; }; var popcnt = function(x) { x -= x >> 1 & 1431655765; x = (x & 858993459) + (x >> 2 & 858993459); return (x + (x >> 4) & 252645135) * 16843009 >>> 24; }; var readDecimal128LE = function(buf, offset) { var exp = (buf[offset + 15] & 127) << 7 | buf[offset + 14] >> 1; var mantissa = buf[offset + 14] & 1; for (var j = offset + 13; j >= offset; --j) mantissa = mantissa * 256 + buf[j]; return (buf[offset + 15] & 128 ? -mantissa : mantissa) * Math.pow(10, exp - 6176); };
// src/proto.ts function parse_varint49(buf, ptr) { var l = ptr ? ptr[0] : 0; var usz = buf[l] & 127; varint: if (buf[l++] >= 128) { usz |= (buf[l] & 127) << 7; if (buf[l++] < 128) break varint; usz |= (buf[l] & 127) << 14; if (buf[l++] < 128) break varint; usz |= (buf[l] & 127) << 21; if (buf[l++] < 128) break varint; usz += (buf[l] & 127) * Math.pow(2, 28); ++l; if (buf[l++] < 128) break varint; usz += (buf[l] & 127) * Math.pow(2, 35); ++l; if (buf[l++] < 128) break varint; usz += (buf[l] & 127) * Math.pow(2, 42); ++l; if (buf[l++] < 128) break varint; } if (ptr) ptr[0] = l; return usz; } function varint_to_i32(buf) { var l = 0, i32 = buf[l] & 127; varint: if (buf[l++] >= 128) { i32 |= (buf[l] & 127) << 7; if (buf[l++] < 128) break varint; i32 |= (buf[l] & 127) << 14; if (buf[l++] < 128) break varint; i32 |= (buf[l] & 127) << 21; if (buf[l++] < 128) break varint; i32 |= (buf[l] & 127) << 28; } return i32; } function parse_shallow(buf) { var out = [], ptr = [0]; while (ptr[0] < buf.length) { var off = ptr[0]; var num = parse_varint49(buf, ptr); var type = num & 7; num = Math.floor(num / 8); var len = 0; var res; if (num == 0) break; switch (type) { case 0: { var l = ptr[0]; while (buf[ptr[0]++] >= 128) ; res = buf.slice(l, ptr[0]); } break; case 5: len = 4; res = buf.slice(ptr[0], ptr[0] + len); ptr[0] += len; break; case 1: len = 8; res = buf.slice(ptr[0], ptr[0] + len); ptr[0] += len; break; case 2: len = parse_varint49(buf, ptr); res = buf.slice(ptr[0], ptr[0] + len); ptr[0] += len; break; case 3: case 4: default: throw new Error("PB Type ".concat(type, " for Field ").concat(num, " at offset ").concat(off)); } var v = { offset: off, data: res, type: type }; if (out[num] == null) out[num] = [v]; else out[num].push(v); } return out; } function mappa(data, cb) { if (!data) return []; return data.map(function(d) { var _a; try { return cb(d.data); } catch (e) { var m = (_a = e.message) == null ? void 0 : _a.match(/at offset (\d+)/); if (m) e.message = e.message.replace(/at offset (\d+)/, "at offset " + (+m[1] + d.offset)); throw e; } }); }
// src/frame.ts function deframe(buf) { var out = []; var l = 0; while (l < buf.length) { var t = buf[l++]; var len = buf[l] | buf[l + 1] << 8 | buf[l + 2] << 16; l += 3; out.push(parse_snappy_chunk(t, buf.slice(l, l + len))); l += len; } if (l !== buf.length) throw new Error("data is not a valid framed stream!"); return u8concat(out); } function parse_snappy_chunk(type, buf) { if (type != 0) throw new Error("Unexpected Snappy chunk type ".concat(type)); var ptr = [0]; var usz = parse_varint49(buf, ptr); var chunks = []; while (ptr[0] < buf.length) { var tag = buf[ptr[0]] & 3; if (tag == 0) { var len = buf[ptr[0]++] >> 2; if (len < 60) ++len; else { var c = len - 59; len = buf[ptr[0]]; if (c > 1) len |= buf[ptr[0] + 1] << 8; if (c > 2) len |= buf[ptr[0] + 2] << 16; if (c > 3) len |= buf[ptr[0] + 3] << 24; len >>>= 0; len++; ptr[0] += c; } chunks.push(buf.slice(ptr[0], ptr[0] + len)); ptr[0] += len; continue; } else { var offset = 0, length = 0; if (tag == 1) { length = (buf[ptr[0]] >> 2 & 7) + 4; offset = (buf[ptr[0]++] & 224) << 3; offset |= buf[ptr[0]++]; } else { length = (buf[ptr[0]++] >> 2) + 1; if (tag == 2) { offset = buf[ptr[0]] | buf[ptr[0] + 1] << 8; ptr[0] += 2; } else { offset = (buf[ptr[0]] | buf[ptr[0] + 1] << 8 | buf[ptr[0] + 2] << 16 | buf[ptr[0] + 3] << 24) >>> 0; ptr[0] += 4; } } chunks = [u8concat(chunks)]; if (offset == 0) throw new Error("Invalid offset 0"); if (offset > chunks[0].length) throw new Error("Invalid offset beyond length"); if (length >= offset) { chunks.push(chunks[0].slice(-offset)); length -= offset; while (length >= chunks[chunks.length - 1].length) { chunks.push(chunks[chunks.length - 1]); length -= chunks[chunks.length - 1].length; } } chunks.push(chunks[0].slice(-offset, -offset + length)); } } var o = u8concat(chunks); if (o.length != usz) throw new Error("Unexpected length: ".concat(o.length, " != ").concat(usz)); return o; }
// src/iwa.ts function parse_iwa(buf) { var out = [], ptr = [0]; while (ptr[0] < buf.length) { var len = parse_varint49(buf, ptr); var ai = parse_shallow(buf.slice(ptr[0], ptr[0] + len)); ptr[0] += len; var res = { id: varint_to_i32(ai[1][0].data), messages: [] }; ai[2].forEach(function(b) { var mi = parse_shallow(b.data); var fl = varint_to_i32(mi[3][0].data); res.messages.push({ meta: mi, data: buf.slice(ptr[0], ptr[0] + fl) }); ptr[0] += fl; }); out.push(res); } return out; }
// src/cell.ts function parse_old_storage(buf, sst, rsst) { var dv = u8_to_dataview(buf); var ctype = buf[buf[0] == 4 ? 1 : 2]; var flags = dv.getUint32(4, true); var data_offset = 12 + popcnt(flags & 3470) * 4; var ridx = -1, sidx = -1, ieee = NaN, dt = new Date(2001, 0, 1); if (flags & 512) { ridx = dv.getUint32(data_offset, true); data_offset += 4; } data_offset += popcnt(flags & 12288) * 4; if (flags & 16) { sidx = dv.getUint32(data_offset, true); data_offset += 4; } if (flags & 32) { ieee = dv.getFloat64(data_offset, true); data_offset += 8; } if (flags & 64) { dt.setTime(dt.getTime() + dv.getFloat64(data_offset, true) * 1e3); data_offset += 8; } var ret; switch (ctype) { case 0: break; case 2: ret = { t: "n", v: ieee }; break; case 3: ret = { t: "s", v: sst[sidx] }; break; case 5: ret = { t: "d", v: dt }; break; case 6: ret = { t: "b", v: ieee > 0 }; break; case 7: ret = { t: "n", v: ieee }; break; case 8: ret = { t: "e", v: 0 }; break; case 9: { if (ridx > -1) ret = { t: "s", v: rsst[ridx] }; else if (sidx > -1) ret = { t: "s", v: sst[sidx] }; else if (!isNaN(ieee)) ret = { t: "n", v: ieee }; else throw new Error("Unsupported cell type ".concat(buf.slice(0, 4))); } break; default: throw new Error("Unsupported cell type ".concat(buf.slice(0, 4))); } return ret; } function parse_storage(buf, sst, rsst) { var dv = u8_to_dataview(buf); var ctype = buf[1]; var flags = dv.getUint32(8, true); var data_offset = 12; var ridx = -1, sidx = -1, d128 = NaN, ieee = NaN, dt = new Date(2001, 0, 1); if (flags & 1) { d128 = readDecimal128LE(buf, data_offset); data_offset += 16; } if (flags & 2) { ieee = dv.getFloat64(data_offset, true); data_offset += 8; } if (flags & 4) { dt.setTime(dt.getTime() + dv.getFloat64(data_offset, true) * 1e3); data_offset += 8; } if (flags & 8) { sidx = dv.getUint32(data_offset, true); data_offset += 4; } if (flags & 16) { ridx = dv.getUint32(data_offset, true); data_offset += 4; } var ret; switch (ctype) { case 0: break; case 2: ret = { t: "n", v: d128 }; break; case 3: ret = { t: "s", v: sst[sidx] }; break; case 5: ret = { t: "d", v: dt }; break; case 6: ret = { t: "b", v: ieee > 0 }; break; case 7: ret = { t: "n", v: ieee }; break; case 8: ret = { t: "e", v: 0 }; break; case 9: { if (ridx > -1) ret = { t: "s", v: rsst[ridx] }; else throw new Error("Unsupported cell type ".concat(ctype, " : ").concat(flags & 31, " : ").concat(buf.slice(0, 4))); } break; case 10: ret = { t: "n", v: d128 }; break; default: throw new Error("Unsupported cell type ".concat(ctype, " : ").concat(flags & 31, " : ").concat(buf.slice(0, 4))); } return ret; } function parse(buf, sst, rsst) { switch (buf[0]) { case 3: case 4: return parse_old_storage(buf, sst, rsst); case 5: return parse_storage(buf, sst, rsst); default: throw new Error("Unsupported payload version ".concat(buf[0])); } }
// src/numbers.ts var encode_col = function(C) { var s = ""; for (++C; C; C = Math.floor((C - 1) / 26)) s = String.fromCharCode((C - 1) % 26 + 65) + s; return s; }; var encode_cell = function(c) { return "".concat(encode_col(c.c)).concat(c.r + 1); }; var encode_range = function(r) { return encode_cell(r.s) + ":" + encode_cell(r.e); }; var book_new = function() { return { Sheets: {}, SheetNames: [] }; }; var book_append_sheet = function(wb, ws, name) { if (!name) for (var i = 1; i < 9999; ++i) { if (wb.SheetNames.indexOf(name = "Sheet ".concat(i)) == -1) break; } else if (wb.SheetNames.indexOf(name) > -1) for (var i = 1; i < 9999; ++i) { if (wb.SheetNames.indexOf("".concat(name, "_").concat(i)) == -1) { name = "".concat(name, "_").concat(i); break; } } wb.SheetNames.push(name); wb.Sheets[name] = ws; }; function parse_numbers(cfb) { var out = []; cfb.FullPaths.forEach(function(p) { if (p.match(/\.iwpv2/)) throw new Error("Unsupported password protection"); }); cfb.FileIndex.forEach(function(s) { if (!s.name.match(/\.iwa$/)) return; var o; try { o = deframe(s.content); } catch (e) { return console.log("?? " + s.content.length + " " + (e.message || e)); } var packets; try { packets = parse_iwa(o); } catch (e) { return console.log("## " + (e.message || e)); } packets.forEach(function(packet) { out[+packet.id] = packet.messages; }); }); if (!out.length) throw new Error("File has no messages"); var docroot; out.forEach(function(iwams) { iwams.forEach(function(iwam) { var mtype = varint_to_i32(iwam.meta[1][0].data) >>> 0; if (mtype == 1) { if (!docroot) docroot = iwam; else throw new Error("Document has multiple roots"); } }); }); if (!docroot) throw new Error("Cannot find Document root"); return parse_docroot(out, docroot); } var numbers_default = parse_numbers; function parse_Reference(buf) { var pb = parse_shallow(buf); return parse_varint49(pb[1][0].data); } function parse_TST_TableDataList(M, root) { var pb = parse_shallow(root.data); var type = varint_to_i32(pb[1][0].data); var entries = pb[3]; var data = []; (entries || []).forEach(function(entry) { var le = parse_shallow(entry.data); var key = varint_to_i32(le[1][0].data) >>> 0; switch (type) { case 1: data[key] = u8str(le[3][0].data); break; case 8: { var rt = M[parse_Reference(le[9][0].data)][0]; var rtp = parse_shallow(rt.data); var rtpref = M[parse_Reference(rtp[1][0].data)][0]; var mtype = varint_to_i32(rtpref.meta[1][0].data); if (mtype != 2001) throw new Error("2000 unexpected reference to ".concat(mtype)); var tswpsa = parse_shallow(rtpref.data); data[key] = tswpsa[3].map(function(x) { return u8str(x.data); }).join(""); } break; } }); return data; } function parse_TST_TileRowInfo(u8) { var _a, _b, _c, _d, _e, _f, _g, _h, _i, _j; var pb = parse_shallow(u8); var R = varint_to_i32(pb[1][0].data) >>> 0; var pre_bnc = (_b = (_a = pb[3]) == null ? void 0 : _a[0]) == null ? void 0 : _b.data; var pre_bnc_offsets = ((_d = (_c = pb[4]) == null ? void 0 : _c[0]) == null ? void 0 : _d.data) && u8_to_dataview(pb[4][0].data); var storage = (_f = (_e = pb[6]) == null ? void 0 : _e[0]) == null ? void 0 : _f.data; var storage_offsets = ((_h = (_g = pb[7]) == null ? void 0 : _g[0]) == null ? void 0 : _h.data) && u8_to_dataview(pb[7][0].data); var wide_offsets = ((_j = (_i = pb[8]) == null ? void 0 : _i[0]) == null ? void 0 : _j.data) && varint_to_i32(pb[8][0].data) > 0 || false; var width = wide_offsets ? 4 : 1; var cells = []; var off = 0; for (var C = 0; C < pre_bnc_offsets.byteLength / 2; ++C) { if (storage && storage_offsets) { off = storage_offsets.getUint16(C * 2, true) * width; if (off < storage.length) { cells[C] = storage.subarray(off, storage_offsets.getUint16(C * 2 + 2, true) * width); continue; } } if (pre_bnc && pre_bnc_offsets) { off = pre_bnc_offsets.getUint16(C * 2, true) * width; if (off < pre_bnc.length) cells[C] = pre_bnc.subarray(off, pre_bnc_offsets.getUint16(C * 2 + 2, true) * width); } } return { R: R, cells: cells }; } function parse_TST_Tile(M, root) { var pb = parse_shallow(root.data); var ri = mappa(pb[5], parse_TST_TileRowInfo); return ri.reduce(function(acc, x) { if (!acc[x.R]) acc[x.R] = []; x.cells.forEach(function(cell, C) { if (acc[x.R][C]) throw new Error("Duplicate cell r=".concat(x.R, " c=").concat(C)); acc[x.R][C] = cell; }); return acc; }, []); } function parse_TST_TableModelArchive(M, root, ws) { var _a; var pb = parse_shallow(root.data); var range = { s: { r: 0, c: 0 }, e: { r: 0, c: 0 } }; range.e.r = (varint_to_i32(pb[6][0].data) >>> 0) - 1; if (range.e.r < 0) throw new Error("Invalid row varint ".concat(pb[6][0].data)); range.e.c = (varint_to_i32(pb[7][0].data) >>> 0) - 1; if (range.e.c < 0) throw new Error("Invalid col varint ".concat(pb[7][0].data)); ws["!ref"] = encode_range(range); { var store = parse_shallow(pb[4][0].data); var sst = parse_TST_TableDataList(M, M[parse_Reference(store[4][0].data)][0]); var rsst = ((_a = store[17]) == null ? void 0 : _a[0]) ? parse_TST_TableDataList(M, M[parse_Reference(store[17][0].data)][0]) : []; { var tile = parse_shallow(store[3][0].data); var tiles = []; tile[1].forEach(function(t) { var tl = parse_shallow(t.data); var ref = M[parse_Reference(tl[2][0].data)][0]; var mtype = varint_to_i32(ref.meta[1][0].data); if (mtype != 6002) throw new Error("6001 unexpected reference to ".concat(mtype)); tiles.push({ id: varint_to_i32(tl[1][0].data), ref: parse_TST_Tile(M, ref) }); }); tiles.forEach(function(tile2) { tile2.ref.forEach(function(row, R) { row.forEach(function(buf, C) { var addr = encode_cell({ r: R, c: C }); var res = parse(buf, sst, rsst); if (res) ws[addr] = res; }); }); }); } } } function parse_TST_TableInfoArchive(M, root) { var pb = parse_shallow(root.data); var out = { "!ref": "A1" }; var tableref = M[parse_Reference(pb[2][0].data)]; var mtype = varint_to_i32(tableref[0].meta[1][0].data); if (mtype != 6001) throw new Error("6000 unexpected reference to ".concat(mtype)); parse_TST_TableModelArchive(M, tableref[0], out); return out; } function parse_sheetroot(M, root) { var _a; var pb = parse_shallow(root.data); var out = { name: ((_a = pb[1]) == null ? void 0 : _a[0]) ? u8str(pb[1][0].data) : "", sheets: [] }; var shapeoffs = mappa(pb[2], parse_Reference); shapeoffs.forEach(function(off) { M[off].forEach(function(m) { var mtype = varint_to_i32(m.meta[1][0].data); if (mtype == 6e3) out.sheets.push(parse_TST_TableInfoArchive(M, m)); }); }); return out; } function parse_docroot(M, root) { var out = book_new(); var pb = parse_shallow(root.data); var sheetoffs = mappa(pb[1], parse_Reference); sheetoffs.forEach(function(off) { M[off].forEach(function(m) { var mtype = varint_to_i32(m.meta[1][0].data); if (mtype == 2) { var root2 = parse_sheetroot(M, m); root2.sheets.forEach(function(sheet) { book_append_sheet(out, sheet, root2.name); }); } }); }); if (out.SheetNames.length == 0) throw new Error("Empty NUMBERS file"); return out; } return __toCommonJS(numbers_exports);})();/*! sheetjs (C) 2013-present SheetJS -- http://sheetjs.com */
sheetjs
Version Info
2 years ago
