Handsontable example

by aszymanski

HTML

<script src="https://cdn.jsdelivr.net/npm/handsontable@12.1/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@12.1/dist/handsontable.full.min.css" /> 

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

JavaScript

const container = document.querySelector('#example1');

const myData = [{
    id: 1,
    name: 'John',
    surname: 'Jones',
    age: 33
  },
  {
    id: 2,
    name: 'Ann',
    surname: 'Thompson',
    age: 29
  },
  {
    id: 3,
    name: 'Tom',
    surname: 'Atkinson',
    age: 31
  }
]

const hot = new Handsontable(container, {
  data: myData,
  dropdownMenu: true,
  filters: true,
  columnSorting: true,
  rowHeaders: true,
  colHeaders: true,
  editor: false,
  columns: [{
    data: 'id'
  }, {
    data: 'name',
    renderer: function(instance, td, row, col, prop, value, cellProperties) {
      Handsontable.renderers.TextRenderer.apply(this, arguments);
      td.innerHTML = `${value} ` + myData[instance.toPhysicalRow(row)].surname
    }
  }, {
    data: 'age'
  }],
  licenseKey: 'non-commercial-and-evaluation'
});