Handsontable example
HTML
<div id="example1"></div>
<button class="btn">Load data</button>
CSS
</style><script src="https://docs.handsontable.com/pro/bower_components/handsontable-pro/dist/handsontable.full.min.js"></script><link type="text/css" rel="stylesheet" href="https://docs.handsontable.com/pro//bower_components/handsontable-pro/dist/handsontable.full.min.css">
JavaScript
document.addEventListener("DOMContentLoaded", function() {
var
container = document.getElementById('example1'),
hot = new Handsontable(container, {
data: Handsontable.helper.createSpreadsheetData(15, 10),
colHeaders: true,
columnSorting: true,
sortIndicator: true
});
var abc = [
[1, 2, 3],
[7, 8, 7],
[5, 2, 0]
]
var load = document.querySelector('.btn');
load.addEventListener('click', function() {
hot.loadData(abc);
hot.updateSettings({
columnSorting: false
});
setTimeout(function(){
hot.updateSettings({
columnSorting: true
})
}, 100)
})
});