Handsontable example

by handsoncode

HTML

<div id="example1" class="hot handsontable htColumnHeaders"></div>

CSS

</style><!-- Ugly Hack due to jsFiddle issue -->

<script src="https://cdn.jsdelivr.net/npm/handsontable@9.0.1/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@9.0.1/dist/handsontable.full.min.css">
<script src="https://handsontable.com/docs/9.0.1/components/numbro/dist/languages.min.js"></script>

JavaScript

function getCarData() {
    return [
      {car: "Mercedes A 160", price_usd: 7000, price_eur: 7000},
      {car: "Citroen C4 Coupe", price_usd: 8330, price_eur: 8330},
      {car: "Audi A4 Avant", price_usd: 33900, price_eur: 33900},
      {car: "Opel Astra", price_usd: 5000, price_eur: 5000},
      {car: "BMW 320i Coupe", price_usd: 30500, price_eur: 30500}
    ];
  }
  var
    container = document.getElementById('example1'),
    hot= new Handsontable(container, {
    data: getCarData(),
    colHeaders: ['Car', 'Price (USD)', 'Price (EUR)', 'Price (YEN)'],
    columnSorting : true,
    licenseKey: 'non-commercial-and-evaluation',
    columns: [
      {
        data: 'car'},
      {
        data: 'price_usd',
        type: 'numeric',
        numericFormat: {
          pattern: '$0,0.00',
          culture: 'en-US' // this is the default culture, set up for USD
        },
        allowEmpty: false
      },
      {
        data: 'price_eur',
        type: 'numeric',
        numericFormat: {
          pattern: '0,0.00 $',
          culture: 'de-DE' // use this for EUR (German),
          // more cultures available on http://numbrojs.com/languages.html
        }
      },
       {
        data: 'price_eur',
        type: 'numeric',
        numericFormat: {
          pattern: '$0,0.00',
          culture: 'ja-JP' // use this for Yen (Japan),
          // more cultures available on http://numbrojs.com/languages.html
        }
      }
    ]
  });