{"_id":"xlgen","_rev":"33-2869e79662af45988cdb52f0924f1377","name":"xlgen","time":{"modified":"2022-06-29T05:27:10.231Z","created":"2014-03-13T06:22:15.330Z","0.0.1":"2014-03-13T06:22:17.400Z","0.0.2":"2014-03-13T07:17:51.427Z","0.1.0":"2014-03-13T23:59:51.497Z","0.2.1":"2014-06-09T12:57:36.247Z","0.2.2":"2014-07-09T09:06:51.594Z","0.2.3":"2016-02-22T12:30:46.238Z","0.2.3-1":"2016-02-22T12:48:40.137Z"},"description":"node.js's module to generate Microsoft Excel 97 ~ 2003 File(.xls)","readme":"# XLGen\r\nnode.js's module to generate Microsoft Excel™ 97 ~ 2003 File(.xls)\r\n\r\n## Features\r\n*  Excel 97 ~ 2003 File Format(.xls)\r\n*  pure javascript on node.js\r\n*  lightweight javascript module\r\n\r\n## Changelog\r\n### v0.2.3\r\n* fixed a bug\r\n  Sometimes, When only string values fill into cells Excel appear it in the incorrect order \r\n\r\n### v0.2.2\r\n* fixed issue#2  \r\n  Unable to create more than one sheet in a workbook\r\n\r\n### v0.2.1\r\n* added support for date - ivantodorovich  \r\n  convert javascript date value to excel raw value(number)\r\n* added support number and date formats  \r\n* modified to overwrite a cell value  \r\n\r\n### v0.1.0  \r\n* first release\r\n\r\n## API\r\n   * createXLGen( filePath)  \r\n   create a XLGen object\r\n     \r\n### XLGen class  \r\n   * formatStrings  \r\n      standard number format strings  \r\n      \r\n         formatStrings.general: 'General',\r\n         formatStrings.number0: '0',\r\n         formatStrings.number1: '0.00',\r\n         formatStrings.number2: '#,##0',\r\n         formatStrings.number3: '#,##0.00',\r\n         formatStrings.number4: '0%',\r\n         formatStrings.number5: '0.00%',\r\n         formatStrings.number6: '0.00E+00',\r\n         formatStrings.number7: '# ?/?',\r\n         formatStrings.number8: '# ??/??',\r\n         formatStrings.number9: '#,##0 ;(#,##0)',\r\n         formatStrings.number10: '#,##0 ;[Red](#,##0)',\r\n         formatStrings.number11: '#,##0.00;(#,##0.00)',\r\n         formatStrings.number12: '#,##0.00;[Red](#,##0.00)',\r\n         formatStrings.number13: '##0.0E+0',\r\n         formatStrings.date0: 'mm-dd-yy',\r\n         formatStrings.date1: 'd-mmm-yy',\r\n         formatStrings.date2: 'd-mmm',\r\n         formatStrings.date3: 'mmm-yy',\r\n         formatStrings.time0: 'h:mm AM/PM',\r\n         formatStrings.time1: 'h:mm:ss AM/PM',\r\n         formatStrings.time2: 'h:mm',\r\n         formatStrings.time3: 'h:mm:ss',\r\n         formatStrings.time4: 'mm:ss',\r\n         formatStrings.time5: '[h]:mm:ss',\r\n         formatStrings.time6: 'mmss.0',\r\n         formatStrings.dateTime: 'm/d/yy h:mm',\r\n         formatStrings.string: '@'\r\n\r\n   * addFormat(formatString)  \r\n      use to format a number and date type's value  \r\n      formatString : a format string for a number formatting  \r\n      return : a Format object  \r\n         \r\n   * addSheet(sheetName)  \r\n      sheetName : a sheet name  \r\n      return : a Sheet object  \r\n         \r\n   * end(callback)  \r\n      flush all into a file and clean up all resources associated with the object.  \r\n      after function 'end' has been called, cannot use xlg object again.  \r\n      callback(err) : call this after ending a flush  \r\n         \r\n### Sheet class  \r\n   * cell( rowIndex, colIndex, value, [format])  \r\n      input value into cell.  \r\n      rowIndex , colIndex: zero-based index  \r\n      value : allow a Number, String, Date Type's value  \r\n      format : *optional*, Format object added by addFormat function  \r\n             \r\n## Example  \r\n\r\n```js\r\nvar xl = require('xlgen');\r\nvar xlg = xl.createXLGen('./test.xls');\r\n\r\n//register formats\r\nvar fmtDate0 = xlg.addFormat(xl.formatStrings.date0);\r\nvar fmtDate1 = xlg.addFormat(xl.formatStrings.date1);\r\nvar fmtDate2 = xlg.addFormat(xl.formatStrings.date2);\r\nvar custfmtDate = xlg.addFormat('0.0000E+00');\r\n\r\nvar sht = xlg.addSheet('Sheet1');\r\n//var sht = xlg.addSheet('시트1');\r\n\r\nconsole.log(xl.formatStrings);//print all standard format strings\r\n\r\ntry{\r\n   sht.cell(0, 1, 1);\r\n   sht.cell(1, 1, 2.1);\r\n   sht.cell(2, 3, 'hi!');\r\n   sht.cell(3, 3, '안녕!');\r\n   sht.cell(5, 4, new Date);\r\n   sht.cell(6, 4, new Date, fmtDate0);\r\n   sht.cell(7, 4, 10000, fmtDate0);\r\n   sht.cell(8, 4, new Date, fmtDate1);\r\n   sht.cell(9, 4, new Date, fmtDate2);\r\n   sht.cell(10, 4, 9999, custfmtDate);\r\n}catch(e){\r\n   console.log(e.name, e.message);\r\n}\r\n\r\nxlg.end(function(err){\r\n   if(err) console.log(err.name, err.message);\r\n   else console.log('complete');\r\n});\r\n```\r\n\r\n## References\r\n  [[MS-XLS]: Excel Binary File Format (.xls) Structure](http://msdn.microsoft.com/en-us/library/cc313154(v=office.14).aspx)\r\n\r\n## License\r\nMIT\r\n","maintainers":[{"name":"gutkyu","email":"gutkyu@gmail.com"}],"versions":{"0.0.2":{"name":"xlgen","version":"0.0.2","description":"node.js's module to generate Microsoft Excel 97 ~ 2003 File(.xls)","main":"./lib/xlgen.js","directories":{"test":"test"},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"https://github.com/gutkyu/xlgen"},"keywords":["excel","xls","node.js","nodejs"],"author":{"name":"Sankyu Jung"},"license":"MIT","bugs":{"url":"https://github.com/gutkyu/xlgen/issues"},"_id":"xlgen@0.0.2","dist":{"shasum":"25e7f7b43d5368b838352423f9f301e1b658a1c2","tarball":"https://registry.npmjs.org/xlgen/-/xlgen-0.0.2.tgz","integrity":"sha512-wfA6Bl05m5GV/Vf1me3nAsHOWDyOVOrVrSB1+NIHIBmhef6Q+vajk2FwgAmGwDdr0QaFBpYC3hHORpPcP6zyfA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCM73EChjZFFM1jHpwt4YnAAAAqHM+8YkUB/ylShS4fVAIhALfrZlvdyXYjFICJMO9EADtanYluCy3xNXhR26WbFqzH"}]},"_from":".","_npmVersion":"1.3.8","_npmUser":{"name":"gutkyu","email":"gutkyu@gmail.com"},"maintainers":[{"name":"gutkyu","email":"gutkyu@gmail.com"}]},"0.1.0":{"name":"xlgen","version":"0.1.0","description":"node.js's module to generate Microsoft Excel 97 ~ 2003 File(.xls)","main":"./lib/xlgen.js","directories":{"test":"test"},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"https://github.com/gutkyu/xlgen"},"keywords":["excel","xls","node.js","nodejs"],"author":{"name":"Sankyu Jung"},"license":"Mit","bugs":{"url":"https://github.com/gutkyu/xlgen/issues"},"_id":"xlgen@0.1.0","dist":{"shasum":"66479b2c24655e1f4b28b360ccbf76f8f27f5a08","tarball":"https://registry.npmjs.org/xlgen/-/xlgen-0.1.0.tgz","integrity":"sha512-6k+eSF26obN6+2o2xrGLPiQQzalgm/gHH/PzFsPOEiMS1qu5qqePxWS1LG5M2ilevcVHyZ7A5kgcI/V8CK3V5Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDaluDNP+g3IlOkjjHhdD2ZlVuz3T5Ooz74KbZgJcYrBAIhAKyA8NUKJ52QYthVorvkIpqUSgvhPW5kz150Tgqb9qO/"}]},"_from":".","_npmVersion":"1.3.8","_npmUser":{"name":"gutkyu","email":"gutkyu@gmail.com"},"maintainers":[{"name":"gutkyu","email":"gutkyu@gmail.com"}]},"0.2.1":{"name":"xlgen","version":"0.2.1","description":"node.js's module to generate Microsoft Excel 97 ~ 2003 File(.xls)","main":"./lib/xlgen.js","directories":{"test":"test"},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"https://github.com/gutkyu/xlgen"},"keywords":["excel","xls","node.js","nodejs"],"author":{"name":"Sankyu Jung"},"license":"MIT","bugs":{"url":"https://github.com/gutkyu/xlgen/issues"},"_id":"xlgen@0.2.1","dist":{"shasum":"b652bb1041390213599cf4b3c950c3ae15897985","tarball":"https://registry.npmjs.org/xlgen/-/xlgen-0.2.1.tgz","integrity":"sha512-mjE60qw1ANXeAw1SxjNfRrXeoRpkomga/Fu+WGwmuSiqt1zrQHKopUbRBoqGPquaJVOsvE2Y7t3DcHTNpURn1A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBtjz81xgwh1q9h3YAryj6wXVl9DQ7mnsmWxEaC0PLviAiEAgE6cyK9yWha1xutcODiyTRS1PVu4DnAekw+4Y2VV4Go="}]},"_from":".","_npmVersion":"1.3.8","_npmUser":{"name":"gutkyu","email":"gutkyu@gmail.com"},"maintainers":[{"name":"gutkyu","email":"gutkyu@gmail.com"}]},"0.2.2":{"name":"xlgen","version":"0.2.2","description":"node.js's module to generate Microsoft Excel 97 ~ 2003 File(.xls)","main":"./lib/xlgen.js","directories":{"test":"test"},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"https://github.com/gutkyu/xlgen"},"keywords":["excel","xls","node.js","nodejs"],"author":{"name":"Sankyu Jung"},"license":"MIT","bugs":{"url":"https://github.com/gutkyu/xlgen/issues"},"_id":"xlgen@0.2.2","dist":{"shasum":"d02a23e30d389d3760e4ffb04cae868e1a5f2502","tarball":"https://registry.npmjs.org/xlgen/-/xlgen-0.2.2.tgz","integrity":"sha512-y7Fj7Vm84LZznhLlBG+CyVWhhdeUjl5GAH7TLM1NX8aMwNIrdLLQm7Tooo3ktPIRD3sBtF0Rg11nZVgrKQwx9Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDAkBOXZx7LEXO9mltaOgiLMcDCAygTWMcCNWQFHyoirwIgdakxZb+aEYVuTWnIwsN7yRsukDIpgD12BkCuR6F1KoI="}]},"_from":".","_npmVersion":"1.3.8","_npmUser":{"name":"gutkyu","email":"gutkyu@gmail.com"},"maintainers":[{"name":"gutkyu","email":"gutkyu@gmail.com"}]},"0.2.3":{"name":"xlgen","version":"0.2.3","description":"node.js's module to generate Microsoft Excel 97 ~ 2003 File(.xls)","main":"./lib/xlgen.js","directories":{"test":"test"},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"https://github.com/gutkyu/xlgen"},"keywords":["excel","xls","node.js","nodejs"],"author":{"name":"Sankyu Jung"},"license":"MIT","bugs":{"url":"https://github.com/gutkyu/xlgen/issues"},"gitHead":"ca774932e4c8a2ac60935c21ae6e5b342440fa15","homepage":"https://github.com/gutkyu/xlgen","_id":"xlgen@0.2.3","_shasum":"88bba627880625cbb85ae18b4f14fdb4d51f1cd9","_from":".","_npmVersion":"2.7.4","_nodeVersion":"0.12.2","_npmUser":{"name":"gutkyu","email":"gutkyu@gmail.com"},"maintainers":[{"name":"gutkyu","email":"gutkyu@gmail.com"}],"dist":{"shasum":"88bba627880625cbb85ae18b4f14fdb4d51f1cd9","tarball":"https://registry.npmjs.org/xlgen/-/xlgen-0.2.3.tgz","integrity":"sha512-SUIta+e6MpKXymJfqi50uxa7jSz7sWqIlJAxoYRCyxEbW+/6VXXh1EuhBsKgP9QmO0favYnWmSquLuuhldW7Vg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCID57si5/e07l25wAEkgUqPOj6dAy1m/2w9sVr7gE6M33AiEAuF1B4TpJiW0MPHoxB37oRaks66q7vLeiKIdbBiF8oAw="}]},"_npmOperationalInternal":{"host":"packages-9-west.internal.npmjs.com","tmp":"tmp/xlgen-0.2.3.tgz_1456144242162_0.08814174635335803"}},"0.2.3-1":{"name":"xlgen","version":"0.2.3-1","description":"node.js's module to generate Microsoft Excel 97 ~ 2003 File(.xls)","main":"./lib/xlgen.js","directories":{"test":"test"},"scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"repository":{"type":"git","url":"https://github.com/gutkyu/xlgen"},"keywords":["excel","xls","node.js","nodejs"],"author":{"name":"Sankyu Jung"},"license":"MIT","bugs":{"url":"https://github.com/gutkyu/xlgen/issues"},"gitHead":"ca774932e4c8a2ac60935c21ae6e5b342440fa15","homepage":"https://github.com/gutkyu/xlgen","_id":"xlgen@0.2.3-1","_shasum":"1168aaa979530423e577ee6f39b268edd7d2b993","_from":".","_npmVersion":"2.7.4","_nodeVersion":"0.12.2","_npmUser":{"name":"gutkyu","email":"gutkyu@gmail.com"},"maintainers":[{"name":"gutkyu","email":"gutkyu@gmail.com"}],"dist":{"shasum":"1168aaa979530423e577ee6f39b268edd7d2b993","tarball":"https://registry.npmjs.org/xlgen/-/xlgen-0.2.3-1.tgz","integrity":"sha512-QvysBHGCKNLpVqvwuDc3xQbB5KQIlQecPoD+l3AhebErxJv7mMKDhELWwfA33xeDMVq/hevNMK23DBxWmV4ROQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICmWOZiWIbWbgC40+x/wdMmrc6hzwz1pdZ27fidJrKwDAiAJtstKsSg/CJOCY9gR3f9HV4zohMDPLn7/F3t0lBiPdQ=="}]},"_npmOperationalInternal":{"host":"packages-9-west.internal.npmjs.com","tmp":"tmp/xlgen-0.2.3-1.tgz_1456145316469_0.40912971715442836"}}},"dist-tags":{"latest":"0.2.3-1"},"readmeFilename":"Readme.md","keywords":["excel","xls","node.js","nodejs"],"repository":{"type":"git","url":"https://github.com/gutkyu/xlgen"},"author":{"name":"Sankyu Jung"},"bugs":{"url":"https://github.com/gutkyu/xlgen/issues"},"license":"MIT","homepage":"https://github.com/gutkyu/xlgen"}