{"_id":"@adncorp/excel-stream","_rev":"2-460c065bdcd6cc338eba65585c51e4e1","name":"@adncorp/excel-stream","dist-tags":{"latest":"1.1.0"},"versions":{"1.0.0":{"name":"@adncorp/excel-stream","description":"convert a stream of xls or xlsx into json on the command line or in node","version":"1.0.0","bin":{"excel-stream":"index.js"},"homepage":"https://github.com/dominictarr/excel-stream","repository":{"type":"git","url":"git://github.com/dominictarr/excel-stream.git"},"dependencies":{"JSONStream":"^1.0.4","concat-stream":"^1.4.6","csv-stream":"0.2.0","duplexer":"~0.1.1","j":"^0.4.3","minimist":"^1.1.1","osenv":"^0.1.3","through":"~2.3.4","win-spawn":"^2.0.0"},"devDependencies":{},"scripts":{"test":"set -e; for t in test/*.js; do node $t; done"},"author":{"name":"Dominic Tarr","email":"dominic.tarr@gmail.com","url":"http://dominictarr.com"},"license":"MIT","gitHead":"d3fb134a7fdf1df07b9c15239632ca2bffd28b0a","bugs":{"url":"https://github.com/dominictarr/excel-stream/issues"},"_id":"@adncorp/excel-stream@1.0.0","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"integrity":"sha512-dzl+BvO5ExHtcQ5F4b7FVMuYlIXUIP281y9D5AOtpLAZtgORYLwEYXzWXzfrZHG8mzPT0FCouUpy54kLi5QLYw==","shasum":"e3c76a183d24def20cd36f28f74867cfc7d25d67","tarball":"https://registry.npmjs.org/@adncorp/excel-stream/-/excel-stream-1.0.0.tgz","fileCount":5,"unpackedSize":5504,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeQdRGCRA9TVsSAnZWagAA/dYQAJgmllUC8hOMJrBo7bVk\nMifHgq5J8a9QCbMV/lGXn9mRFHDzFIrCFgepv6o0zZo3ca0cJXWTRuUMGwSm\nqYb79jOJ0tEVyfpux0SfZqoBmEYJ2z6YBJepmihWL449qxsjdWi4mKf6g5hm\nlll/64ROLjYlOI1m6FoQtms6QogMzNZxtUhospIqafpcgUY+Y7rHv1TFB69j\naHJQGS/lBsLyyVWw9GwEnFG1RpePnit5czAnKUAdHsRoRU75RtpByddDDJZk\nipgwe682ddqFYEzfBn6VyGQX2ZtbGXFQ9M9bbpis049b4eadOOfPMq9GStmH\nThYHI5zaMReibqxj6woaUrmtMFfn0glb3Rrg1y/wybhN5Zsvp3BK9ROn6Hl3\nupaT50ixHYZ/pRBljwPbSN20/n69ohOGYzrQjARe8X9ehRyeMHf4VPG3awrt\nngK9byDvmf0ZfSXhou1ymwkLpGWL8483jnJDo9aE49+UT1e4qgX3WZgBbow4\nafT1GHTwDLBcd5BSzMB/71GkW+e4tSgAZ8ykLiZXby3x8W7pHt/td2cQuIb3\n0mnpTA+aP5SibQAU/s7iaoD0tHZIVJaToHBxZOqgNawJergtFhKFEjj4Vtbz\nv8bfEKTOUx21h6JMqrUdtO3O9ZukFZkMH/KxaOyo/ugG7FRH+09LoQNiDdBX\nKj01\r\n=HDYb\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGtVPVQ4nd1fFcsiPD7FWkbFIfgJvdLQKgL+y+oRDzJSAiEAlLfgpfgBhWoUojEQcrJ6uobW7sUpSuqYs+rkSwAg24w="}]},"maintainers":[{"name":"thirdparty","email":"thirdparty@adncorp.com"}],"_npmUser":{"name":"thirdparty","email":"thirdparty@adncorp.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/excel-stream_1.0.0_1581372485803_0.8931736739340967"},"_hasShrinkwrap":false},"1.1.0":{"name":"@adncorp/excel-stream","description":"convert a stream of xls or xlsx into json on the command line or in node","version":"1.1.0","bin":{"excel-stream":"index.js"},"homepage":"https://github.com/dominictarr/excel-stream","repository":{"type":"git","url":"git://github.com/dominictarr/excel-stream.git"},"dependencies":{"JSONStream":"^1.0.4","concat-stream":"^1.4.6","csv-stream":"0.2.0","duplexer":"~0.1.1","j":"^0.4.3","minimist":"^1.1.1","osenv":"^0.1.3","through":"~2.3.4","win-spawn":"^2.0.0"},"devDependencies":{},"scripts":{"test":"set -e; for t in test/*.js; do node $t; done"},"author":{"name":"Dominic Tarr","email":"dominic.tarr@gmail.com","url":"http://dominictarr.com"},"license":"MIT","gitHead":"972ad690616a0ad66ba07814750d7b45d87fdc74","bugs":{"url":"https://github.com/dominictarr/excel-stream/issues"},"_id":"@adncorp/excel-stream@1.1.0","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"integrity":"sha512-FbCgxDeCwSqdPjsOZ1m52Ax5OeQHehB7NdLVIqCtqwQt0aYhq5K+su+9ehXRvLc4aTNxRoPACDEeYvfjtTCH0w==","shasum":"bed799e4c572c1ab2517b1dcdb97ac7d6d47c59c","tarball":"https://registry.npmjs.org/@adncorp/excel-stream/-/excel-stream-1.1.0.tgz","fileCount":5,"unpackedSize":5731,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeSsqhCRA9TVsSAnZWagAAIDMP/iqSR/wSMOBe9lk7uT/7\noQhK8p7i+ZQu2Aop0D4daHrQPBiqIo0M+eexs3+6Haqh4qrUviOdq2Zb107c\nDF+ob+7XqK4QarixBx2bqXrNTeJ5eoDyCSlwswUES2zplTqQ5mFi4XQljaQA\nfWjySZzS1dnARQZh4pAN0OeGwWmgBmDBR/OtqCR5odNcH+HTtqcrbNFpW6BS\nCp+Uvs/RAjM9yNChZtWQirx2aqCNH6tBMnYOXhRwLrX6H7roybfuNWbQIs9L\nsJjC71gtCAWYibCfrt/0X2FVSVt60OmuIi98BQMLaDxVWk1+JJPC+VQ0aQMX\noCYFeKyTfzZctqt53j1lX3kMpA3FFTg3xo3UHW+IXQeTu3IKoBamP9fFex2D\neSLocetYE3feuN+3vjxma2pvyAezOpThY2PnUqnbSV6dVhPhUHST9eubqFYP\nqaF3m3c+rOAsFtFf4/Hraan2PIebWaTX3nqRgLMml3qJ861+hTvJdMhJH5Mg\n42W/OukbJD7JE1hOpZTQzAnDAuUT6H/c+eVh3jDKTGaRy/O8iGNrxl9fCo/E\nbRGRegksh+sqjfOEkk5kw83LS/DDOGYWsjviwC7QHOMDfzbTm5h1V2NswcWG\nhhnAxNE6yvCyCY/h5pjx74mmfcDBzf5nmre2Mgi6N9KepyXjX/VRW6JbyUkK\nPfu6\r\n=aTEI\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBpp4faX62fCAM/N6nMXxpOVGecUT1CYLQM2RaIq+5j7AiBxMQCuo/QqF+dT55GuDhrFsIEKaj2aboM4vjv6S5F9Nw=="}]},"maintainers":[{"name":"thirdparty","email":"thirdparty@adncorp.com"}],"_npmUser":{"name":"thirdparty","email":"thirdparty@adncorp.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/excel-stream_1.1.0_1581959841143_0.7133145755705854"},"_hasShrinkwrap":false}},"time":{"created":"2020-02-10T22:08:05.541Z","1.0.0":"2020-02-10T22:08:05.943Z","modified":"2022-04-04T11:33:52.452Z","1.1.0":"2020-02-17T17:17:21.310Z"},"maintainers":[{"name":"thirdparty","email":"thirdparty@adncorp.com"}],"description":"convert a stream of xls or xlsx into json on the command line or in node","homepage":"https://github.com/dominictarr/excel-stream","repository":{"type":"git","url":"git://github.com/dominictarr/excel-stream.git"},"author":{"name":"Dominic Tarr","email":"dominic.tarr@gmail.com","url":"http://dominictarr.com"},"bugs":{"url":"https://github.com/dominictarr/excel-stream/issues"},"license":"MIT","readme":"# excel-stream\n\nA stream that converts excel spreadsheets into JSON object arrays.\n\n\n# Examples\n\n``` js\n// stream rows from the first sheet on the file\nvar excel = require('excel-stream')\nvar fs = require('fs')\n\nfs.createReadStream('accounts.xlsx')\n  .pipe(excel())  // same as excel({sheetIndex: 0})\n  .on('data', console.log)\n\n```\n\n``` js\n// stream rows from the sheet named 'Your sheet name'\nvar excel = require('excel-stream')\nvar fs = require('fs')\n\nfs.createReadStream('accounts.xlsx')\n  .pipe(excel({\n     sheet: 'Your sheet name'\n  }))\n  .on('data', console.log)\n\n```\n\n# stream options\n\nThe `options` object may have the same properties as [csv-stream](https://www.npmjs.com/package/csv-stream) and these two additional properties:\n\n * `sheet`: the name of the sheet you want to stream. Case sensitive.\n * `sheetIndex`: the sheet number you want to stream (0-based).\n\n# Usage\n\n``` js\nnpm install -g excel-stream\nexcel-stream < accounts.xlsx > account.json\n```\n\n# options\n\nnewline delimited json:\n\n```js\nexcel-stream --newlines\n```\n\n# formats\n\neach row becomes a javascript object, so input like\n\n``` csv\nfoo, bar, baz\n  1,   2,   3\n  4,   5,   6\n```\n\nwill become\n\n``` js\n[{\n  foo: 1,\n  bar: 2,\n  baz: 3\n}, {\n  foo: 4,\n  bar: 5,\n  baz: 6\n}]\n\n```\n\n# Don't Look Now\n\nSo, excel isn't really a streamable format.\nBut it's easy to work with streams because everything is a stream.\nThis writes to a tmp file, then pipes it through the unfortunately named [j](https://npm.im/j)\nthen into [csv-stream](https://npm.im/csv-stream)\n\n\n## License\n\nMIT\n","readmeFilename":"README.md"}