Handsontable example

by Alexandre Yembo

HTML

<button class="btn">Add row above</button>
<div id="example1"></div>

CSS

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

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

JavaScript

var example = document.getElementById('example1');
  var hot = new Handsontable(example, {
    data: [
    ['John', 'Smith', 19],
    ['Brian', 'Adams',  59]
    ],
    rowHeaders: true,
    colHeaders: ['Name', 'Surname', 'Age'],
    outsideClickDeselects: false
  });

document.querySelector('.btn').addEventListener('click', function(){
	//hot.alter('insert_row', hot.getSelectedLast()[0], 1);
  hot.setDataAtCell(hot.getSelectedLast()[0] - 1, 0, '-Name-');
   hot.setDataAtCell(hot.getSelectedLast()[0] - 1, 1, '-Surname-');
   hot.setDataAtCell(hot.getSelectedLast()[0] - 1, 2, '-Age-')
})