JSPM – excel-style-dataformatter@1.0.2

Package Exports

excel-style-dataformatter

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (excel-style-dataformatter) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

#Excel-Style Javascript Data Formatter

##Current version supports

Number formatting (decimal form, fractional form, percents, etc.)
Date formatting (elapsed time, am/pm)
Predefined excel formats (Fixed, Standard, etc.)
Localization

#Usage

##CommonJS

npm install excel-style-dataformatter

import dataFormatter from 'excel-style-dataformatter';
const result = dataFormatter.format('99', 'Number', 'Currency');

####Creating your own instance

import { DataFormatter } from 'excel-style-dataformatter';
const options = { debug: true };
const dataFormatter = new DataFormatter(options);
const result = dataFormatter.format('123', 'Number', '[Red]0;[Green]0.0');

####Available options

debug {boolean}
locale {string}
transformCode {function}
UTCOffset {number|null} - UTC offset for dates in minutes

##Browser

<!DOCTYPE html>
<html>
<head>
  <script src="dist/excel-style-dataformatter.js"></script>
</head>
<body>
  <script>
    var result = dataFormatter.format('2013-05-22T13:19:59.000','DateTime','yyyy mm dd');
    document.write(result.value);

    // Creating your own instance
    var myDataFormatter = new DataFormatter({ debug: true });
    var myResult = myDataFormatter.format('13.4', 'Number', 'General');
    document.write(myResult.value);
  </script>
</body>
</html>

##AMD

<!DOCTYPE html>
<html>
<head>
  <script src="require.js"></script>
</head>
<body>
  <script>
    require(['dist/excel-style-dataformatter.js'], function() {

      require(['dataFormatter', 'DataFormatter'], function(dataFormatter, DataFormatter) {

        var result = dataFormatter.format('Test', 'String', '[>100][Red]0.0;[>10][Green]-0;[Blue]"Zero";@');
        document.write(result.value);

        // Creating your own instance
        var myDataFormatter = new DataFormatter({ debug: true });
        var myResult = myDataFormatter.format('0', 'Number', 'Yes/No');
        document.write(myResult.value);
      });

    });
  </script>
</body>
</html>