{"version":3,"sources":["jsdelivr-header.js","/npm/js-xlsx-util@1.0.0/index.js"],"names":[],"mappings":"AAAA;AACA;AACA;AACA;AACA;AACA;AACA,ACNA,IAAI,KAAO,QAAQ,QACf,GAAK,QAAQ,MACb,KAAO,QAAQ,QAEf,YAAc,CACd,EAAG,EACH,EAAG,EACH,EAAG,EACH,EAAG,EACH,EAAG,EACH,EAAG,EACH,EAAG,EACH,EAAG,EACH,EAAG,EACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,GACH,EAAG,IAEH,QAAU,CAAC,KAAK,OAAO,OAAO,KAAK,cAyCvC,SAAS,gBAAgB,GACrB,IAAI,EACJ,QAAQ,KAAK,GAAO,SAAU,EAAK,GAC/B,EAAS,QAAQ,UAAU,GAC3B,EAAM,IAAM,EAAO,IACnB,EAAM,IAAM,EAAO,IACnB,EAAM,IAAM,SAAU,GAElB,OADA,EAAM,GAAO,EACN,EAAM,EAAM,KAAO,EAAM,IAAM,GAC1C,EACA,EAAM,OAAS,SAAU,GAErB,OADA,EAAM,GAAO,EACN,EAAM,EAAM,KAAO,EAAM,IAAM,GAC1C,EACA,EAAM,KAAO,SAAU,GACnB,EAAM,GAAO,EAEb,IADA,IAAI,EAAO,EAAU,EAAM,IACpB,GAEH,EADA,EAAS,QAAQ,WAAW,GAE5B,GAAO,EAEX,OAAO,EAAM,EAAS,EAAM,IAChC,EACA,EAAM,MAAQ,SAAU,GACpB,EAAM,GAAO,EAEb,IADA,IAAI,EAAM,EAAU,EAAM,IACnB,GAEH,EADA,EAAQ,QAAQ,WAAW,GAE3B,GAAO,EAEX,OAAO,EAAM,EAAQ,EAAM,IAC/B,CACJ,GACJ,CApEA,QAAQ,SAAW,SAAkB,EAAU,GAC3C,IAGI,EAHA,EAAU,KAAK,QAAQ,GACvB,EAAW,KAAK,SAAS,GACzB,EAAW,KAAK,QAAQ,EAAS,EAAW,SAWhD,OATI,EACA,EAAW,KAAK,SAAS,GAClB,GAAG,WAAW,GACrB,EAAW,QAAQ,IAEnB,EAAW,KAAK,SAAS,GACzB,GAAG,cAAc,EAAU,KAAK,UAAU,GAAW,SAEzD,QAAQ,WAAW,GACZ,CACX,EAKA,QAAQ,WAAa,SAAU,GACvB,cAAe,EACf,EAAK,WAAW,SAAQ,SAAU,GAC9B,gBAAgB,EAAK,OAAO,GAChC,IAEA,gBAAgB,EAExB,EA8CA,QAAQ,WAAa,SAAoB,GACrC,IAAI,EAOA,GADJ,GAJI,EADqB,iBAAd,EACD,EAEA,EAAU,KAEV,eACK,EAAI,OAAS,GACxB,EAAkB,YAAY,GAClC,OAAwB,IAApB,EACsB,IAAf,EAAI,OAAe,GAAM,QAAQ,WAAW,EAAI,MAAM,GAAI,IAAM,IAErD,IAAf,EAAI,OAAe,QAAQ,EAAkB,GAAM,EAAI,MAAM,GAAI,GAAK,QAAQ,EAAkB,EAC3G,EAMA,QAAQ,WAAa,SAAoB,GACrC,IAAI,EAOA,GADJ,GAJI,EADqB,iBAAd,EACD,EAEA,EAAU,KAEV,eACK,EAAI,OAAS,GACxB,EAAkB,YAAY,GAClC,OAAwB,KAApB,GACuB,IAAf,EAAI,OAAe,IAAM,QAAQ,WAAW,EAAI,MAAM,GAAI,KAAO,IAEvD,IAAf,EAAI,OAAe,QAAQ,EAAkB,GAAM,EAAI,MAAM,GAAI,GAAK,QAAQ,EAAkB,EAC3G,EAMA,QAAQ,UAAY,SAAmB,GACnC,IACI,EAAQ,EAAI,MADF,mBAEd,MAAO,CACH,IAAK,EAAQ,EAAM,IAAM,EACzB,IAAK,EAAQ,SAAS,EAAM,KAAO,EAE3C,EAMA,QAAQ,KAAO,SAAU,EAAW,GAChC,IAAK,IAAI,KAAO,EACR,EAAU,eAAe,IAAmB,MAAX,EAAI,IAAc,GACnD,EAAS,EAAK,EAAU,GAAM,EAG1C,EAQA,QAAQ,OAAS,SAAgB,EAAW,GACxC,IAAI,EAAS,GACb,IAAK,IAAI,KAAO,EACR,EAAU,eAAe,IAAmB,MAAX,EAAI,IACjC,GAAM,EAAG,EAAK,EAAU,GAAM,IAC9B,EAAO,KAAK,EAAU,IAIlC,OAAO,CACX,EAMA,QAAQ,SAAW,SAAkB,GACjC,GAAI,EAAU,QACV,OAAO,EAAU,QAErB,IAAI,EAAO,OAAO,KAAK,GACvB,OAAO,EAAK,GAAK,IAAM,EAAK,EAAK,OAAS,EAC9C,EAMA,QAAQ,KAAO,SAAc,GACzB,MAAmB,iBAAR,EACA,CAAC,EAAG,IAAK,EAAG,GAEhB,CAAC,EAAG,IAAK,EAAG,EAAI,WAC3B,EAMA,QAAQ,UAAY,SAAU,EAAU,GACpC,KAAK,UAAU,EAAU,EAC7B,EAOA,QAAQ,QAAU,SAAiB,EAAG,GAClC,OAAO,EAAE,WAAW,SAAW,EAAE,WAAW,MAChD,EAMA,QAAQ,YAAc,SAAU,GAC5B,YAAsB,IAAR,CAClB,EAMA,QAAQ,UAAY,SAAU,GAC1B,YAAsB,IAAR,CAClB,EAIA,QAAQ,OAAS,SAAgB,EAAW,GACxC,IAAI,EAAM,EAAU,SAAW,QAAQ,SAAS,GAC5C,EAAU,QAAQ,UAAU,EAAI,MAAM,KAAK,IAAI,IACnD,IAAK,IAAI,KAAO,EACR,EAAO,eAAe,KACD,iBAAX,GAAuB,EAAO,EACpC,EAAU,GAAO,EAAU,IAAM,EAAO,GAExC,EAAU,GAAO,EAAU,IAAM,QAAQ,KAAK,EAAO,IAIrE,EAOA,QAAQ,aAAe,SAAsB,EAAU,EAAW,GACzD,EAAS,SACV,EAAS,OAAS,CAAC,GAElB,EAAS,aACV,EAAS,WAAa,IAE1B,EAAS,OAAO,GAAa,GACmB,IAA5C,EAAS,WAAW,QAAQ,IAC5B,EAAS,WAAW,KAAK,EAEjC","file":"/npm/js-xlsx-util@1.0.0/index.js","sourceRoot":"","sourcesContent":["/**\n * Minified by jsDelivr using Terser v5.37.0.\n * Original file: /npm/js-xlsx-util@1.0.0/index.js\n *\n * Do NOT use SRI with dynamically generated files! More information: https://www.jsdelivr.com/using-sri-with-dynamic-files\n */\n","var xlsx = require('xlsx');\nvar fs = require('fs');\nvar path = require('path');\n\nvar LETTERS_OBJ = {\n    A: 1,\n    B: 2,\n    C: 3,\n    D: 4,\n    E: 5,\n    F: 6,\n    G: 7,\n    H: 8,\n    I: 9,\n    J: 10,\n    K: 11,\n    L: 12,\n    M: 13,\n    N: 14,\n    O: 15,\n    P: 16,\n    Q: 17,\n    R: 18,\n    S: 19,\n    T: 20,\n    U: 21,\n    V: 22,\n    W: 23,\n    X: 24,\n    Y: 25,\n    Z: 26\n};\nvar LETTERS = ['0'].concat(Object.keys(LETTERS_OBJ));\n\n/**\n * 读取文件内容,缓存\n * @param xlsxPath - xlsx路径\n * @param noCache - 是否缓存,默认缓存\n * @returns {*}\n */\nexports.readFile = function readFile(xlsxPath, noCache) {\n    var xlsxDir = path.dirname(xlsxPath);\n    var xlsxName = path.basename(xlsxPath);\n    var jsonPath = path.resolve(xlsxDir, xlsxName + '.json');\n    var workbook;\n    if (noCache) {\n        workbook = xlsx.readFile(xlsxPath);\n    } else if (fs.existsSync(jsonPath)) {\n        workbook = require(jsonPath);\n    } else {\n        workbook = xlsx.readFile(xlsxPath);\n        fs.writeFileSync(jsonPath, JSON.stringify(workbook), 'utf8');\n    }\n    exports.formatCell(workbook); // 格式化\n    return workbook;\n};\n/**\n * 格式化单元格内容\n * @param data\n */\nexports.formatCell = function (data) {\n    if ('Directory' in data) { // workbook\n        data.SheetNames.forEach(function (sheetName) {\n            formatWorksheet(data.Sheets[sheetName]);\n        });\n    } else { // worksheet\n        formatWorksheet(data);\n    }\n};\n/**\n * 格式化workSheet,为每一个单元格添加行,列属性及获取上下左右四个方位单元格的方法\n * @param sheet\n */\nfunction formatWorksheet(sheet) {\n    var format;\n    exports.each(sheet, function (key, value) {\n        format = exports.formatKey(key);\n        value.col = format.col;\n        value.row = format.row;\n        value.top = function (gap) {\n            gap = gap || 1;\n            return sheet[value.col + (value.row - gap)];\n        };\n        value.bottom = function (gap) {\n            gap = gap || 1;\n            return sheet[value.col + (value.row + gap)];\n        };\n        value.left = function (gap) {\n            gap = gap || 1;\n            var before,current = value.col;\n            while (gap){\n                before = exports.getPrevCol(current);\n                current = before;\n                gap -= 1;\n            }\n            return sheet[before + value.row];\n        };\n        value.right = function (gap) {\n            gap = gap || 1;\n            var after,current = value.col;\n            while (gap){\n                after = exports.getNextCol(current);\n                current = after;\n                gap -= 1;\n            }\n            return sheet[after + value.row];\n        };\n    });\n}\n/**\n * 获取某一列的前一列\n * @param colOrCell - 单元格或列名\n * @returns {*}\n */\nexports.getPrevCol = function getPrevCol(colOrCell) {\n    var col;\n    if (typeof colOrCell === 'string') { // col\n        col = colOrCell;\n    } else {\n        col = colOrCell.col;\n    }\n    col = col.toUpperCase();\n    var last = col[col.length - 1];\n    var lastLetterIndex = LETTERS_OBJ[last];\n    if (lastLetterIndex === 1) {\n        return col.length === 1 ? '' : (exports.getPrevCol(col.slice(0, -1)) + 'Z');\n    }\n    return col.length === 1 ? LETTERS[lastLetterIndex - 1] : (col.slice(0, -1) + LETTERS[lastLetterIndex - 1]);\n};\n/**\n * 获取某一列的后一列\n * @param colOrCell - 单元格或列名\n * @returns {*}\n */\nexports.getNextCol = function getPrevCol(colOrCell) {\n    var col;\n    if (typeof colOrCell === 'string') {\n        col = colOrCell;\n    } else {\n        col = colOrCell.col;\n    }\n    col = col.toUpperCase();\n    var last = col[col.length - 1];\n    var lastLetterIndex = LETTERS_OBJ[last];\n    if (lastLetterIndex === 26) {\n        return (col.length === 1 ? 'A' : exports.getNextCol(col.slice(0, -1))) + 'A';\n    }\n    return col.length === 1 ? LETTERS[lastLetterIndex + 1] : (col.slice(0, -1) + LETTERS[lastLetterIndex + 1]);\n};\n/**\n * 格式化键,输出行,列\n * @param key - 单元格的键,如A2\n * @returns {{col: number, row: number}}\n */\nexports.formatKey = function formatKey(key) {\n    var key_reg = /^([A-Z]+)(\\d+)$/;\n    var match = key.match(key_reg);\n    return {\n        col: match ? match[1] : -1,\n        row: match ? parseInt(match[2]) : -1\n    };\n};\n/**\n * 遍历worksheet,排除以!开头的属性\n * @param worksheet - 待遍历的worksheet\n * @param callback - 回调\n */\nexports.each = function (worksheet, callback) {\n    for (var key in worksheet) {\n        if (worksheet.hasOwnProperty(key) && key[0] !== '!' && callback) {\n            callback(key, worksheet[key], worksheet);\n        }\n    }\n};\n\n/**\n * 过滤器,排除以!开头的属性\n * @param worksheet\n * @param fn\n * @returns [] - 符合条件的单元格\n */\nexports.filter = function filter(worksheet, fn) {\n    var result = [];\n    for (var key in worksheet) {\n        if (worksheet.hasOwnProperty(key) && key[0] !== '!') {\n            if (fn && fn(key, worksheet[key], worksheet)) {\n                result.push(worksheet[key]);\n            }\n        }\n    }\n    return result;\n};\n/**\n * 构建ref\n * @param worksheet\n * @returns {string}\n */\nexports.buildRef = function buildRef(worksheet) {\n    if (worksheet['!ref']) {\n        return worksheet['!ref'];\n    }\n    var keys = Object.keys(worksheet);\n    return keys[0] + ':' + keys[keys.length - 1]; // 从第一个开始,排除!ref\n};\n/**\n * 构建一个单元格\n * @param val\n * @returns {*}\n */\nexports.cell = function cell(val) {\n    if (typeof val === 'number') {\n        return {t: 'n', v: val};\n    }\n    return {t: 's', v: val.toString()};\n};\n/**\n * 输出文件\n * @param filepath\n * @param workbook\n */\nexports.writeFile = function (filepath, workbook) {\n    xlsx.writeFile(workbook, filepath);\n};\n/**\n * 判断两个值是否一样\n * @param a\n * @param b\n * @returns {boolean}\n */\nexports.isEqual = function isEqual(a, b) {\n    return a.toString().trim() === b.toString().trim();\n};\n/**\n * 判断是否是Undefined\n * @param val\n * @returns {boolean}\n */\nexports.isUndefined = function (val) {\n    return typeof val === 'undefined';\n};\n/**\n * 判断变量是否定义\n * @param val\n * @returns {boolean}\n */\nexports.isDefined = function (val) {\n    return typeof val !== 'undefined';\n};\n/**\n * 在worksheet中追加一行\n */\nexports.addRow = function addRow(worksheet, rowObj) {\n    var ref = worksheet['!ref'] || exports.buildRef(worksheet);\n    var lastRow = exports.formatKey(ref.split(':')[1]).row;\n    for (var key in rowObj) {\n        if (rowObj.hasOwnProperty(key)) {\n            if(typeof rowObj === 'object' && rowObj.t){\n                worksheet[key + (lastRow + 1)] = rowObj[key];\n            }else{\n                worksheet[key + (lastRow + 1)] = exports.cell(rowObj[key]);\n            }\n        }\n    }\n};\n/**\n * 添加一个工作表\n * @param workbook\n * @param sheetName\n * @param sheet\n */\nexports.addWorkSheet = function addWorkSheet(workbook, sheetName, sheet) {\n    if (!workbook.Sheets) {\n        workbook.Sheets = {};\n    }\n    if (!workbook.SheetNames) {\n        workbook.SheetNames = [];\n    }\n    workbook.Sheets[sheetName] = sheet;\n    if (workbook.SheetNames.indexOf(sheetName) === -1) {\n        workbook.SheetNames.push(sheetName);\n    }\n};"]}