Handsontable example
HTML
<div id="example1"></div>
<button class="add">Add data</button>
CSS
</style><!-- Ugly Hack due to jsFiddle issue -->
<script src="https://cdn.jsdelivr.net/npm/handsontable@7.4.2/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@7.4.2/dist/handsontable.full.min.css">
JavaScript
var example = document.getElementById('example1');
var hot = new Handsontable(example, {
data: Handsontable.helper.createSpreadsheetData(10, 3),
rowHeaders: true,
colHeaders: true,
persistentState: true,
manualColumnMove: true
});
/* setTimeout(function(){
hot.updateSettings({
colHeaders: false, //does not clear
data: [[6,7,8]]
})
}, 3000) */
document.querySelector('.add').addEventListener('click', function(){
hot.loadData([[1,2,3]])
})