{"_id":"@aarmora/json2xls","_rev":"1-2381f92254065e90beca5ae23a38136d","name":"@aarmora/json2xls","dist-tags":{"latest":"0.0.1"},"versions":{"0.0.1":{"name":"@aarmora/json2xls","version":"0.0.1","description":"canonically transform json to an excel document","main":"lib/json2xls.js","scripts":{"test":"jasmine-node spec"},"repository":{"type":"git","url":"git+https://github.com/rikkertkoppes/json2xls.git"},"author":{"name":"Rikkert Koppes"},"license":"BSD-2-Clause","dependencies":{"excel-export":"~0.3.11"},"publishConfig":{"registry":"http://registry.npmjs.org/","access":"public"},"gitHead":"00bed98e830573855a66f3abda0d0ff668d97cbf","bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"homepage":"https://github.com/rikkertkoppes/json2xls#readme","_id":"@aarmora/json2xls@0.0.1","_nodeVersion":"12.16.0","_npmVersion":"6.14.4","dist":{"integrity":"sha512-rC9cTSfq8xM1JsxicJncuFWiNHI/7ZIN/vbmNh71NLg88AKK/0HGSnM5VBl+rHcIgYSdejykzPed/AZaBoopDA==","shasum":"427d6bb81a15ff308b821cabec4c5e2cd9534e72","tarball":"https://registry.npmjs.org/@aarmora/json2xls/-/json2xls-0.0.1.tgz","fileCount":9,"unpackedSize":25588,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJf/O/SCRA9TVsSAnZWagAAe0YP/3sk8jKAcKJui8Gb+tCK\nw3elmbTMbHjGj243w+Pzc/+BBz1RfLIx44utxnlKZaTwB03MhH6b5+OMk7rc\n9pWQ8EgLpgFrZGLsM6irJW7uuw/XVzft+BFR6pFL30bM1KLq55TMSVo9svLs\nR4fZzOnn9zbvBMbd6e3XlaKydgpvJoHdrQv+4wU3LpEZO8egO1AX0Q5foIP1\nT9QHPcV9UkhzRFY4waviyaiZyjVorML10YNDT2TRcEUAmeua0oQepHQdyehL\n99MDIidvZHddo71JZOAmkhvOy97y6J9GpEdL/lf16KB463pYazT7NdKnimyM\nCNWJKBhSw+pLut9xeWePtDLAzXF4rkt+gJ3mnt8Of+W/EuwrZtoS4Fpir9t8\np0BTxetjPtGExBPJgHnX7koRwXbJLQND88Id+YWWM6U+aHzAy5EmDtP/VM0s\n7EgWReSxWkd3Fm/MObRKueWOh/sQDBdi+ncmVK6SA6m3H15HL1Yv+iMSo4BL\n+EXMI8iXxqnvyKdG55/wvs9HqzojxOdpa7LfH7M7rs931mLt6hqV2ycDzbwD\ngOqfjqdvqMbWWukyVqG322FCET6F2QJdTCrg7BRTt2DGxHSVxA5zQasKn680\nJJn7LbGtLo6TCKTs5BeAEwJ11rh2RfKP1zJ0bD9IHTE6l+ScywaD2+F2XzBz\n0ScF\r\n=xrZd\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDOl749MjJA5Yt6gunxZt/D/ON2z6PIQBVeSkiw5V4aGwIgJMnX5HCUG7TRYHGZZQTDfBQGGJbF8TeCT6vkSXgwhLw="}]},"_npmUser":{"name":"aarmora","email":"jbhansen84@gmail.com"},"directories":{},"maintainers":[{"name":"aarmora","email":"jbhansen84@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/json2xls_0.0.1_1610411986247_0.9299932883579953"},"_hasShrinkwrap":false}},"time":{"created":"2021-01-12T00:39:46.188Z","0.0.1":"2021-01-12T00:39:46.416Z","modified":"2022-04-04T10:55:30.828Z"},"maintainers":[{"name":"aarmora","email":"jbhansen84@gmail.com"}],"description":"canonically transform json to an excel document","homepage":"https://github.com/rikkertkoppes/json2xls#readme","repository":{"type":"git","url":"git+https://github.com/rikkertkoppes/json2xls.git"},"author":{"name":"Rikkert Koppes"},"bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"license":"BSD-2-Clause","readme":"json2xls\r\n========\r\n\r\n[![Build Status](https://travis-ci.org/rikkertkoppes/json2xls.png?branch=master)](https://travis-ci.org/rikkertkoppes/json2xls)\r\n\r\nutility to convert json to a excel file, based on [Node-Excel-Export](https://github.com/functionscope/Node-Excel-Export)\r\n\r\nInstallation\r\n------------\r\n\r\n    npm install json2xls\r\n\r\nUsage\r\n------\r\n\r\nUse to save as file:\r\n\r\n    var json2xls = require('json2xls');\r\n    var json = {\r\n        foo: 'bar',\r\n        qux: 'moo',\r\n        poo: 123,\r\n        stux: new Date()\r\n    }\r\n\r\n    var xls = json2xls(json);\r\n\r\n    fs.writeFileSync('data.xlsx', xls, 'binary');\r\n\r\nOr use as express middleware. It adds a convenience `xls` method to the response object to immediately output an excel as download.\r\n\r\n    var jsonArr = [{\r\n        foo: 'bar',\r\n        qux: 'moo',\r\n        poo: 123,\r\n        stux: new Date()\r\n    },\r\n    {\r\n        foo: 'bar',\r\n        qux: 'moo',\r\n        poo: 345,\r\n        stux: new Date()\r\n    }];\r\n\r\n    app.use(json2xls.middleware);\r\n\r\n    app.get('/',function(req, res) {\r\n        res.xls('data.xlsx', jsonArr);\r\n    });\r\n\r\nOptions\r\n-------\r\n\r\nAs a second parameter to `json2xls` or a third parameter to `res.xls`, a map of options can be passed:\r\n\r\n    var xls = json2xls(json, options);\r\n    res.xls('data.xlsx', jsonArr, options);\r\n\r\nThe following options are supported:\r\n\r\n    - style: a styles xml file, see <https://github.com/functionscope/Node-Excel-Export>\r\n    - fields: either an array or map containing field configuration:\r\n        - array: a list of names of fields to be exported, in that order\r\n        - object: a map of names of fields to be exported and the types of those fields. Supported types are 'number','string','bool'\r\n\r\nExample:\r\n\r\n    var json2xls = require('json2xls');\r\n    var json = {\r\n        foo: 'bar',\r\n        qux: 'moo',\r\n        poo: 123,\r\n        stux: new Date()\r\n    }\r\n\r\n    //export only the field 'poo'\r\n    var xls = json2xls(json,{\r\n        fields: ['poo']\r\n    });\r\n\r\n    //export only the field 'poo' as string\r\n    var xls = json2xls(json,{\r\n        fields: {poo:'string'}\r\n    });\r\n\r\n    fs.writeFileSync('data.xlsx', xls, 'binary');\r\n","readmeFilename":"readme.md"}