{"_id":"js-excel-date-convert","_rev":"3-59764a8dab98de218aa1d7f5b4a91eaa","name":"js-excel-date-convert","dist-tags":{"latest":"1.0.2"},"versions":{"1.0.0":{"name":"js-excel-date-convert","version":"1.0.0","description":"Convert dates between JS and Excel formats","main":"js-excel-date-convert.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["excel","js","date","convert","1904"],"author":{"name":"Raschid JF Rafaelly","email":"hello@raschidjfr.dev"},"license":"ISC","gitHead":"07e2e39dbb7613fd5a0d86a197e099d108213621","_id":"js-excel-date-convert@1.0.0","_nodeVersion":"10.14.1","_npmVersion":"6.11.3","dist":{"integrity":"sha512-oe3+4f1rMv4zDjgpLUA6V9Cub4McffIbFBAXz22Gvsb/Qqvwr4Ysbxbh+fFccH8yFpCpCQQUURSzGH65tvNr/Q==","shasum":"a075b15805bf2603c296ca18e76e34abd5233b90","tarball":"https://registry.npmjs.org/js-excel-date-convert/-/js-excel-date-convert-1.0.0.tgz","fileCount":4,"unpackedSize":7318,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd5CwhCRA9TVsSAnZWagAAqhMP/Az5KjQbmWCPovZGXpP8\ngjxyGbBtitED6Hp6crDAdVSTXLVCvMX2z4CEYZ/3rQOpnYAW06nOiLzYbBMH\n/vCd59Rl/YDTbRYjzhQFClxxL0mdTp+PGkoL0bxV50F7ZU1d4LXbZyVNCZXK\nKzzzME6L4uNzsWqyCaIQi4So4fx8ONMYQFrBpJzP99YX3Be2Yj7t1uDgNyVn\nfI7Z9pI4L5aQyuoCn6gzVlaUrTC90ltUDX2wmPC+MWU1DJzmtJHP87zog5HD\nST5mV6TuKjaDwE3lZdgpDgI8TxbcyZ8tb150EH4Klgj+2Vx9Q1+NfKscvNNs\nkB+FoIpic4urgBPwMpKItoxKNvQSASl3oXi7hnUG8bXzI6ZYkwVShtia8N90\nCX521L68OO3KYEERSMLiXJMXLUH3M5oVQ9q7YC5V+ZMmEnvFyn/0XL7frXJa\ngxtZgfRPESyFGOqxEfcMm7xmDdFeuXanlDJ2nuDu7+UYj34ljT0akzP4HUMl\n9BX/YaDasnApHQQUSwLUdycuwvIlpNbVQ0+1QiQx1A/JWYH00t9maaonS+8d\n9fNAb1yC3hq82/lU7KluFTMDZs5Z4VcLFHK2cj+E3IpguMehFhJS32UUY8P4\nD+5c+LP/mxWYZDjG7xe8EkGmQAqpY+VrGPLsNaezT4S86xkY1DSwtNaMsuFu\nudAW\r\n=/j8K\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIE8TSzRYrfs73sAIyJBqwdUZHB2IO1CZD792CIbAEyJ9AiBZrokU/sMDUxfdhsFv4auIAUmyJ8pE64PZV8fjyZEe6g=="}]},"maintainers":[{"name":"raschidjfr","email":"lachachi@gmail.com"}],"_npmUser":{"name":"raschidjfr","email":"lachachi@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/js-excel-date-convert_1.0.0_1575234592862_0.2807517389314982"},"_hasShrinkwrap":false},"1.0.1":{"name":"js-excel-date-convert","version":"1.0.1","description":"Convert dates between JS and Excel formats","main":"js-excel-date-convert.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["excel","js","date","convert","1904"],"author":{"name":"Raschid JF Rafaelly","email":"hello@raschidjfr.dev"},"license":"ISC","gitHead":"dacf2a9636c3e35591ef9d31d9f8e411cf78160c","_id":"js-excel-date-convert@1.0.1","_nodeVersion":"10.14.1","_npmVersion":"6.11.3","dist":{"integrity":"sha512-VBVjR9/H22tj9T/jAM8iBbIRSfN0PpuYf6uCsMLVpmSQBm3UegN3MvJkQkcaH511bQ7Rj/vGAk7dnoxBDibzsA==","shasum":"80da2a27445ac576b7f9e45af1f033fe2c431909","tarball":"https://registry.npmjs.org/js-excel-date-convert/-/js-excel-date-convert-1.0.1.tgz","fileCount":4,"unpackedSize":7419,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd5C7kCRA9TVsSAnZWagAAuwsP/iJfGa3zov7UR5SpBqPJ\nG0bxAY1/M/zYKK81OSV9eWkfgaevz7iEL6oD9wrqFU/k4O+CMUOvygWK9I8+\nePFXSR5FxuS9H7GdUWRTdtmIfimzKYxfzfEJXAUc0a45iDBoHgFhK0701XCd\ncs/7+2IIVnvybLOrwnpTDP61aAowuS39Nue8x++YSG2RvI5jFTJv1FUaxlfr\nHjHh8L17oGrodCsvqn/Egq9El0uym8Ni2gBYr6Q/QFrgysKuB3ypTYWKiG6k\nStxegUk7Ue6rFBGfzTKz7yO06Fd5rj65HqmTQjl2vPgRwr8Y2O+YJU4LYJh0\nfZoJhsnT0USupHE+JwnW3yh5h1FEUOfrCs/LMH1lMMh9YV4TxIcggJfI1zbR\nyLbENZZ84yuqpFyQixMk7iowkRV0ql8lYXheH9QFmqVHCmPs28GulzlVjYvA\n/goo2mfTFPZKy8oYR80aRx7wzbmjxHSlolyO5XKEmmtveYLRM4PDZwmcnfaw\noOQuHg+VvmFl/3nTRoHNE7axC7Bhdfj6oXlHFyk5mRqdairGI9UEWpF+Gnzd\nAoct2UyBMaOfFHYfIrNiMBiNUZ8JPwgtvxrAB6PqFar7MYEneyrq5AlNo66n\nELq2enBWEGqEUph5Zh5uOG4w7S/xK45aCRPuBVjdB57vqzBi4xdydyvNH1l0\nq02h\r\n=FvhZ\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIANng0XCMDAElrn11oxgeRmlRpx/57urWPNp78dEHe3GAiEAr+1GTpPl1yMaZYqZf9RAUETOoPUdh+UqPKYPHfYQzr4="}]},"maintainers":[{"name":"raschidjfr","email":"lachachi@gmail.com"}],"_npmUser":{"name":"raschidjfr","email":"lachachi@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/js-excel-date-convert_1.0.1_1575235300379_0.821672792749198"},"_hasShrinkwrap":false},"1.0.2":{"name":"js-excel-date-convert","version":"1.0.2","description":"Convert dates between JS and Excel formats","main":"js-excel-date-convert.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["excel","js","date","convert","1904"],"author":{"name":"Raschid JF Rafaelly","email":"hello@raschidjfr.dev"},"license":"ISC","gitHead":"dacf2a9636c3e35591ef9d31d9f8e411cf78160c","_id":"js-excel-date-convert@1.0.2","_nodeVersion":"10.14.1","_npmVersion":"6.11.3","dist":{"integrity":"sha512-ZjxmQoBVTLY0kFwL+FZmxLOjk5AMvepdo2Q20zVsvCsJr5zb/6B2mW1Z19J31RsWWYxodJ1ezVJaeWvypCn5yQ==","shasum":"49413075201a4aa4261e23d0b8ff8c7b5f78cf82","tarball":"https://registry.npmjs.org/js-excel-date-convert/-/js-excel-date-convert-1.0.2.tgz","fileCount":4,"unpackedSize":7485,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd6p/hCRA9TVsSAnZWagAATg8QAJ1HEQoKKAOo43Ns/+b8\nMytc+t+jGC8aezTFF4QU5VOtsl3vrfbFpvl5JnYqcSQoJb8R1kKIQXm72iu7\nx3ze7PN+SBSVMVVfyRFCHOYPLRugcaZHYo1rg88UsRc/G3O7D4/CPT/UGtGa\nAX2TeNjP8I4fKJAs/Hf5tERhWz5f/DM8YGQYccp/rAZLuVpvjaUwDCzCA3nt\nb8OTvJ8UNWBvoYUM1uG/4OdyJ4oFJ2yBMIiUFJlb1pjZNt/IvWcbmb5fXl2d\nDWJeA2ZebBR5vpGVtzZV7H9u30lvPYmYtIE73Nq6JrSV4y1/TXCbk4//HaU6\nVypevLWQ4SouVOgFnuFANtW/RM0xjvRvPThcQ+R0MRAJQ5+sOoY+cy/UEHZj\n3yxAFm9OlMcWAWvXeZxLgJAav4Y3nUwcvbn6TfujdSIpTp+G+TxF2vZUHzQQ\nWLCGHFG2MbzEv06rD0IMVsnz+T1KFjMM6bu2JdnJEsY9aWCjZvJaPnhXQM75\nRbugbJ8Q6v+xM8Cd5ynREgRpHIkCiflL8KP8guN81lm+GATiXnoSw7v+FShv\noPb5YzBxs93+cZLLDLbnYc9eoaL7tHkaMklJj5SqP1DAf+Z+LiEKMmz0HzeU\nEOzZVIy2xRxBg/TWGpVAfvpNxHRDryOyx7QEvPQlwd4D0K7QoHb+JbEDtYzH\nO5ix\r\n=mvIc\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDWXE+5c0xO99xiaTW4wzs2I2VgLxc5+M+1l/XcRHgo1AIhALRAJg3NdOLOyudfBvzRz+FVA5M+YZk9wxXEpwomE726"}]},"maintainers":[{"name":"raschidjfr","email":"lachachi@gmail.com"}],"_npmUser":{"name":"raschidjfr","email":"lachachi@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/js-excel-date-convert_1.0.2_1575657440487_0.25914411303040596"},"_hasShrinkwrap":false}},"time":{"created":"2019-12-01T21:09:52.862Z","1.0.0":"2019-12-01T21:09:52.968Z","modified":"2022-05-06T18:44:31.298Z","1.0.1":"2019-12-01T21:21:40.500Z","1.0.2":"2019-12-06T18:37:20.675Z"},"maintainers":[{"name":"raschidjfr","email":"lachachi@gmail.com"}],"description":"Convert dates between JS and Excel formats","keywords":["excel","js","date","convert","1904"],"author":{"name":"Raschid JF Rafaelly","email":"hello@raschidjfr.dev"},"license":"ISC","readme":"# 📆 Convert between Excel and JS dates\r\nThis script takes into consideration the [Leap-Year bug](https://docs.microsoft.com/en-us/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year) and the date difference between 1900 and 1904 [Excel Date Systems](https://docs.microsoft.com/en-us/office/troubleshoot/excel/1900-and-1904-date-system).\r\n\r\n# Usage\r\n\r\n```js\r\n// You can verify these results with the example at:\r\n// https://docs.microsoft.com/en-us/office/troubleshoot/excel/1900-and-1904-date-system\r\n\r\nconst toExcelDate = require('js-excel-date-convert').toExcelDate;\r\nconst fromExcelDate = require('js-excel-date-convert').fromExcelDate;\r\n\r\nconst jul = new Date('jul 5 1998');\r\n\r\ntoExcelDate(jul);  // 35981 (1900 date system)\r\n\r\ntoExcelDate(jul, true); // 34519 (1904 date system)\r\n\r\nfromExcelDate(35981); // \"Sun, 05 Jul 1998 00:00:00 GMT\"\r\n\r\nfromExcelDate(34519, true);  // \"Sun, 05 Jul 1998 00:00:00 GMT\"\r\n```\r\n\r\n## API\r\n\r\n### fromExcelDate(excelDate, date1904): `Date`\r\n| Param     | Type      | Required | Description                                                                                                                                                                                                                                                                                                                                                                                                                           |\r\n| --------- | --------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |\r\n| excelDate | `number`  | yes      | An integer number representing a date in Excel.                                                                                                                                                                                                                                                                                                                                                                                       |\r\n| date1904  | `boolean` | no       | Set this to `true` if the date is encoded in [1904 Date System](https://docs.microsoft.com/en-us/office/troubleshoot/excel/1900-and-1904-date-system). This is the default format for [Excel in MacOS](https://bettersolutions.com/excel/dates-times/1904-date-system.htm).<br><br> If you're using [SheetJS](https://sheetjs.gitbooks.io/docs/#dates) you can check which system the file is using by calling `wb.Workbook.WBProps.date1904` |\r\n\r\n### toExcelDate(date, date1904): `number`\r\n| Param    | Type      | Required | Description                                                                                                                                                                                                                                                                                                                                                                                                                     |\r\n| -------- | --------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |\r\n| date     | `Date`    | yes      | Date to encode into Excel format.                                                                                                                                                                                                                                                                                                                                                                                               |\r\n| date1904 | `boolean` | no       | If `true`, the date will be encoded to [1904 Date System](https://docs.microsoft.com/en-us/office/troubleshoot/excel/1900-and-1904-date-system). This is the default format for [Excel in MacOS](https://bettersolutions.com/excel/dates-times/1904-date-system.htm).<br><br>If you're using [SheetJS](https://sheetjs.gitbooks.io/docs/#dates) you can check which system the file is using by calling `wb.Workbook.WBProps.date1904` |\r\n\r\n## Credits ##\r\nRaschid JF. Rafaelly\r\n\r\n<https://raschidjfr.dev>\r\n","readmeFilename":"Readme.md"}