{"_id":"json2xls","_rev":"2971955","name":"json2xls","description":"canonically transform json to an excel document","dist-tags":{"latest":"0.1.2"},"maintainers":[{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"}],"time":{"modified":"2023-06-13T06:37:08.000Z","created":"2013-11-23T18:30:44.940Z","0.1.2":"2016-07-01T08:53:29.033Z","0.1.1":"2015-12-29T14:05:20.728Z","0.1.0":"2015-12-04T08:53:02.035Z","0.0.5":"2014-03-17T13:44:49.972Z","0.0.4":"2014-03-17T13:26:47.109Z","0.0.3":"2014-03-17T11:52:46.204Z","0.0.2":"2014-03-13T12:26:03.974Z","0.0.1":"2013-11-23T18:30:44.940Z"},"users":{},"author":{"name":"Rikkert Koppes"},"repository":{"type":"git","url":"git+https://github.com/rikkertkoppes/json2xls.git"},"versions":{"0.1.2":{"name":"json2xls","version":"0.1.2","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"},"gitHead":"db90c6bac777de49edcad3e9eea4b9585917f2cf","bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"homepage":"https://github.com/rikkertkoppes/json2xls#readme","_id":"json2xls@0.1.2","_shasum":"37358ed82a8fcaf92bb3b24d8759ac57e394e017","_from":".","_npmVersion":"2.15.8","_nodeVersion":"4.4.7","_npmUser":{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"},"dist":{"shasum":"37358ed82a8fcaf92bb3b24d8759ac57e394e017","size":13567,"noattachment":false,"key":"/json2xls/-/json2xls-0.1.2.tgz","tarball":"http://registry.cnpm.dingdandao.com/json2xls/download/json2xls-0.1.2.tgz"},"maintainers":[{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"}],"_npmOperationalInternal":{"host":"packages-16-east.internal.npmjs.com","tmp":"tmp/json2xls-0.1.2.tgz_1467363207113_0.28354359208606184"},"directories":{},"_cnpmcore_publish_time":"2021-12-19T19:28:57.883Z","publish_time":1467363209033,"_cnpm_publish_time":1467363209033},"0.1.1":{"name":"json2xls","version":"0.1.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"},"gitHead":"798e5908eeee57bbdf545165afa937b8df06fed4","bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"homepage":"https://github.com/rikkertkoppes/json2xls#readme","_id":"json2xls@0.1.1","_shasum":"0656f6a59ecfee1dc92acdf3d8fd07bfab09f51b","_from":".","_npmVersion":"2.8.4","_nodeVersion":"0.12.7","_npmUser":{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"},"dist":{"shasum":"0656f6a59ecfee1dc92acdf3d8fd07bfab09f51b","size":6173,"noattachment":false,"key":"/json2xls/-/json2xls-0.1.1.tgz","tarball":"http://registry.cnpm.dingdandao.com/json2xls/download/json2xls-0.1.1.tgz"},"maintainers":[{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"}],"directories":{},"_cnpmcore_publish_time":"2021-12-19T19:28:57.782Z","publish_time":1451397920728,"_cnpm_publish_time":1451397920728},"0.1.0":{"name":"json2xls","version":"0.1.0","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"},"gitHead":"8a21d20f287f229ddb61fb0bcd97807af805256a","bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"homepage":"https://github.com/rikkertkoppes/json2xls#readme","_id":"json2xls@0.1.0","_shasum":"882f45155a6f91b5e32bb44fe5eb6c4bcd700da6","_from":".","_npmVersion":"2.11.3","_nodeVersion":"0.12.7","_npmUser":{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"},"maintainers":[{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"}],"dist":{"shasum":"882f45155a6f91b5e32bb44fe5eb6c4bcd700da6","size":11703,"noattachment":false,"key":"/json2xls/-/json2xls-0.1.0.tgz","tarball":"http://registry.cnpm.dingdandao.com/json2xls/download/json2xls-0.1.0.tgz"},"directories":{},"_cnpmcore_publish_time":"2021-12-19T19:28:56.915Z","publish_time":1449219182035,"_cnpm_publish_time":1449219182035},"0.0.5":{"name":"json2xls","version":"0.0.5","description":"canonically transform json to an excel document","main":"lib/json2xls.js","scripts":{"test":"jasmine-node spec"},"repository":{"type":"git","url":"https://github.com/rikkertkoppes/json2xls"},"author":{"name":"Rikkert Koppes"},"license":"BSD-2-Clause","dependencies":{"excel-export":"~0.3.11"},"bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"homepage":"https://github.com/rikkertkoppes/json2xls","_id":"json2xls@0.0.5","dist":{"shasum":"6cb969063043f0448a95c8980fdf788d5d2732b0","size":14634,"noattachment":false,"key":"/json2xls/-/json2xls-0.0.5.tgz","tarball":"http://registry.cnpm.dingdandao.com/json2xls/download/json2xls-0.0.5.tgz"},"_from":".","_npmVersion":"1.4.4","_npmUser":{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"},"maintainers":[{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"}],"directories":{},"_cnpmcore_publish_time":"2021-12-19T19:28:56.052Z","publish_time":1395063889972,"_cnpm_publish_time":1395063889972},"0.0.4":{"name":"json2xls","version":"0.0.4","description":"canonically transform json to an excel document","main":"lib/json2xls.js","scripts":{"test":"jasmine-node spec"},"repository":{"type":"git","url":"https://github.com/rikkertkoppes/json2xls"},"author":{"name":"Rikkert Koppes"},"license":"BSD-2-Clause","dependencies":{"excel-export":"~0.3.11"},"bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"homepage":"https://github.com/rikkertkoppes/json2xls","_id":"json2xls@0.0.4","dist":{"shasum":"4f2f87541ecdd839185a59805c1535ab63ac1d73","size":4988,"noattachment":false,"key":"/json2xls/-/json2xls-0.0.4.tgz","tarball":"http://registry.cnpm.dingdandao.com/json2xls/download/json2xls-0.0.4.tgz"},"_from":".","_npmVersion":"1.4.4","_npmUser":{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"},"maintainers":[{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"}],"directories":{},"_cnpmcore_publish_time":"2021-12-19T19:28:55.193Z","publish_time":1395062807109,"_cnpm_publish_time":1395062807109},"0.0.3":{"name":"json2xls","version":"0.0.3","description":"canonically transform json to an excel document","main":"lib/json2xls.js","scripts":{"test":"jasmine-node spec"},"repository":{"type":"git","url":"https://github.com/rikkertkoppes/json2xls"},"author":{"name":"Rikkert Koppes"},"license":"BSD-2-Clause","dependencies":{"excel-export":"~0.3.7"},"bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"homepage":"https://github.com/rikkertkoppes/json2xls","_id":"json2xls@0.0.3","dist":{"shasum":"20481fa4ec0dbd3199105ac55895eab256ef0be6","size":4899,"noattachment":false,"key":"/json2xls/-/json2xls-0.0.3.tgz","tarball":"http://registry.cnpm.dingdandao.com/json2xls/download/json2xls-0.0.3.tgz"},"_from":".","_npmVersion":"1.4.4","_npmUser":{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"},"maintainers":[{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"}],"directories":{},"_cnpmcore_publish_time":"2021-12-19T19:28:54.318Z","publish_time":1395057166204,"_cnpm_publish_time":1395057166204},"0.0.2":{"name":"json2xls","version":"0.0.2","description":"canonically transform json to an excel document","main":"lib/json2xls.js","scripts":{"test":"jasmine-node spec"},"repository":{"type":"git","url":"https://github.com/rikkertkoppes/json2xls"},"author":{"name":"Rikkert Koppes"},"license":"BSD-2-Clause","dependencies":{"excel-export":"~0.3.7"},"bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"homepage":"https://github.com/rikkertkoppes/json2xls","_id":"json2xls@0.0.2","dist":{"shasum":"ffa49f45a67fe46552710713b59291e6386f48c7","size":4528,"noattachment":false,"key":"/json2xls/-/json2xls-0.0.2.tgz","tarball":"http://registry.cnpm.dingdandao.com/json2xls/download/json2xls-0.0.2.tgz"},"_from":".","_npmVersion":"1.4.4","_npmUser":{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"},"maintainers":[{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"}],"directories":{},"_cnpmcore_publish_time":"2021-12-19T19:28:53.450Z","publish_time":1394713563974,"_cnpm_publish_time":1394713563974},"0.0.1":{"name":"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":"https://github.com/rikkertkoppes/json2xls"},"author":{"name":"Rikkert Koppes"},"license":"BSD-2-Clause","dependencies":{"excel-export":"~0.3.7"},"bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"_id":"json2xls@0.0.1","dist":{"shasum":"2bd77503e183ccd42c2f18637fc13b352c52e703","size":4062,"noattachment":false,"key":"/json2xls/-/json2xls-0.0.1.tgz","tarball":"http://registry.cnpm.dingdandao.com/json2xls/download/json2xls-0.0.1.tgz"},"_from":".","_npmVersion":"1.3.8","_npmUser":{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"},"maintainers":[{"name":"rikkertkoppes","email":"rikkert@rikkertkoppes.com"}],"directories":{},"_cnpmcore_publish_time":"2021-12-19T19:28:52.585Z","publish_time":1385231444940,"_cnpm_publish_time":1385231444940}},"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","_attachments":{},"homepage":"https://github.com/rikkertkoppes/json2xls#readme","bugs":{"url":"https://github.com/rikkertkoppes/json2xls/issues"},"license":"BSD-2-Clause"}