{"_id":"xlsx2json","_rev":"26-4c14362e62f2be49af9dad684a61cf41","name":"xlsx2json","description":"Convert xlsx to JSON.","dist-tags":{"latest":"1.0.0"},"versions":{"0.0.1":{"name":"xlsx2json","version":"0.0.1","description":"Convert xlsx to JSON.","main":"lib/xlsx2json.js","dependencies":{"lodash":"~2.4.1","q":"^1.0.1","excel":"~0.1.1"},"devDependencies":{"mocha":"^1.18.2","chai":"^1.9.1","rewire":"^2.0.0","istanbul":"^0.2.7","coveralls":"^2.10.0"},"scripts":{"test":"mocha test/xlsx2json.test.js","coverage":"node ./node_modules/istanbul/lib/cli.js cover ./node_modules/mocha/bin/_mocha -- --recursive -R spec"},"repository":{"type":"git","url":"https://github.com/daikiueda/xlsx2json.git"},"keywords":["excel","xlsx","json"],"author":{"name":"daikiueda"},"license":"MIT","bugs":{"url":"https://github.com/daikiueda/xlsx2json/issues"},"homepage":"https://github.com/daikiueda/xlsx2json","_id":"xlsx2json@0.0.1","dist":{"shasum":"552421aa3a6acff45274a8a37450b31364460dda","tarball":"https://registry.npmjs.org/xlsx2json/-/xlsx2json-0.0.1.tgz","integrity":"sha512-wdWbaD9ANm1/QsXBCh0SrOm+Xo3kU+m5rSfeI90xgyIJmrGw2lvTIUVn0vRhP+btrdxHgNLbEZfIEPRd8l9UkQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCC65DMjXRs4/SIYTFyHCUq1tjMRR+VzqoAhb7gveWyvQIhAOiBNuBk+szLlylpR211DEV3AciBCNZNakVqn5qYzR/b"}]},"_from":".","_npmVersion":"1.4.3","_npmUser":{"name":"daikiueda","email":"daikiueda.dev@gmail.com"},"maintainers":[{"name":"daikiueda","email":"daikiueda.dev@gmail.com"}]},"0.0.2":{"name":"xlsx2json","version":"0.0.2","description":"Convert xlsx to JSON.","main":"lib/xlsx2json.js","dependencies":{"lodash":"~2.4.1","q":"^1.0.1","excel":"~0.1.1"},"devDependencies":{"mocha":"^1.18.2","chai":"^1.9.1","rewire":"^2.0.0","istanbul":"^0.2.7","coveralls":"^2.10.0"},"scripts":{"test":"mocha test/xlsx2json.test.js","coverage":"node ./node_modules/istanbul/lib/cli.js cover ./node_modules/mocha/bin/_mocha -- --recursive -R spec"},"repository":{"type":"git","url":"https://github.com/daikiueda/xlsx2json.git"},"keywords":["excel","xlsx","json"],"author":{"name":"daikiueda"},"license":"MIT","bugs":{"url":"https://github.com/daikiueda/xlsx2json/issues"},"homepage":"https://github.com/daikiueda/xlsx2json","_id":"xlsx2json@0.0.2","dist":{"shasum":"75d215a4c24c27be0cf655736a88a739a741dd7b","tarball":"https://registry.npmjs.org/xlsx2json/-/xlsx2json-0.0.2.tgz","integrity":"sha512-PqNpMFM6xiGdabQQwbMumA/Dfhq8bLiNXqonR6Rc/dKwIEFbPQ+wcQ8pcSd7WKHEOks+QtlboS7XTatkYAhXDg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDBDYE+6Aax5OJUWWT1pCHJ9To9zKOgSIkUqmYZjOxEbgIhAOd+aRHc7Rene8zzy6VL4XYh29RnqcLzd7uLTDWY+eXZ"}]},"_from":".","_npmVersion":"1.4.3","_npmUser":{"name":"daikiueda","email":"daikiueda.dev@gmail.com"},"maintainers":[{"name":"daikiueda","email":"daikiueda.dev@gmail.com"}]},"0.0.3":{"name":"xlsx2json","version":"0.0.3","description":"Convert xlsx to JSON.","main":"lib/xlsx2json.js","dependencies":{"lodash":"~2.4.1","q":"^1.0.1","excel":"~0.1.1"},"devDependencies":{"mocha":"^1.18.2","chai":"^1.9.1","rewire":"^2.0.0","istanbul":"^0.2.7","coveralls":"^2.10.0"},"scripts":{"test":"mocha test/xlsx2json.test.js","coverage":"node ./node_modules/istanbul/lib/cli.js cover ./node_modules/mocha/bin/_mocha -- --recursive -R spec"},"repository":{"type":"git","url":"https://github.com/daikiueda/xlsx2json.git"},"keywords":["excel","xlsx","json"],"author":{"name":"daikiueda"},"license":"MIT","bugs":{"url":"https://github.com/daikiueda/xlsx2json/issues"},"homepage":"https://github.com/daikiueda/xlsx2json","gitHead":"9d7e2e57afc5cf7eb952a48292f0a1f8978102a3","_id":"xlsx2json@0.0.3","_shasum":"ade00b60ad7277ebf25a476bcc87d10f339ad334","_from":".","_npmVersion":"1.4.13","_npmUser":{"name":"daikiueda","email":"daikiueda.dev@gmail.com"},"maintainers":[{"name":"daikiueda","email":"daikiueda.dev@gmail.com"}],"dist":{"shasum":"ade00b60ad7277ebf25a476bcc87d10f339ad334","tarball":"https://registry.npmjs.org/xlsx2json/-/xlsx2json-0.0.3.tgz","integrity":"sha512-oTomTlgf06VFOs6g4AVyYWG7yGdNhaM3cRtGnXxjp45MGrzEXq7HXI1bJ+HvWLYHBr+f28yX/y8ykwGN9LmZVg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAZWcjV0sAA+0Vtr6uonpRp96+8d4Nf0wNDT6DgRto2iAiBi1a6BYJGa57QvPlFmpxSZUrV6p6qR0M5qTSM3I5KFBw=="}]}},"0.0.4":{"name":"xlsx2json","version":"0.0.4","description":"Convert xlsx to JSON.","main":"lib/xlsx2json.js","dependencies":{"lodash":"~2.4.1","q":"^1.0.1","excel":"~0.1.1"},"devDependencies":{"mocha":"^1.21.3","chai":"^1.9.1","rewire":"^2.1.0","istanbul":"^0.3.0","coveralls":"^2.11.1"},"scripts":{"test":"mocha test/xlsx2json.test.js","coverage":"node ./node_modules/istanbul/lib/cli.js cover ./node_modules/mocha/bin/_mocha -- --recursive -R spec"},"repository":{"type":"git","url":"https://github.com/daikiueda/xlsx2json.git"},"keywords":["excel","xlsx","json"],"author":{"name":"daikiueda"},"license":"MIT","bugs":{"url":"https://github.com/daikiueda/xlsx2json/issues"},"homepage":"https://github.com/daikiueda/xlsx2json","gitHead":"2bcb59aa614f61e13dd6dbb78303db1e94187391","_id":"xlsx2json@0.0.4","_shasum":"6500bee3214c94559a748b7827e7ea40cbea7e89","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"daikiueda","email":"daikiueda.dev@gmail.com"},"maintainers":[{"name":"daikiueda","email":"daikiueda.dev@gmail.com"}],"dist":{"shasum":"6500bee3214c94559a748b7827e7ea40cbea7e89","tarball":"https://registry.npmjs.org/xlsx2json/-/xlsx2json-0.0.4.tgz","integrity":"sha512-mV7BKMTL6GSEaddPZLryPLNzhuElcIAEaRML9prPX3xrukKr0jsBqiJYhsiC46Cxo1pItq9+ymkT0DumwmYqQg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQC4G9K8j+xS5oLJjEJVAMwNIAm3TK/L4iWE+OKdtI+ymgIhAM/IDa4IutowSlXWKHy7Q8eYcfNKEgNYFQDyUhNnk82d"}]}},"0.0.5":{"name":"xlsx2json","version":"0.0.5","description":"Convert xlsx to JSON.","main":"lib/xlsx2json.js","dependencies":{"lodash":"~3.0.0","q":"^1.1.2","excel":"~0.1.1"},"devDependencies":{"mocha":"^2.1.0","chai":"^1.10.0","rewire":"^2.1.4","istanbul":"^0.3.5","coveralls":"^2.11.2"},"scripts":{"test":"mocha test/xlsx2json.test.js","coverage":"node ./node_modules/istanbul/lib/cli.js cover ./node_modules/mocha/bin/_mocha -- --recursive -R spec"},"repository":{"type":"git","url":"https://github.com/daikiueda/xlsx2json.git"},"keywords":["excel","xlsx","json"],"author":{"name":"daikiueda"},"license":"MIT","bugs":{"url":"https://github.com/daikiueda/xlsx2json/issues"},"homepage":"https://github.com/daikiueda/xlsx2json","gitHead":"965eba24cd9d580809d7206c9b7b8f1cacf16370","_id":"xlsx2json@0.0.5","_shasum":"eb39844eaad2f3b3325cdc2a989175bc587c119e","_from":".","_npmVersion":"2.3.0","_nodeVersion":"0.10.36","_npmUser":{"name":"daikiueda","email":"daikiueda.dev@gmail.com"},"maintainers":[{"name":"daikiueda","email":"daikiueda.dev@gmail.com"}],"dist":{"shasum":"eb39844eaad2f3b3325cdc2a989175bc587c119e","tarball":"https://registry.npmjs.org/xlsx2json/-/xlsx2json-0.0.5.tgz","integrity":"sha512-cKGc/CYbt69hzuWdcoBYAyt12gVVlmrjVdbD+J69K7uKAWZzQFzAKto9ATCBGVXWD2cEIFq0bux8c8Uq6B712g==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCtMx0wWCPUVJXRX1MAWz/pHj422+J3nuF0e5pY5tiNiwIgeRrP3/hevB6qtxD3tRO5liTjr8DIMkaC7jBjTpjU5IM="}]}},"0.0.6":{"name":"xlsx2json","version":"0.0.6","description":"Convert xlsx to JSON.","main":"lib/xlsx2json.js","dependencies":{"lodash":"~3.5.0","q":"^1.2.0","excel":"~0.1.2"},"devDependencies":{"mocha":"^2.2.1","chai":"^2.1.2","rewire":"^2.3.1","istanbul":"^0.3.8","coveralls":"^2.11.2"},"scripts":{"test":"node ./node_modules/.bin/mocha test/xlsx2json.test.js","test-cov":"node ./node_modules/istanbul/lib/cli.js cover ./node_modules/mocha/bin/_mocha -- --recursive -R spec"},"repository":{"type":"git","url":"https://github.com/daikiueda/xlsx2json.git"},"keywords":["excel","xlsx","json"],"author":{"name":"daikiueda"},"license":"MIT","bugs":{"url":"https://github.com/daikiueda/xlsx2json/issues"},"homepage":"https://github.com/daikiueda/xlsx2json","gitHead":"2df26aa101d903c1ccddab09519498d3789ae50c","_id":"xlsx2json@0.0.6","_shasum":"8cbdd2b9f649f554fad8e83eca1149cd9cedcc5c","_from":".","_npmVersion":"1.4.28","_npmUser":{"name":"daikiueda","email":"daikiueda.dev@gmail.com"},"maintainers":[{"name":"daikiueda","email":"daikiueda.dev@gmail.com"}],"dist":{"shasum":"8cbdd2b9f649f554fad8e83eca1149cd9cedcc5c","tarball":"https://registry.npmjs.org/xlsx2json/-/xlsx2json-0.0.6.tgz","integrity":"sha512-MKXFEeTohqA4RBE1gH6xaQib4ND72VQLJD84RkAjw4sKA4EjYM/0zFiUQhi7Ed0awYz46L6J8+v4VixInoxbWg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDgyMP34nY8CQD25xR/eKRmAWLk9/+pjc7MBdXZmljzsgIgUKm/6n0sNswoPQO6yQJwZc03KUvmjXDYFV52lYXE4Ck="}]}},"0.0.8":{"name":"xlsx2json","version":"0.0.8","description":"Convert xlsx to JSON.","main":"lib/xlsx2json.js","dependencies":{"csv-parse":"^0.1.0","lodash":"~3.5.0","q":"^1.2.0","xlsx":"^0.7.12"},"devDependencies":{"mocha":"^2.2.1","chai":"^2.1.2","rewire":"^2.3.1","istanbul":"^0.3.8","coveralls":"^2.11.2"},"scripts":{"test":"node ./node_modules/.bin/mocha test/xlsx2json.test.js","test-cov":"node ./node_modules/istanbul/lib/cli.js cover ./node_modules/mocha/bin/_mocha -- --recursive -R spec"},"repository":{"type":"git","url":"https://github.com/daikiueda/xlsx2json.git"},"keywords":["excel","xlsx","json"],"author":{"name":"daikiueda"},"license":"MIT","bugs":{"url":"https://github.com/daikiueda/xlsx2json/issues"},"homepage":"https://github.com/daikiueda/xlsx2json","gitHead":"67c767cf4d848c394be11d89cecaa8183bd73f95","_id":"xlsx2json@0.0.8","_shasum":"d4fa22fa5ac6e284e0a090a40baf7cd345996b4f","_from":".","_npmVersion":"2.7.3","_nodeVersion":"0.10.37","_npmUser":{"name":"daikiueda","email":"daikiueda.dev@gmail.com"},"maintainers":[{"name":"daikiueda","email":"daikiueda.dev@gmail.com"}],"dist":{"shasum":"d4fa22fa5ac6e284e0a090a40baf7cd345996b4f","tarball":"https://registry.npmjs.org/xlsx2json/-/xlsx2json-0.0.8.tgz","integrity":"sha512-cx9QQ7LwzX2pRFpFCeHmHonO52WPUcNX+/RWxaDEKsOjn76r/07KgsMYFZaZa99Cem/5y7z5CnqlMNh2NcCI2Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGA8ppaioptkE0cDHuNcYxoUviD/oIVVcLctRrg38BrmAiA1lzSsPRScOEiCbdSFubM47yg+harsTkC3xmM1/wj1JA=="}]}},"1.0.0":{"name":"xlsx2json","version":"1.0.0","description":"Convert xlsx to JSON.","main":"lib/xlsx2json.js","engines":{"node":">=6.9.1"},"dependencies":{"csv-parse":"^1.1.7","memoizee":"^0.4.1","xlsx":"^0.8.0"},"devDependencies":{"coveralls":"^2.11.2","intelli-espower-loader":"^1.0.1","istanbul":"^0.4.5","mocha":"^3.2.0","power-assert":"^1.4.2","rewire":"^2.3.1"},"scripts":{"test":"node ./node_modules/.bin/mocha test/xlsx2json.test.js","test-cov":"node ./node_modules/istanbul/lib/cli.js cover ./node_modules/mocha/bin/_mocha -- --recursive -R spec"},"repository":{"type":"git","url":"git+https://github.com/daikiueda/xlsx2json.git"},"keywords":["excel","xlsx","json"],"author":{"name":"daikiueda"},"license":"MIT","bugs":{"url":"https://github.com/daikiueda/xlsx2json/issues"},"homepage":"https://github.com/daikiueda/xlsx2json","gitHead":"6d3a221a766c4ccb00ffc80036751e223b998e20","_id":"xlsx2json@1.0.0","_shasum":"484bf860e36751a5b0ab0e0aaad239e268174a6d","_from":".","_npmVersion":"3.10.9","_nodeVersion":"6.9.1","_npmUser":{"name":"daikiueda","email":"daikiueda.dev@gmail.com"},"dist":{"shasum":"484bf860e36751a5b0ab0e0aaad239e268174a6d","tarball":"https://registry.npmjs.org/xlsx2json/-/xlsx2json-1.0.0.tgz","integrity":"sha512-AKfJI5gEaL7VUuEGCVfMTsod6Y8EinhLhQEeXl7rDVhhXGwaXl8LnuLkkMvvR8yfLKsHuF0CS94TJL/cQlHg2g==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBiyw/ZZ45eF2PXn84DIdjBgAeGwYl+63SJ6A8E0Cfm8AiEAzdp/8mHPQcmcphd1WININYYZVLOY1TNYJ+15YSimepY="}]},"maintainers":[{"name":"daikiueda","email":"daikiueda.dev@gmail.com"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/xlsx2json-1.0.0.tgz_1480084811690_0.7289930146653205"}}},"readme":"xlsx2json [![Build Status](https://travis-ci.org/daikiueda/xlsx2json.svg?branch=master)](https://travis-ci.org/daikiueda/xlsx2json) [![Coverage Status](https://coveralls.io/repos/daikiueda/xlsx2json/badge.png?branch=master)](https://coveralls.io/r/daikiueda/xlsx2json?branch=master) [![Code Climate](https://codeclimate.com/github/daikiueda/xlsx2json.png)](https://codeclimate.com/github/daikiueda/xlsx2json)\n=========\n\n[![NPM](https://nodei.co/npm/xlsx2json.png?compact=true)](https://nodei.co/npm/xlsx2json/)\n\nConvert xlsx to JSON.\n\n## Install\n\n```Bash\n$ npm install xlsx2json\n```\n\n## Usage\n\nSimple usage : )\n\n```JavaScript\nvar xlsx2json = require('xlsx2json');\nxlsx2json('path_to_xlsx_file').then(jsonArray => {\n    ...\n});\n```\n\n### xlsx2json(pathToXlsx, [options], [callback])\n\n#### Arguments\n\n* __pathToXlsx__ String  \n\n* __options__ Object _(optional)_\n  * ```sheet```\n    * {Number} (*zero-based sheet index)\n    * {String}\n    * {Array}\n    \n    If options.sheet is not set, all sheets will be passed as Array.\n  * ```keysRow``` {Number} (*one-based row position)\n  * ```mapping``` {Object}\n  * ```dataStartingRow``` {Number} (*one-based row position)\n\n* __callback__ Function _(optional)_  \n  * function(error, jsonArray) {}\n\n#### Returns\n\n* __Promise__ \n\nfor example : )  \nconvert [test/xlsx/with_header_information_and_keys_row.xlsx](https://github.com/daikiueda/xlsx2json/blob/master/test/xlsx/with_header_information_and_keys_row.xlsx) to jsonArray.\n\n```JavaScript\nvar xlsx2json = require('xlsx2json');\nxlsx2json(\n    'test/xlsx/with_header_information_and_keys_row.xlsx',\n    {\n        dataStartingRow: 4,\n        mapping: {\n            'col_1': 'A',\n            'col_2': 'B',\n            'col_3': 'C'\n        }\n    }\n}).then(jsonArray => { ... });\n```\nThe jsonArray is as follows : )\n```JSON\n[\n    [\n        {\"col_1\": \"value 1-A\", \"col_1\": \"value 1-B\", \"col_3\": \"value 1-C\"},\n        {\"col_1\": \"value 2-A\", \"col_2\": \"value 2-B\", \"col_3\": \"value 2-C\"}\n    ]\n]\n```\n\nThe result is the structure of a three-dimensional array.  \nIn short, ```jsonArray[sheets][rows][cellValues]```\n\n\nAlternatively, if the option.sheet is set (as a String or a Number), only specific sheet will be passed.","maintainers":[{"name":"daikiueda","email":"daikiueda.dev@gmail.com"}],"time":{"modified":"2022-06-29T05:31:47.353Z","created":"2014-04-02T20:06:19.676Z","0.0.1":"2014-04-02T20:06:19.676Z","0.0.2":"2014-04-03T10:19:27.585Z","0.0.3":"2014-07-02T14:44:25.793Z","0.0.4":"2014-07-29T02:54:54.791Z","0.0.5":"2015-01-27T07:18:34.064Z","0.0.6":"2015-03-16T22:06:41.121Z","0.0.7":"2015-03-22T13:18:15.004Z","0.0.8":"2015-03-22T13:26:56.582Z","1.0.0":"2016-11-25T14:40:11.927Z"},"homepage":"https://github.com/daikiueda/xlsx2json","keywords":["excel","xlsx","json"],"repository":{"type":"git","url":"git+https://github.com/daikiueda/xlsx2json.git"},"author":{"name":"daikiueda"},"bugs":{"url":"https://github.com/daikiueda/xlsx2json/issues"},"license":"MIT","readmeFilename":"README.md","users":{"fgribreau":true,"zetay":true,"neoklosch":true,"foozzi":true,"walnut":true}}