handsometable notes

{
          data: "xxx", 
          editor: 'select',
          selectOptions: {
            '0': 'P0',
            '1': 'P1',
            '2': 'P2',
          }
},
// handsontable/selectEditorSpec.js at b0802f78b5c4fbe0de9a9b9b4b5a013f2364f45a · handsontable/handsontable (github.com)

 

.handsontable('getSelected')
.handsontable('countRows')
.handsontable('getDataAtCell', i, j))
.handsontable('countCols')
.handsontable('setDataAtCell', 3, 2, ''); 

 

const container = document.querySelector('#example1');

const hot = new Handsontable(container, {
  data: Handsontable.helper.createSpreadsheetData(10, 10),
  width: 'auto',
  height: 'auto',
  rowHeaders: true,
  colHeaders: true,
  renderer: 'html',
  licenseKey: 'non-commercial-and-evaluation',
  beforePaste: function(){
      console.log(arguments)
  }
});

hot.setDataAtCell(0,0, `<img src="https://handsontable.com/docs/9.0/img/pages/introduction/javascript.svg" style="height: 20px;">`);
hot.setDataAtCell(1, 1, `<strong>Para</strong>`);
hot.setDataAtCell(2, 2, `<button class="test">Test</button>`);

 handsontable常用配置及遇到的坑 - 掘金 (juejin.cn)