Custom buttons
优质
小牛编辑
116浏览
2023-12-01
The alter method can be used if you want to insert or remove rows and columns using external buttons. You can programmatically select a cell using the selectCell and load new data by loadData function. The below button implements it.
document.addEventListener("DOMContentLoaded", function() { var data = [ ['', 'Tesla', 'Nissan', 'Toyota', 'Honda', 'Mazda', 'Ford'], ['2017', 10, 11, 12, 13, 15, 16], ['2018', 10, 11, 12, 13, 15, 16], ['2019', 10, 11, 12, 13, 15, 16], ['2020', 10, 11, 12, 13, 15, 16], ['2021', 10, 11, 12, 13, 15, 16] ]; var container = document.getElementById('example1'); var selectFirst = document.getElementById('selectFirst'); var removeFirstRow = document.getElementById('removeFirstRow'); var removeFirstColumn = document.getElementById('removeFirstColumn'); var resetState = document.getElementById('resetState'); var hot = new Handsontable(container, { rowHeaders: true, colHeaders: true, data: JSON.parse(JSON.stringify(data)) }); Handsontable.dom.addEvent(selectFirst, 'click', function () { hot.selectCell(0, 0); }); Handsontable.dom.addEvent(removeFirstRow, 'click', function () { hot.alter('remove_row', 0); }); Handsontable.dom.addEvent(removeFirstColumn, 'click', function () { hot.alter('remove_col', 0); }); Handsontable.dom.addEvent(resetState, 'click', function () { hot.loadData(JSON.parse(JSON.stringify(data))); }); });