Handsontable example

HTML

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

CSS

</style><!-- Ugly Hack due to jsFiddle issue -->

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

JavaScript

var example = document.getElementById('example1');
  var hot = new Handsontable(example, {
    data: Handsontable.helper.createSpreadsheetData(10, 6),
    colWidths: 100,
    rowHeaders: true,
    colHeaders: true,
    afterChange: function(changes, src) {
      if (changes) {
        console.log(arguments)
      }
    },
    dropdownMenu: true,
    filters: true
  });

  hot.getPlugin('Filters').addCondition(1, 'by_value', [
    ['B1']
  ]);
  hot.getPlugin('Filters').filter();

  hot.updateSettings({})