{"_id":"workbook","_rev":"14-8f12f750c6a12f08954774fc433e1b41","name":"workbook","description":"description: Convenience wrapper for js-xlsx to incrementally build Excel workbooks programmatically","dist-tags":{"latest":"1.1.3"},"versions":{"1.0.0":{"name":"workbook","version":"1.0.0","description":"description: Convenience wrapper for js-xlsx to incrementally build Excel workbooks programmatically","main":"workbook.js","dependencies":{},"devDependencies":{"cheerio":"git://github.com/cheeriojs/cheerio","xlsx":"git://github.com/protobi/js-xlsx"},"scripts":{"test":"mocha"},"repository":{"type":"git","url":"https://github.com/protobi/workbook.git"},"author":"","license":"MIT","bugs":{"url":"https://github.com/protobi/workbook/issues"},"homepage":"https://github.com/protobi/workbook","gitHead":"770cc70983d141575a4d2689ab59c3dcf111ded0","_id":"workbook@1.0.0","_shasum":"c33322094a4e81cfde81c2f0db9a83ed567616c7","_from":"./","_npmVersion":"1.4.23","_npmUser":{"name":"protobi","email":"info@protobi.com"},"maintainers":[{"name":"protobi","email":"info@protobi.com"}],"dist":{"shasum":"c33322094a4e81cfde81c2f0db9a83ed567616c7","tarball":"https://registry.npmjs.org/workbook/-/workbook-1.0.0.tgz","integrity":"sha512-xBteYVcbqWW0DNgTMiUYF5BX2ehyp8QEZ9IoLvPJsWNSrSUTtFf8iUJo9u7HvtlEJwJ4BexAOAqby4mv0NYXnQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBBqJVdBZ5buc4LkeImaSG1DH7+8kW/pL3bQyQj+jBVKAiEAi9sfoi6ULxRyoNVPiDOVcv84sQcH7szHAiTp5rownPA="}]}},"1.0.1":{"name":"workbook","version":"1.0.1","description":"description: Convenience wrapper for js-xlsx to incrementally build Excel workbooks programmatically","main":"workbook.js","dependencies":{},"devDependencies":{"cheerio":"git://github.com/cheeriojs/cheerio","xlsx":"git://github.com/protobi/js-xlsx"},"scripts":{"test":"mocha"},"repository":{"type":"git","url":"https://github.com/protobi/workbook.git"},"author":"","license":"MIT","bugs":{"url":"https://github.com/protobi/workbook/issues"},"homepage":"https://github.com/protobi/workbook","gitHead":"40b94b928920021e493ebe0e78de485655182618","_id":"workbook@1.0.1","_shasum":"466289872137269819dd07373045fd1b30508043","_from":"./","_npmVersion":"1.4.23","_npmUser":{"name":"protobi","email":"info@protobi.com"},"maintainers":[{"name":"protobi","email":"info@protobi.com"}],"dist":{"shasum":"466289872137269819dd07373045fd1b30508043","tarball":"https://registry.npmjs.org/workbook/-/workbook-1.0.1.tgz","integrity":"sha512-G8kENsw5L4i7Nbs5eQVgfiU3sxinOQ3y9sw+ncdEaWQa5BLrAr9VeJqHIixz/3OFMkn6ph4e/jz04eDyZEcNlQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDezUGg641FOs2M1O2j4GuzkFDmapo6kNS3yJnbgFziZAIgV2UIEwimZx/sHJ7/CCw3CbuoBeE1uij50bNUqbCU3co="}]}},"1.0.2":{"name":"workbook","version":"1.0.2","description":"description: Convenience wrapper for js-xlsx to incrementally build Excel workbooks programmatically","main":"workbook.js","keywords":["xlsx","spreadsheet","excel","create"],"devDependencies":{"xlsx":"git://github.com/protobi/js-xlsx"},"scripts":{"test":"mocha"},"repository":{"type":"git","url":"https://github.com/protobi/workbook.git"},"author":"","license":"MIT","bugs":{"url":"https://github.com/protobi/workbook/issues"},"homepage":"https://github.com/protobi/workbook","gitHead":"9eabed05a70b42e4829c57ef20c8e2bb92a3c29e","_id":"workbook@1.0.2","_shasum":"96fa904e7fcfca25aa6b4f5b9c7031b084fab4a7","_from":".","_npmVersion":"2.7.5","_nodeVersion":"0.12.2","_npmUser":{"name":"protobi","email":"info@protobi.com"},"maintainers":[{"name":"protobi","email":"info@protobi.com"}],"dist":{"shasum":"96fa904e7fcfca25aa6b4f5b9c7031b084fab4a7","tarball":"https://registry.npmjs.org/workbook/-/workbook-1.0.2.tgz","integrity":"sha512-iFezSXmPQudQ8fnuJI1N+zGy49KMtjE+W+tfjqP4wZQLxj4glrfAvKTX4eQY/+9bP2FRAGkhXdKkTcjat352bw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBX4+ZYfqisjifktMv9OjAZ9QG7aMQI2idOWszJff54NAiA7BgVvztGULLovNKLMzil6C3QtYk7YLsZKe0iDpm1FyQ=="}]}},"1.1.0":{"name":"workbook","version":"1.1.0","description":"description: Convenience wrapper for js-xlsx to incrementally build Excel workbooks programmatically","main":"workbook.js","keywords":["xlsx","spreadsheet","excel","create"],"devDependencies":{"xlsx":"git://github.com/protobi/js-xlsx"},"scripts":{"test":"mocha"},"repository":{"type":"git","url":"https://github.com/protobi/workbook.git"},"author":"","license":"MIT","bugs":{"url":"https://github.com/protobi/workbook/issues"},"homepage":"https://github.com/protobi/workbook","gitHead":"31333eda1f5401d39b9a9e92551d9e603c6330c4","_id":"workbook@1.1.0","_shasum":"09444f5dc36be94b60be9226fc7dcdadeb8df03c","_from":".","_npmVersion":"2.7.5","_nodeVersion":"0.12.2","_npmUser":{"name":"protobi","email":"info@protobi.com"},"maintainers":[{"name":"protobi","email":"info@protobi.com"}],"dist":{"shasum":"09444f5dc36be94b60be9226fc7dcdadeb8df03c","tarball":"https://registry.npmjs.org/workbook/-/workbook-1.1.0.tgz","integrity":"sha512-RyF0IboqgshkeG7xu0PxlhYNpJDXM7fCToaEJOeehos1Q/qMpH7kgITDBkgVI7BN0xcN1yBzEP/oSVCbAmNIgg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDfXmUDdDMCLaUmvQQ0bRiNNSDAeasM2VXKzY1XrINdJwIhAKzaAjtV+/SWiW5e8kBVxrLa0nrPvVvpDznvDzUfOUBc"}]}},"1.1.1":{"name":"workbook","version":"1.1.1","description":"description: Convenience wrapper for js-xlsx to incrementally build Excel workbooks programmatically","main":"workbook.js","keywords":["xlsx","spreadsheet","excel","create"],"devDependencies":{"cheerio":"^0.19.0","json2csv":"^3.0.1","jszip":"^2.5.0","xlsx":"git://github.com/protobi/js-xlsx.git"},"scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+https://github.com/protobi/workbook.git"},"author":"","license":"MIT","bugs":{"url":"https://github.com/protobi/workbook/issues"},"homepage":"https://github.com/protobi/workbook","gitHead":"985a4b4c16f388e6c1a3843802644c72655591e5","_id":"workbook@1.1.1","_shasum":"2bf7a6afe8cd3e6419ce61cf243aeaa2f842a4fc","_from":".","_npmVersion":"2.14.4","_nodeVersion":"4.1.1","_npmUser":{"name":"protobi","email":"info@protobi.com"},"maintainers":[{"name":"protobi","email":"info@protobi.com"}],"dist":{"shasum":"2bf7a6afe8cd3e6419ce61cf243aeaa2f842a4fc","tarball":"https://registry.npmjs.org/workbook/-/workbook-1.1.1.tgz","integrity":"sha512-n+Mfqy0Nd1P5Po5xUmUmrkp/q2OwxL+BEysube5icdgWaDCDZetwhJ8pvpsYxCT3LY94toMxvBvwC1Qy589eFA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCw759tXubfJVwBcY5TqFefCOZNQuzloYpKseyztHV8JQIgGFA+SLePDvTYjjuAnx2b31+9vfwJpwL+fbbhlEhfPi0="}]}},"1.1.2":{"name":"workbook","version":"1.1.2","description":"description: Convenience wrapper for js-xlsx to incrementally build Excel workbooks programmatically","main":"workbook.js","keywords":["xlsx","spreadsheet","excel","create"],"devDependencies":{"cheerio":"^0.19.0","json2csv":"^3.0.1","jszip":"^2.5.0","xlsx":"git://github.com/protobi/js-xlsx.git"},"scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+https://github.com/protobi/workbook.git"},"author":"","license":"MIT","bugs":{"url":"https://github.com/protobi/workbook/issues"},"homepage":"https://github.com/protobi/workbook","gitHead":"d47508f2a4442ba5dbfad5f978a73033ff05c9f1","_id":"workbook@1.1.2","_shasum":"ba8810c9e75c651177d551e521323ade64c4caf0","_from":".","_npmVersion":"2.14.4","_nodeVersion":"4.1.1","_npmUser":{"name":"protobi","email":"info@protobi.com"},"maintainers":[{"name":"protobi","email":"info@protobi.com"}],"dist":{"shasum":"ba8810c9e75c651177d551e521323ade64c4caf0","tarball":"https://registry.npmjs.org/workbook/-/workbook-1.1.2.tgz","integrity":"sha512-3LZZvN+R3hWU7Vxxg/YVKtrZdtFYFLssB0v1DkqTGal7d6k1Uvc6YfOhwcOaiQRVs7j5CWXjVaT09ZxvRS0DOg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIG7SShwzMrqyHjeMmnpp8i5YDYXQK2pmAT+a6kOQNK1yAiA1IAe5kHkVzHvZ+Pni8e4N8SQJSrQ0kh+8BpaObqgtwg=="}]}},"1.1.3":{"name":"workbook","version":"1.1.3","description":"description: Convenience wrapper for js-xlsx to incrementally build Excel workbooks programmatically","main":"workbook.js","keywords":["xlsx","spreadsheet","excel","create"],"devDependencies":{"cheerio":"^0.19.0","json2csv":"^3.0.1","jszip":"^2.5.0","xlsx":"git://github.com/protobi/js-xlsx.git"},"scripts":{"test":"mocha"},"repository":{"type":"git","url":"git+https://github.com/protobi/workbook.git"},"author":"","license":"MIT","bugs":{"url":"https://github.com/protobi/workbook/issues"},"homepage":"https://github.com/protobi/workbook","gitHead":"4d15508a71ad27900b83cc21ba8a99727881e1bb","_id":"workbook@1.1.3","_shasum":"4029c91409351d18c569c46c999eabb1879f58bb","_from":".","_npmVersion":"2.14.4","_nodeVersion":"4.1.1","_npmUser":{"name":"protobi","email":"info@protobi.com"},"maintainers":[{"name":"protobi","email":"info@protobi.com"}],"dist":{"shasum":"4029c91409351d18c569c46c999eabb1879f58bb","tarball":"https://registry.npmjs.org/workbook/-/workbook-1.1.3.tgz","integrity":"sha512-KleT9AqmoO35B0gbmXu2iPYrxtfd952GFV2X57bMTY1DrqN02Vb0jmNo9J1T7eGgy2YCGVCbk70yvUN2woQ+2A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD1tKBiRD1ugtA7g/cO+BkXxuQ7bFotn+LoRbG8X1iPsAIhAK8yKiXImUs9eGQz8pnEhuzqBBh3UznZz73yRm2wVHPD"}]}}},"readme":"# workbook\nWrapper for [js-xlsx](https://github.com/SheetJS/js-xlsx) providing convenient way to accumulate sheets, rows, styles.\n\n[![NPM](https://nodei.co/npm/workbook.png?downloads=true&stars=true)](https://nodei.co/npm/workbook/)\n\n## Install\n\n* `npm install workbook --save`\n* `npm install js-xlsx --save` \n\nNote that exporting styles is still in development. In the interim, use the following development branch to export styles using the `.s` attribute instead:\n* `npm install protobi/js-xlsx --save` \n\n\n## Use\n\n```js\nvar XLSX = require('xlsx');\nvar Workbook = require('./workbook');\n\nvar workbook = new Workbook()\n    .addRowsToSheet(\"Main\", [\n      [\n        {\n           v: \"This is a submerged cell\",\n           s:{\n             border: {\n               left: {style: 'thick', color: {auto: 1}},\n               top: {style: 'thick', color: {auto: 1}},\n               bottom: {style: 'thick', color: {auto: 1}}\n             }\n             }\n        },\n        {\n             v: \"Pirate ship\",\n             s:{\n               border: {\n                 top: {style: 'thick', color: {auto: 1}},\n                 bottom: {style: 'thick', color: {auto: 1}}\n               }\n             }\n        },\n        {\n             v: \"Sunken treasure\",\n             s:{\n               border: {\n                 right: {style: 'thick', color: {auto: 1}},\n                 top: {style: 'thick', color: {auto: 1}},\n                 bottom: {style: 'thick', color: {auto: 1}}\n               }\n             }\n        }\n       ],\n      [\n        {\"v\": \"Blank\"},\n        {\"v\": \"Red\", \"s\": {fill: { fgColor: { rgb: \"FFFF0000\"}}}},\n        {\"v\": \"Green\", \"s\": {fill: { fgColor: { rgb: \"FF00FF00\"}}}},\n        {\"v\": \"Blue\", \"s\": {fill: { fgColor: { rgb: \"FF0000FF\"}}}}\n      ],\n      [\n        {\"v\": \"Default\"},\n        {\"v\": \"Arial\", \"s\": {font: {name: \"Arial\", sz: 24}}},\n        {\"v\": \"Times New Roman\", \"s\": {font: {name: \"Times New Roman\", sz: 16}}},\n        {\"v\": \"Courier New\", \"s\": {font: {name: \"Courier New\", sz: 14}}}\n      ],\n      [\n        0.618033989,\n        {\"v\": 0.618033989},\n        {\"v\": 0.618033989, \"t\": \"n\"},\n        {\"v\": 0.618033989, \"t\": \"n\", \"s\": { \"numFmt\": \"0.00%\"}},\n        {\"v\": 0.618033989, \"t\": \"n\", \"s\": { \"numFmt\": \"0.00%\"}, fill: { fgColor: { rgb: \"FFFFCC00\"}}},\n        [(new Date()).toLocaleString()]\n      ]\n    ]).mergeCells(\"Main\", {\n      \"s\": {\"c\": 0, \"r\": 0 },\n      \"e\": {\"c\": 2, \"r\": 0 }\n    }).finalize();\n\nvar OUTFILE = '/tmp/wb.xlsx';\nXLSX.writeFile(workbook, OUTFILE, {defaultCellStyle: { font: {name: 'Arial', sz: '12'}}});\nconsole.log(\"Results written to \" + OUTFILE)\n```\n\n","maintainers":[{"name":"protobi","email":"info@protobi.com"}],"time":{"modified":"2022-06-29T03:18:26.757Z","created":"2015-03-06T15:40:36.792Z","1.0.0":"2015-03-06T15:40:36.792Z","1.0.1":"2015-03-06T15:49:46.130Z","1.0.2":"2015-04-24T03:11:44.202Z","1.1.0":"2015-05-12T15:00:16.673Z","1.1.1":"2016-01-28T21:38:52.124Z","1.1.2":"2016-01-28T21:46:52.561Z","1.1.3":"2016-01-28T21:48:55.768Z"},"homepage":"https://github.com/protobi/workbook","repository":{"type":"git","url":"git+https://github.com/protobi/workbook.git"},"bugs":{"url":"https://github.com/protobi/workbook/issues"},"license":"MIT","readmeFilename":"README.md","users":{"knownasilya":true},"keywords":["xlsx","spreadsheet","excel","create"]}