Handsontable example

by jing coco

HTML

<script src="https://cdn.jsdelivr.net/npm/handsontable@12/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@12/dist/handsontable.full.min.css" /> 

<div id="example1" class="hot "></div>

JavaScript

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

const hot = new Handsontable(container, {
  data: Handsontable.helper.createSpreadsheetData(500, 100),
  height: 320,
  viewportRowRenderingOffset: 1,
  mergeCells: [
    { row: 0, col: 0, rowspan: 300, colspan: 1 },
    { row: 0, col: 1, rowspan: 1, colspan: 50 },
    
  ],
  licenseKey: 'non-commercial-and-evaluation'
});

console.log('First rendered row:', hot.view._wt.wtTable.getFirstRenderedRow());
console.log('Last rendered row:', hot.view._wt.wtTable.getLastRenderedRow());
console.log('First rendered column:', hot.view._wt.wtTable.getFirstRenderedColumn());
console.log('Last rendered column: ', hot.view._wt.wtTable.getLastRenderedColumn());
console.log('Number of cells to render:', hot.rootElement.querySelectorAll('.ht_master td').length);