Non-Partisan Magicians

    exceldate
    TypeScript icon, indicating that this package has built-in type declarations

    1.2.1 • Public • Published

    exceldate

    Codeship Status for floydnoel/exceldate

    exceldate is a simple date utility package which converts excel timestamps to JS dates. It was built from knowledge gathered in research of "how to convert spreadsheet dates to JavaScript dates?" It features a complete set of tests, no dependencies (except for testing), available types (via JSDoc and TypeScript definitions), and a permissive license. This library is maintained and improving since 2018. Feature requests or contributions are always welcome!

    Installation

    yarn add exceldate
    # or
    npm install exceldate

    Usage

    Check it out:

    const exceldate = require('exceldate')
    // Use it directly:
    const result = exceldate('1').toISOString(); // 1899-12-31T00:00:00.000Z
    const anotherResult = exceldate(4242.4242).toISOString(); // 1911-08-12T10:10:50.880Z
    
    // Use it with a callback:
    exceldate(9000, (err, res) => {
      if (!err) console.log(res.toISOString()) // 1924-08-21T00:00:00.000Z
    });
    
    // Note: the standard callback enables easy use with promise & async when desired.
    // First, import util and promisify exceldate.
    const util = require('util');
    const exceldateAsync = util.promisify(exceldate);
    // Then, use like a regular promise...
    const exceldateAsync(9000).then(console.log).catch(console.error);
    // ...or await the result when in async contexts.
    const result = await exceldateAsync(9000);

    Testing

    Prerequisites:

    • clone/download the repo
    • navigate to the repo: cd exceldate
    • install dev dependencies to test: yarn

    To test run yarn test

    TypeScript types

    Types are generated by the TypeScript compiler according to the tsconfig.json configuration settings. To regenerate the types, run yarn typegen

    License

    This is free and unencumbered software released "as is" into the public domain, without warranty of any kind. For more information, please refer to the LICENSE file and https://unlicense.org

    Keywords

    none

    Install

    npm i exceldate

    DownloadsWeekly Downloads

    18

    Version

    1.2.1

    License

    Unlicense

    Unpacked Size

    12.9 kB

    Total Files

    12

    Last publish

    Collaborators

    • floydnoel