Handsontable example

by handsoncode

HTML

<p>
  This demo below shows a table of 1 million cells (1000 x 1000):
</p>
<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><!-- Ugly Hack due to jsFiddle issue -->

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

JavaScript

var example = document.getElementById('example1');
  var hot1 = new Handsontable(example, {
    data: Handsontable.helper.createSpreadsheetData(1000, 1000), //row, columns
    colWidths: 100,
    width: '100%',
    dropdownMenu: true,
    filters: true,
    height: 320,
    rowHeights: 23,
    rowHeaders: true,
    colHeaders: true
  });