❤
npm
Sign UpSign In

excel-style-dataformatter
DefinitelyTyped icon, indicating that this package has TypeScript declarations provided by the separate @types/excel-style-dataformatter package

2.0.1 • Public • Published

Excel-Style Javascript Data Formatter

npm

Current version supports

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

Install

npm install excel-style-dataformatter

bower install excel-style-dataformatter

Usage

CommonJS

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

With locales

import DataFormatter from 'excel-style-dataformatter';
import ru from 'excel-style-dataformatter/lib/ru';
 
// Create instance with defined locales
const options = { locales: [ru] };
const dataFormatter = new DataFormatter(options);
 
// Switch locale
dataFormatter.setLocale('ru');
 
const result = dataFormatter.format('99', 'Number', 'Currency');

Browser

<script src="excel-style-dataformatter/lib/index.js"></script>
<script src="excel-style-dataformatter/lib/locales/ru.js"></script>
<script>
  // Create instance
  var dataFormatter = new window.DataFormatter({
    locales: [window.DataFormatter_ru]
  });
 
  // Default locale
  document.write(dataFormatter.format('123.44', 'Number', 'Currency').value);
 
  // Switch to russian
  dataFormatter.setLocale('ru');
  document.write(dataFormatter.format('123.44', 'Number', 'Currency').value);
</script> 

AMD

<script>
  require(['excel-style-dataformatter/lib/index', 'excel-style-dataformatter/lib/locales/ru'], function() {
 
    require(['DataFormatter', 'DataFormatter_ru'], function(DataFormatter, ru) {
      // Create instance
      var dataFormatter = new DataFormatter({ 
        locales: [ru] 
      });
 
      // Default locale
      document.write(dataFormatter.format('99', 'Number', 'Currency').value);
 
      // Switch to russian
      dataFormatter.setLocale('ru');
      document.write(dataFormatter.format('99', 'Number', 'Currency').value);
    });
 
  });
</script> 

Available options

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

API

  • .format(value, type, format)
  • .defineLocales(locales)
  • .setLocale(locale)
  • .setUTCOffset(offset)

Readme

Keywords

Package Sidebar

Install

npm i excel-style-dataformatter

Repository

github.com/Fakundo/Excel-Style-Javascript-DataFormatter

Homepage

github.com/Fakundo/Excel-Style-Javascript-DataFormatter#readme

Weekly Downloads

5,370

Version

2.0.1

License

MIT

Last publish

Collaborators

  • fakundo
Try on RunKit
Report malware