Handsontable example
HTML
<div id="example1" class="hot handsontable htRowHeaders htColumnHeaders" style="height: 320px; overflow: hidden; width: 100%;" data-originalstyle="height: 320px; overflow: hidden; width: 100%;"></div>
CSS
</style><script src="https://cdn.jsdelivr.net/npm/handsontable@7.2.2/dist/handsontable.full.min.js"></script><link type="text/css"rel="stylesheet"href="https://cdn.jsdelivr.net/npm/handsontable@7.2.2/dist/handsontable.full.min.css">
JavaScript
var example = document.getElementById('example1');
var hot = new Handsontable(example, {
data: [{
id: 1,
name: "Ted Right",
address: "some data"
},
{
id: 2,
name: "Frank Honest",
address: "address 1"
},
{
id: 3,
name: "Joan Well",
address: "address 2"
},
{
id: 4,
name: "Gail Polite",
address: "some data 2"
},
{
id: 5,
name: "Michael Fair",
address: ""
}
],
rowHeaders: true,
contextMenu: true,
colHeaders: true,
dropdownMenu: true,
filters: true,
beforeRemoveRow: function(){
var row = arguments[0];
let obj = {};
for (let i = 0; i < this.countCols(); i++) {
obj[this.colToProp(i)] = this.getDataAtCell(row, i);
}
console.log(obj)
}
});