var dataHeader = $("#table_box").handsontable("getColHeader");  // 获取表头
var saveData = $("#table_box").handsontable("getData");  // 获取表数据$("#table_box").handsontable({colHeaders: ["年份", "男性", "女性"],data: [[2000, 1, 2], [2001, 3, 4], [2002, 5, 6], [2003, 7, 8], [2004, 9, 10]],mergeCells: [{row: 0, col: 0, rowspan: 3, colspan: 1}, {row: 3, col: 0, rowspan: 3, colspan: 1}, {row: 6, col: 0, rowspan: 3, colspan: 1}],  // 合并单元格stretchH: 'all',className: "htCenter",fillHandle: false, //禁止拖动fixedColumnsLeft:列数, //固定左侧多少列不能水平滚动renderAllRows: true,cells: function(row, column){var cellMeta = {};if(column == 0) {cellMeta.readOnly = true;  // 首列不可编辑}else{cellMeta.readOnly = false;cellMeta.validator = /^\d*\.?\d*$/;  // 输入验证}cellMeta.renderer = function(hotInstance, TD, row, column, prop, value,cellProperties){Handsontable.renderers.TextRenderer.apply(this, arguments);TD.style.background = '#386498';TD.style.border='1px solid #5062bd';TD.style.color = '#fff';TD.textContent = value;};return cellMeta;},afterValidate: function(isValid, value, row, prop, source) {  // 验证后if(!isValid) {// alert("请输入正确数字！");  // alert 会产生粘连}else{var sex = prop == 1 ? "male" : "female";qyspData[sex][row] = value * 1;}},afterChange: function(changes){if(!changes) {return ;}var res = /\D/g;console.log(res.test(changes[0][3]), changes[0][3], changes);if(res.test(changes[0][3])) {alert("请输入正确数字！");}else{console.log(defaultData.value[changes[0][0]]);defaultData.value[changes[0][0]] = changes[0][3] * 1;console.log(defaultData);}}
});

https://www.cnblogs.com/sily-boy/p/4761028.html      中文说明